Oracle Error Message
ORA-06547: RETURNING clause must be used with INSERT, UPDATE, or DELETE statements
Reason for the Error
EXECUTE IMMEDIATE with a RETURNING clause is used to execute dynamic UPDATE, INSERT, or DELETE statements only.
Solution
use RETURNING clause in EXECUTE IMMEDIATE for INSERT, UPDATE, or DELETE statements only. For other statements, use USING clause instead.
