In this post, you’ll learn more about the Oracle ErrorPCC-02322: found undefined identifier with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PCC-02322: found undefined identifier
Reason for the Error PCC-02322: found undefined identifier
Cause: An identifier used in a SQL statement was not defined. For example, a cursor name was referenced that had not been declared, or in a DECLARE CURSOR statement, a statement name was used that had not been PREPAREd.
How to fix the Error PCC-02322: found undefined identifier ?
You can fix this error in Oracle by following the below steps
Action: Provide a declaration for the variable and/or its type identifier.