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 |
NNL-00266: Round trip time is string
ORA-31067: XML nodes must be updated with nodes of the same type
ORA-23354: deferred RPC execution disabled for "string" with "string"
ORA-15124: ASM file name 'string' contains an invalid alias name
ORA-00476: RECO process terminated with error
ORA-07390: sftopn: translate error, unable to translate file name.
KUP-11006: file truncated error in string
NNO-00334: region load failure: ROS admin_region type number unsupported
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
TNS-00207: Uptime : number days number hr. number min. number sec
IMP-00037: Character set marker unknown
ORA-16505: site ID is invalid