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 |
PCC-02366: Command line argument MODE=ANSI may not be used with DBMS=V6
ORA-37102: (XSVPART02) Invalid partition name string.
ORA-13207: incorrect use of the [string] operator
ORA-32587: Cannot drop nonexistent string supplemental logging
PCC-02345: SQLCHECK=SEMANTICS must be given when embedded PL/SQL blocks are used
PCC-02372: FOR clause not allowed in SELECT statement
ORA-26086: direct path does not support triggers
ORA-16204: DDL successfully applied
ORA-31490: could not attach to LogMiner session
ORA-01598: rollback segment 'string' is not online
ORA-31039: XML namespace length string exceeds maximum string
CLSS-02207: error string getting status from vendor node monitor