Oracle Database 12c New Features

ORA-06547: RETURNING clause must be used with INSERT, UPDATE, or DELETE statements

ORA-06547: RETURNING clause must be used with INSERT, UPDATE, or DELETE statements


Cause:


EXECUTE IMMEDIATE with a RETURNING clause is used to execute dynamic UPDATE, INSERT, or DELETE statements only.



Action:


use RETURNING clause in EXECUTE IMMEDIATE for INSERT, UPDATE, or DELETE statements only. For other statements, use USING clause instead.