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 |
CLSR-00508: Invalid message number number
ORA-06915: CMX: unknown t_event in datarq
ORA-02311: cannot alter with COMPILE option a valid type with type or table dependents
IMP-00400: Warning: Object type "string"."string" already exists with a different typeid
ORA-01269: Destination parameter string is too long
TNS-04014: Current instance string is already started
RMAN-06454: duplexed backups require Enterprise Edition
ORA-03274: both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified
ORA-08001: maximum number of sequences per session exceeded
AMD-00153: error detaching workspace "string"
TNS-00230: Cannot start new pump process: string string Protocol Adapter errors:number
RMAN-20502: DELETE EXPIRED cannot delete objects that exist - run CROSSCHECK