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-28137: Invalid FGA audit Handler

1 Answers  


ORA-24062: Subscriber table string inconsistent with queue table string

1 Answers  


ORA-22613: buflen does not match the size of the scalar

1 Answers  


ORA-30100: internal error [number]

1 Answers  


NZE-29191: OID connection information not set

1 Answers  


DRG-11515: not enough text key values

1 Answers  


ORA-13857: Invalid module name

1 Answers  


RMAN-04016: could not get OCI error handle

1 Answers  


ORA-39047: Jobs of type string cannot use multiple execution streams.

1 Answers  


ORA-01571: redo version string incompatible with ORACLE version string

1 Answers  


PLS-00709: pragma string must be declared in package specification and body

1 Answers  


ORA-37132: (XSCCOMP07) Incremental aggregation over the dense DIMENSION workspace object is not supported when aggregating a VARIABLE dimensioned by a COMPRESSED COMPOSITE.

1 Answers  


Categories