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

DRG-12305: column string data type is not supported for index set columns

1 Answers  


DRG-12700: seed word must be a single word

1 Answers  


ORA-08323: scnmin: close of bias lock failed

1 Answers  


RMAN-06600: old RMAN configuration parameters:

1 Answers  


ORA-01036: illegal variable name/number

1 Answers  






DRG-12016: The target document for this operation has moved - continue?

1 Answers  


ORA-13623: The recommendation string is not valid for task string.

1 Answers  


ORA-21608: duration is invalid for this function

1 Answers  


IMG-00712: unable to write to destination image

1 Answers  


DRG-11830: Length Required

1 Answers  


ORA-09803: Allocation of string buffer failed.

1 Answers  


TNS-01109: Listener password encryption failed

1 Answers  


Categories