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
);
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
:1 := content_item.new (
name => :name,
creation_ip => :creation_ip
);
end;
begin
:1 := acs_rel.new (
rel_type => 'user_blob_response_rel',
object_id_one => :user_id,
object_id_two => :item_id);
end;