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 |
LCD-00203: missing keyword [string]
ORA-14130: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION
IMP-00001: respond with either string, string, RETURN or '.' to quit
RMAN-06201: Deleted string objects
ORA-02805: Unable to set handler for SIGTPA
CLSR-01002: Unable to process instance startup
TNS-00530: Protocol adapter error
ORA-27201: skgfpcm: sbtpccommit returned error
ORA-12201: TNS:encountered too small a connection buffer
ORA-29856: error occurred in the execution of ODCIINDEXDROP routine
ORA-06119: NETTCP: spurious client request
PLS-00145: duplicate external WITH CONTEXT specification in subprogram expression