PLS-00597 expression ' string ' in the INTO list is of wrong type
This is a PL/SQL and FIPS Message generated by PL/SQL. For more information about PL/SQL, refer to the PL/SQL User's Guide and Reference.
What is the cause of PLS-00597 from Oracle 11g ?
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 deal with PLS-00597 from Oracle 11g ?
Use expression with correct datatype in the INTO clause
Contacting Oracle support services ?
Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.
Linked Error Messages
- PLS-00589 no attributes found in object type " string "
- PLS-00590 attempting to create a subtype UNDER a FINAL type
- PLS-00591 this feature is not supported in client-side programs
- PLS-00592 the type of a object table must be an object type
- PLS-00593 default value of parameter " string " in body must match that of spec
- PLS-00594 the SELF parameter can be declared only as IN or as IN OUT
- PLS-00595 the TABLE operator is not allowed in this context
- PLS-00598 comparison of object with NULL using " string " is not allowed
- PLS-00599 SAMPLE percentage must be in the range [0.000001,100)
- PLS-00600 SAMPLE cannot be applied to a remote object
- PLS-00601 partition extended object names may only be used with tables
- PLS-00602 CUBE and ROLLUP may appear only in a GROUP BY clause
- PLS-00603 GROUPING function supported only with GROUP BY CUBE or ROLLUP
- PLS-00604 aggregate function is not allowed here
- PLS-00605 set operators are not yet supported as an argument to a MULTISET operator