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-12201: section group string already exists
ORA-19567: cannot shrink file string because it is being backed up or copied
ORA-09773: osnmgetdatmsg: message from host had incorrect message type
ORA-21609: memory being resized without being allocated first
NZE-28799: failure to allocate shared memory
ORA-01933: cannot create a stored object using privileges from a role
LSX-00235: invalid URI "~S"
LFI-00123: Cannot access file Sequentially and Randomly.
ORA-36665: (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.
PCC-00109: Dynamic SQL and PL/SQL are Oracle extensions to ANSI SQL
ORA-38464: expression set is not empty.
QSM-01565: equivalence, string, cannot compute measure, string, in the query