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

NID-00001: Illegal command line syntax - parse error = (number)

1 Answers  


QSM-01005: no query rewrite when query has slave SQL

1 Answers  


NZE-28831: no data unit format

1 Answers  


RMAN-07522: CREATE TYPE privilege must be granted to user string

1 Answers  


ORA-32634: automatic order MODEL evaluation does not converge

1 Answers  


ORA-08117: Index Organized Table operation released its block pin

1 Answers  


ORA-29655: USING clause is incompatible with its supertype

1 Answers  


ORA-09857: smprset: vm_protect error while protecting pga.

1 Answers  


ORA-27201: skgfpcm: sbtpccommit returned error

1 Answers  


ORA-25450: error string during evaluation of rule set string.string

1 Answers  


NZE-29049: Unknown record

1 Answers  


ORA-40272: apply rules prohibited for this model mode

1 Answers  


Categories