Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

'ORA-22816: unsupported feature with RETURNING clause' error

650629Aug 29 2008 — edited Aug 29 2008
Hi,
I am getting a 'ORA-22816: unsupported feature with RETURNING clause' error now.
This is my SQL

declare
l_CALL_ID number;
begin
insert into webb.TRK_CALLS_VIEW
(USER_, ASSIGNED_TO, PROBLEM, SOLUTION, STATUS)
values
(:P3_USER_, :P3_ASSIGNED_TO, :P3_PROBLEM, :P3_SOLUTION, :P3_STATUS)
returning id into l_CALL_ID;

insert into webb.TRK_CALLS_TIME_VIEW
(CALL_ID, DATE_, TIME, TIME_ASSIGNMENT_TO)
values
(l_CALL_ID, to_date(:P4_DATE_,'MM/DD/YYYY'), :P4_TIME, :P4_ASSIGNED_TO);
end;

Does anyone know a solution to correcting this error?
I searched on the forum and on the web but there is very little info or confusing info.
Thanks
Kirk
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2008
Added on Aug 29 2008
7 comments
11,185 views