oracle8.1.6
begin
:1 := survsimp_survey.new (
survey_id => :survey_id,
name => :name,
short_name => :name,
description => :description,
description_html_p => :description_html_p,
type => :type,
context_id => :package_id,
package_id => :package_id,
creation_user => :user_id
);
end;
select survsimp_variable_id_sequence.nextval from dual
select survsimp_logic_id_sequence.nextval from dual
insert into survsimp_logic
(logic_id, logic)
values
(:logic_id, empty_clob()) returning logic into :1