Oracle Error PLS-00429: unsupported feature with RETURNING clause

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.