Oracle Error PLS-00387: INTO variable cannot be a database object

Oracle Error Message

PLS-00387: INTO variable cannot be a database object

Reason for the Error

An item in the INTO list of a FETCH or SELECT statement was found to be a database object. INTO introduces a list of user-defined variables to which output values are assigned. Therefore, database objects cannot appear in the INTO list.

Solution

Check the spelling of the INTO list item. If necessary, remove the item from the INTO list or replace it with a user-defined output variable.