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-36632: (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
RMAN-05010: target database must be opened in READ WRITE mode for TSPITR
ORA-07637: smsdbp: buffer protect option not specified when sga created
ORA-23341: user function required
IMG-00812: merged area queue initialization failed
ORA-02815: Unable to attach shared memory
PLS-00590: attempting to create a subtype UNDER a FINAL type
ORA-09988: error while detaching SGA
ORA-39751: partitioned table on both sides of PARTITIONED OUTER JOIN is not supported
PLS-00394: wrong number of values in the INTO list of a FETCH statement
ORA-12082: "string"."string" cannot be index organized
TNS-00085: * reread - ask the process name to reread parameter files