PLS-00204: function or pseudo-column 'string' may be used
inside a SQL statement only



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

Post New Answer

More Oracle Errors Interview Questions

TNS-12566: TNS:protocol error

1 Answers  


ORA-27507: IPC error disconnecting from a port

1 Answers  


ORA-27474: cannot give both an argument name and an argument position

1 Answers  


ORA-39129: Object type string not imported. Name conflicts with the master table

1 Answers  


ORA-12060: shape of prebuilt table does not match definition query

1 Answers  






LPX-00220: the string "]]>" cannot occur in character data

1 Answers  


RMAN-06493: only UNTIL TIME clause is allowed when performing a restore from autobackup, found: string

1 Answers  


ORA-12924: tablespace string is already in force logging mode

1 Answers  


ORA-14005: missing RANGE keyword

1 Answers  


ORA-38492: invalid ALTER INDEX parameters clause "string"

1 Answers  


ORA-29914: ODCIGETINTERFACES routine does not return required stream version

1 Answers  


ORA-16124: transaction string string string is waiting on another transaction

1 Answers  


Categories