oracle8.1.6
begin
:1 := survey_response.new (
response_id => :response_id,
survey_id => :survey_id,
context_id => :survey_id,
creation_user => :user_id,
initial_response_id => :initial_response_id,
creation_ip => :creation_ip
);
end;
insert into survey_question_responses
(response_id, question_id, clob_answer)
values
(:response_id, :question_id, empty_clob())
returning clob_answer into :1
begin
content_item.delete(:old_item);
end;