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 |
RMAN-08130: failover to copy on device type string
ORA-06127: NETTCP: unable to change username
RMAN-08124: keep attributes for the datafile/controlfile copy are changed
ORA-02251: subquery not allowed here
ORA-13231: failed to create index table [string] during R-tree creation
EXP-00061: unable to find the outer table name of a nested table
ORA-40222: data mining model export failed, job name=string, error=string
ORA-32804: invalid value string, string should have form string
ORA-06910: CMX: Cannot start oracle process on remote machine
ORA-02738: osnpwrtbrkmsg: incorrect number of bytes written
IMG-00549: invalid pixelOrder specfied
DRG-12607: only ctxsys can create MULTI_COLUMN preferences