Oracle Error Message
PLS-00429: unsupported feature with RETURNING clause
Reason for the Error
Cause:
– INTO clause and RETURNING clause cannot be use in the same statement
– RETURNING clause is currently not supported for object type columns, LONG columns, records, %rowtypes, remote tables and INSERT with subquery. This is as ORA-28815.
Solution
Use separate select statement to get the values.