Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-18004: outline already exists

1 Answers  


ORA-02291: integrity constraint (string.string) violated - parent key not found

1 Answers   CTS,


ORA-13285: Geometry coordinate transformation error

1 Answers  


NNO-00321: statistic counter dump disabled

1 Answers  


ORA-16731: Error executing dbms_logstdby.unskip_txn procedure

1 Answers  






PLS-00247: LIBRARY name must be specified

1 Answers  


ORA-13266: error inserting data into table string

1 Answers  


LPX-00660: Not a well-formed document or external entity.

1 Answers  


ORA-01451: column to be modified to NULL cannot be modified to NULL

1 Answers  


RMAN-06487: changed proxy copy expired

1 Answers  


ORA-00448: normal completion of background process

1 Answers  


ORA-16543: invalid request made to broker

1 Answers  






Categories