Database Error Messages

ORA-06547

RETURNING clause must be used with INSERT, UPDATE, DELETE, or MERGE statements.

Cause

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


Action

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