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

RMAN-08130: failover to copy on device type string

1 Answers  


ORA-06127: NETTCP: unable to change username

1 Answers  


RMAN-08124: keep attributes for the datafile/controlfile copy are changed

1 Answers  


ORA-02251: subquery not allowed here

1 Answers  


ORA-13231: failed to create index table [string] during R-tree creation

1 Answers  






EXP-00061: unable to find the outer table name of a nested table

1 Answers  


ORA-40222: data mining model export failed, job name=string, error=string

1 Answers  


ORA-32804: invalid value string, string should have form string

1 Answers  


ORA-06910: CMX: Cannot start oracle process on remote machine

1 Answers  


ORA-02738: osnpwrtbrkmsg: incorrect number of bytes written

1 Answers  


IMG-00549: invalid pixelOrder specfied

1 Answers  


DRG-12607: only ctxsys can create MULTI_COLUMN preferences

1 Answers  


Categories