Oracle Error Message
PLS-00597: expression ‘string’ in the INTO list is of wrong type
Reason for the Error
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
Solution
Use expression with correct datatype in the INTO clause