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.