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-12555: TNS:permission denied
ORA-33300: (DBERR22) Analytic workspace string cannot be opened because it was last modified by an incompatible version of string.
ORA-00345: redo log write error block string count string
DRG-11516: user must be at least in role CTXUSER to perform this operation
ORA-02087: object locked by another process in same transaction
TNS-00093: argument is only supplied to either status or trace_on
ORA-19761: block size string is not valid for change tracking file
DRG-11819: Bad Request
ORA-28510: heterogeneous database link initialization failed
QSM-00517: Summary Advisor requires a COMPATIBLE setting of 8.1.0.0 or greater
LPX-00100: root element "~1S" does not match DTD root "~2s"
ORA-03293: Cluster to be truncated is a HASH CLUSTER