Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PCC-02406: Expecting the form 'RETURN[ING] REF INTO :<ref>' only



PCC-02406: Expecting the form 'RETURN[ING] REF INTO :<ref>' only..

Answer / guest

Cause: When using the RETURNING clause in an OBJECT CREATE
statement, only a single 'REF INTO :<host variable>' is
expected. This error occurs if the expression list to which
REF belongs is greater than one or if there are more than
one host variables supplied in the into list.

Action: Rewrite the RETURNING clause as per the given
specification.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PROT-00014: Oracle Cluster Registry to be downgraded has an earlier version

1 Answers  


ORA-38749: A media recovery has been started.

1 Answers  


ORA-00119: invalid specification for system parameter string

1 Answers  


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

1 Answers  


ORA-23541: tables do not match tables used while defining the redefinition

1 Answers  






ORA-07571: szrfc: $FIND_HELD failure

1 Answers  


LSX-00111: type "~S" contains invalid facets

1 Answers  


TNS-00147: Failed to start a pre-spawned pump.

1 Answers  


ORA-02242: no options specified for ALTER INDEX

1 Answers  


ORA-39079: unable to enqueue message string

1 Answers  


ORA-30131: number of keys being set exceeds allocation

1 Answers  


NCR-03005: NCRO: Orphan message

1 Answers  






Categories