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 |
TNS-12566: TNS:protocol error
ORA-27507: IPC error disconnecting from a port
ORA-27474: cannot give both an argument name and an argument position
ORA-39129: Object type string not imported. Name conflicts with the master table
ORA-12060: shape of prebuilt table does not match definition query
LPX-00220: the string "]]>" cannot occur in character data
RMAN-06493: only UNTIL TIME clause is allowed when performing a restore from autobackup, found: string
ORA-12924: tablespace string is already in force logging mode
ORA-14005: missing RANGE keyword
ORA-38492: invalid ALTER INDEX parameters clause "string"
ORA-29914: ODCIGETINTERFACES routine does not return required stream version
ORA-16124: transaction string string string is waiting on another transaction