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


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-08533: restoring blocks of datafile string

1 Answers  


ORA-19999: skip_row procedure was called

1 Answers  


LSX-00285: referenced key "~S" is not defined

1 Answers  


RMAN-07509: List of Cataloged Files

1 Answers  


ORA-21707: pin duration is longer than allocation duration

1 Answers  






DRG-10831: can not insert into feedback table string

1 Answers  


ORA-13147: failed to generate MBR

1 Answers  


ORA-13441: GeoRaster metadata SRS error

1 Answers  


ORA-31521: CDC subscription string already subscribes to publication ID string column string

1 Answers  


ORA-38503: index already defined using the parameters

1 Answers  


NNL-01071: Command-line parameter file name: string

1 Answers  


ORA-06813: TLI Driver: the configured ethernet address is incorrect

1 Answers  






Categories