PLS-00204: function or pseudo-column 'string' may be used
inside a SQL statement only



PLS-00204: function or pseudo-column 'string' may be used inside a SQL statement only..

Answer / guest

Cause: A pseudocolumn or proscribed function was used in a
procedural statement. The SQL pseudocolumns (CURRVAL, LEVEL,
NEXTVAL, ROWID, ROWNUM) can be used only in SQL statements.
Likewise, certain functions such as DECODE, DUMP, and VSIZE
and the SQL group functions (AVG, MIN, MAX, COUNT, SUM,
STDDEV, VARIANCE) can be used only in SQL statements.

Action: Remove the pseudocolumn reference or function call
from the procedural statement. Or, replace the procedural
statement with a SELECT INTO statement; for example, replace
bonus := DECODE(rating, 1, 5000, 2, 2500, ...); with the
following statement: SELECT DECODE(rating, 1, 5000, 2, 2500,
...) INTO bonus FROM dual;

Please add more information about this Error

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02046: distributed transaction already begun

1 Answers  


ORA-39301: schema does not exist or is in use

1 Answers  


ORA-16226: DDL skipped due to lack of support

1 Answers  


NID-00400: DBNEWID - Completed with errors.

1 Answers  


ORA-39088: file name cannot contain a path specification

1 Answers  






RMAN-06443: error upgrading recovery catalog

1 Answers  


ORA-30192: reserved for future use

1 Answers  


ORA-06265: NETNTT: break protocol error

1 Answers  


ORA-01270: %s operation is not allowed if STANDBY_PRESERVES_NAMES is true

1 Answers  


PCC-00135: Result Set Cursor usage is not standard SQL

1 Answers  


KUP-04090: big endian byte order mark found when little endian expected in string

1 Answers  


ORA-32510: cannot create watchpoint on unreadable memory

1 Answers  


Categories