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-19567: cannot shrink file string because it is being backed up or copied
ORA-29305: cannot point-in-time recover tablespace 'string'
ORA-30356: the specified refresh method is not supported in this context
NNO-00710: server's cache will be dumped to the trace file in number seconds
ORA-12078: fast refresh of refresh group ID string failed
ORA-14503: only one partition name can be specified
UDE-00003: all allowable logon attempts failed
ORA-07621: smscre: illegal redo block size
ORA-23376: node string is not compatible with replication version "string"
ORA-02158: invalid CREATE INDEX option
NZE-28872: Invalid peer certificate format
NNL-00043: LDAP open failure