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.