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-09909: Malloc of scratch buffer failed.
ORA-13276: internal error [string] in coordinate transformation
SQL*Loader-00255: Log file for error recovery not used by SQL*Loader
ORA-24095: invalid transformation, source type does not match that of the queue
ORA-16037: user requested cancel of managed recovery operation
ORA-36902: (XSAGDNGL43) In AGGMAP workspace object, the MODEL workspace object is not a model over a base dimension of the AGGMAP.
NNL-00893: Similar requests received: number
ORA-19688: control file autobackup format(string) for string does not have %F
ORA-12571: TNS:packet writer failure
ORA-09835: addCallback: callback port is already in a set.
ORA-24315: illegal attribute type
ORA-39019: invalid operation type string