PLS Database Error Messages

PLS-00231: function ‘string’ may not be used in SQL

oracle

PLS-00231: function 'string' may not be used in SQL
Cause: A proscribed function was used in a SQL statement. Certain functions such as SQLCODE and SQLERRM can be used only in procedural statements.
Action: Remove the function call from the SQL statement. Or, replace the function call with a local variable. For example, the following statement is illegal: 

INSERT INTO errors VALUES (SQLCODE, SQLERRM);

 However, you can assign the values of SQLCODE and SQLERRM to local variables, then use the variables in the SQL statement, as follows: 

err_num := SQLCODE; 

err_msg := SQLERRM; 

INSERT INTO errors VALUES (err_num, err_msg);

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/