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-29808: specified primary operator binding does not exist
PLS-00506: User Defined Constrained Subtypes are disallowed
ORA-16034: FROM parameter is incompatible with MANAGED recovery
ORA-30558: internal error [string] in function based index
ORA-00348: single-process redo failure. Must abort instance
PLS-00920: parameter plsql_native_library_dir is not set
ORA-28602: statement not permitted on tables containing bitmap indexes
ORA-19723: Cannot recreate plugged in read-only datafile string
TNS-01153: Failed to process string: string
ORA-01973: Missing change number
ORA-13228: spatial index create failed due to invalid type
ORA-09942: Write of ORACLE password file header failed.