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

LCD-00203: missing keyword [string]

1 Answers  


ORA-14130: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION

1 Answers  


IMP-00001: respond with either string, string, RETURN or '.' to quit

1 Answers  


RMAN-06201: Deleted string objects

1 Answers  


ORA-02805: Unable to set handler for SIGTPA

1 Answers  






CLSR-01002: Unable to process instance startup

2 Answers  


TNS-00530: Protocol adapter error

1 Answers  


ORA-27201: skgfpcm: sbtpccommit returned error

1 Answers  


ORA-12201: TNS:encountered too small a connection buffer

1 Answers  


ORA-29856: error occurred in the execution of ODCIINDEXDROP routine

2 Answers  


ORA-06119: NETTCP: spurious client request

1 Answers  


PLS-00145: duplicate external WITH CONTEXT specification in subprogram expression

1 Answers  


Categories