oracle8.1.6
select decode(count(*),0,0,1) from survey_questions where question_id = :question_id
begin
:1 := survey_question.new (
question_id => :question_id,
section_id => :section_id,
sort_order => :sort_order,
question_text => empty_clob(),
abstract_data_type => :abstract_data_type,
presentation_type => :presentation_type,
presentation_alignment => :presentation_alignment,
presentation_options => :presentation_options,
active_p => :active_p,
required_p => :required_p,
context_id => :section_id,
creation_user => :user_id,
question_html_p => :question_html_p,
summary_type => :summary_type,
answer_description => :answer_description
);
end;