Oracle Error PLS-00457: expressions have to be of SQL types

Oracle Error Message

PLS-00457: expressions have to be of SQL types

Reason for the Error

an expression of wrong type is in USING or dynamic RETURNING clause. In USING or dynamic RETURNING clause, an expression cannot be of non-SQL types such as BOOLEAN, INDEX TABLE, and record.

Solution

change the expression type to a SQL type.