oracle8.1.6
begin
:1 := survsimp_question.new (
question_id => :question_id,
survey_id => :survey_id,
sort_key => :sort_key,
question_text => empty_clob(),
abstract_data_type => :abstract_data_type,
presentation_type => :presentation_type,
presentation_alignment => :presentation_alignment,
active_p => :active_p,
required_p => :required_p,
context_id => :survey_id,
creation_user => :user_id
);
end;
select survsimp_choice_id_sequence.nextval as choice_id from dual