In this post, you’ll learn more about the Oracle ErrorPLS-00597: expression ‘string’ in the INTO list is of wrong type with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PLS-00597: expression ‘string’ in the INTO list is of wrong type
Reason for the Error PLS-00597: expression ‘string’ in the INTO list is of wrong type
This exception is raised for the following errors:
– the expression in INTO clause of OPEN or RETURNING statement is neither of legal SQL datatypes nor of PL/SQL RECORD datatype
– a collection of records is used in INTO clause of OPEN or RETURNING statement.
– a record or a collection of records is used in BULK COLLECT INTO
How to fix the Error PLS-00597: expression ‘string’ in the INTO list is of wrong type ?
You can fix this error in Oracle by following the below steps
Use expression with correct datatype in the INTO clause