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 |
NNL-00264: Request forwarding is now disabled
ORA-02252: check constraint condition not properly ended
ORA-09888: osnTXtt: txipc channel creation failed
ORA-34021: (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.
SQL*Loader-00806: unknown record format specified for data file
RMAN-08091: channel string: specifying datafile(s) for proxy backup
LSX-00025: unknown group "~S"
ORA-30677: session is already connected to a debugger
ORA-13518: Invalid database id (string)
ORA-14169: invalid ALTER TABLE MODIFY SUBPARTITION option
NCR-04023: NCRR: Invalid object descriptor
NZE-28797: invalid key data type