PLS-00597: expression string in the INTO list is of wrong type

Cause: 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

Action: Use expression with correct datatype in the INTO clause.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/