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-36632: (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.

1 Answers  


RMAN-05010: target database must be opened in READ WRITE mode for TSPITR

1 Answers  


ORA-07637: smsdbp: buffer protect option not specified when sga created

1 Answers  


ORA-23341: user function required

1 Answers  


IMG-00812: merged area queue initialization failed

1 Answers  






ORA-02815: Unable to attach shared memory

1 Answers  


PLS-00590: attempting to create a subtype UNDER a FINAL type

1 Answers  


ORA-09988: error while detaching SGA

1 Answers  


ORA-39751: partitioned table on both sides of PARTITIONED OUTER JOIN is not supported

1 Answers  


PLS-00394: wrong number of values in the INTO list of a FETCH statement

1 Answers   CSC,


ORA-12082: "string"."string" cannot be index organized

1 Answers  


TNS-00085: * reread - ask the process name to reread parameter files

1 Answers  


Categories