PLS Database Error Messages

PLS-00425: in SQL, function argument and return types must be SQL type

oracle

PLS-00425: in SQL, function argument and return types must be SQL type
Cause: When a stored function was called from a SQL statement, parameters of the wrong type were passed. To be callable from SQL statements, a stored function must meet several requirements, one of which is that its arguments have SQL datatypes such as CHAR, DATE, or NUMBER. None of the arguments can have non-SQL types such as BOOLEAN, TABLE, or RECORD.
Action: Make sure all the arguments in the function call have SQL datatypes.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/