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-09841: soacon: Name translation failure.
ORA-10661: Invalid option specified
NZE-28829: no cipher type specified
LSX-00165: content type of "~S" must be simple type
ORA-13756: Cannot update attribute "string".
RMAN-06516: time specified in KEEP UNTIL clause must be be after today
PCC-02358: Identifier following ARRAYLEN must be the name of an array
ORA-31114: XDB configuration has been deleted or is corrupted
PCB-00311: Datatype equivalencing is an Oracle extension
PCC-00127: %s
PLS-00460: REPEATABLE subprogram 'string' has to be RNDS, WNDS, RNPS, and WNPS
ORA-09361: Windows 3.1 Two-Task driver unable to lock context area