How to fix the Oracle error PCC-02407: Object and REF types do not match?

In this post, you’ll learn more about the Oracle ErrorPCC-02407: Object and REF types do not match with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-02407: Object and REF types do not match

Reason for the Error PCC-02407: Object and REF types do not match

Cause: In an OBJECT CREATE or DEREF statement, the types of the given Object and its associated REF do not match.

How to fix the Error PCC-02407: Object and REF types do not match ?

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

Action: Make sure that the Object and its REF have the same type. The type information is generated by OTT and should appear in the header file which OTT creates.