PLS-00231: function 'string' may not be used in SQL
Answer / guest
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);
Please add more information about this Error
Is This Answer Correct ? | 0 Yes | 1 No |
ORA-24063: cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers
SQL*Loader-00562: record too big
ORA-04067: not executed, string does not exist
KUP-00554: error encountered while parsing access parameters
TNS-01406: ID: string
ORA-19709: numeric parameter must be non-negative integer
DRG-11729: phrase does not have any narrower terms of this type
ORA-31161: element or attribute "string" cannot be stored out of line
ORA-02803: Retrieval of current time failed
ORA-01149: cannot shutdown - file string has online backup set
ORA-13831: SQL profile name specified is invalid
ORA-14630: subpartition resides in offlined tablespace