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 |
ORA-09700: sclin: maximum number of latches exceeded
LCD-00219: nested include file [string] is too large
ORA-08464: input raw decimal data contains more than 42 digits
ORA-31621: error creating master process
ORA-07241: slemrd: read error.
NZE-28805: Cannot retrieve information from the data source.
QSM-02062: GROUP BY clause in mv
ORA-12026: invalid filter column detected
RMAN-06126: skipping offline file string
RMAN-06300: Report of files with less than number redundant backups
ORA-34487: (MXMAINT08) You cannot string values of non-unique concat dimension workspace object.
ORA-13705: There was a instance shutdown/startup between the snapshots in the range [string, string].