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

RMAN-06721: could not normalize path for file: "string"

1 Answers  


ORA-08463: overflow converting decimal number to Oracle number

1 Answers  


ORA-28155: user 'string' specified as a proxy is actually a role

1 Answers  


PCC-00118: Use of host variable initialization not supported by ANSI SQL

1 Answers  


ORA-24275: function 'string' parameter 'string' missing or invalid

1 Answers  






ORA-08192: Flashback Table operation is not allowed on fixed tables

1 Answers  


DRG-11410: could not insert into string result table

1 Answers  


ORA-13237: internal error during R-tree concurrent updates: [string]

1 Answers  


QSM-01060: illegal subquery in the HAVING clause

1 Answers  


NCR-04010: NCRR: Unable to contact Oracle Names Server

1 Answers  


ORA-27128: unable to determine pagesize

1 Answers  


ORA-03280: invalid DATAFILE filename specified

1 Answers  


Categories