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..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-02014: GROUP BY expression other than a column

1 Answers  


RMAN-08182: channel string: validation complete, elapsed time: string

1 Answers  


LFI-00008: SLTS's initializing/terminating mutex failed for string.

1 Answers  


ORA-38463: invalid XML Tag list

1 Answers  


ORA-31527: could not find source column string for CDC change table string.string

1 Answers  






ORA-38431: could not evaluate subexpression "string" for rowid "string"

1 Answers  


LSX-00021: undefined element "~S"

1 Answers  


ORA-01920: user name 'string' conflicts with another user or role name

1 Answers  


ORA-23450: flavor already contains object "string"."string"

1 Answers  


ORA-27212: some entrypoints in Media Management Library are missing

1 Answers  


ORA-16164: LGWR network server host detach error

1 Answers  


ORA-31660: metadata filter name can not be defaulted

1 Answers  


Categories