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-06780: TLI Driver: recv error code failed
TNS-01189: The listener could not authenticate the user
NNL-00217: Controller is sleeping for number seconds
ORA-03231: the INITIAL extent may not be deallocated
ORA-07587: spdcr: $CREPRC failure
ORA-31515: CDC change source string already exists
RMAN-20206: log sequence not found in the repository
ORA-32140: cannot peform this operation on stream
RMAN-06472: channel id string is automatically allocated
NNO-00306: server shutdown countdown aborted
ORA-32613: not a MODEL cell
ORA-23379: connection qualifier "string" is too long