PLS-00231: function 'string' may not be used in SQL



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

Post New Answer

More Oracle Errors Interview Questions

ORA-24063: cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers

1 Answers  


SQL*Loader-00562: record too big

1 Answers  


ORA-04067: not executed, string does not exist

1 Answers  


KUP-00554: error encountered while parsing access parameters

1 Answers  


TNS-01406: ID: string

1 Answers  






ORA-19709: numeric parameter must be non-negative integer

1 Answers  


DRG-11729: phrase does not have any narrower terms of this type

1 Answers  


ORA-31161: element or attribute "string" cannot be stored out of line

1 Answers  


ORA-02803: Retrieval of current time failed

1 Answers  


ORA-01149: cannot shutdown - file string has online backup set

2 Answers  


ORA-13831: SQL profile name specified is invalid

1 Answers  


ORA-14630: subpartition resides in offlined tablespace

1 Answers  


Categories