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-19505: failed to identify file "string"
NID-00396: Reverting database ID from number to number
ORA-03239: maxextents (string) reached in LOB segment string.string subpartition string
ORA-07562: sldext: extension must be 3 characters
IMG-00810: boundary queue initialization failed
DGM-16952: unable to describe configuration
LFI-01519: llseek() failed(OSD return value = string) in string.
ORA-00348: single-process redo failure. Must abort instance
ORA-24157: duplicate variable name string
ORA-19610: directory block string is corrupt
NNO-00057: loading and verifying topology data
ORA-01319: Invalid Logminer session attribute