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-28137: Invalid FGA audit Handler
ORA-24062: Subscriber table string inconsistent with queue table string
ORA-22613: buflen does not match the size of the scalar
ORA-30100: internal error [number]
NZE-29191: OID connection information not set
DRG-11515: not enough text key values
ORA-13857: Invalid module name
RMAN-04016: could not get OCI error handle
ORA-39047: Jobs of type string cannot use multiple execution streams.
ORA-01571: redo version string incompatible with ORACLE version string
PLS-00709: pragma string must be declared in package specification and body
ORA-37132: (XSCCOMP07) Incremental aggregation over the dense DIMENSION workspace object is not supported when aggregating a VARIABLE dimensioned by a COMPRESSED COMPOSITE.