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

ORA-01072: cannot stop ORACLE; ORACLE not running

1 Answers  


DRG-11533: improper value of column string

1 Answers  


ORA-36960: (XSFCAST27) The value of the string expression must be an odd number. You specified number.

1 Answers  


RMAN-06561: available space must be larger than number kb

1 Answers  


RMAN-06094: datafile string must be restored

1 Answers  






TNS-01203: Missing the account (string) specified by DEFAULT_USER_ACCOUNT in SID_DESC

1 Answers  


ORA-28665: table and partition must have same compression attribute

1 Answers  


PLS-00990: Index Tables of Cursor Variables are disallowed

1 Answers  


DRG-10801: cannot create an SQE for another user

1 Answers  


SQL*Loader-00108: Invalid number of logical records to load

1 Answers  


PCC-02362: Host variable not declared within SQL DECLARE section

1 Answers  


IMP-00086: TOID "string" not found in export file

1 Answers  


Categories