'ORA-22816: unsupported feature with RETURNING clause' error
650629Aug 29 2008 — edited Aug 29 2008Hi,
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