How to fix the Oracle error PCC-02406: Expecting the form ‘RETURN[ING] REF INTO :‘ only?

In this post, you’ll learn more about the Oracle ErrorPCC-02406: Expecting the form ‘RETURN[ING] REF INTO :‘ only with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-02406: Expecting the form ‘RETURN[ING] REF INTO :‘ only

Reason for the Error PCC-02406: Expecting the form ‘RETURN[ING] REF INTO :‘ only

Cause: When using the RETURNING clause in an OBJECT CREATE statement, only a single ‘REF INTO :‘ 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.

How to fix the Error PCC-02406: Expecting the form ‘RETURN[ING] REF INTO :‘ only ?

You can fix this error in Oracle by following the below steps

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