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 |
DRG-10701: preference string.string already exists
PLS-00306: wrong number or types of arguments in call to 'string'
RMAN-04008: WARNING from target database: string
ORA-32152: Cannot perform operation on a null number
QSM-00512: invalid summaries specified in the retention-list
ORA-39005: inconsistent arguments
SQL*Loader-00650: incomplete lob data written for column string, row number, table string
NNL-00266: Round trip time is string
ORA-02364: error writing to file: string
NNO-00709: failed delete of cache checkpoint file "string", cache flush may not work
ORA-16702: generic resource manager warning
TNS-00108: TNS_ADMIN not defined