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 |
PLS-00493: invalid reference to a server-side object or function in a local context
LPX-00274: can't import node type
TNS-01170: Event detection broke for address: string
RMAN-06067: RECOVER DATABASE required with a backup or created controlfile
ORA-32409: materialized view log on "string"."string" already excludes new values
ORA-06565: cannot execute string from within stored procedure
QSM-01025: materialized view, string, not found
LCD-00208: unexpected keyword in value list [string]
ORA-06533: Subscript beyond count
ORA-26091: requested direct path operation not supported
ORA-02825: Request on free list was not free
ORA-09953: scggc: unexpected return of a lock convert