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-02046: distributed transaction already begun
ORA-39301: schema does not exist or is in use
ORA-16226: DDL skipped due to lack of support
NID-00400: DBNEWID - Completed with errors.
ORA-39088: file name cannot contain a path specification
RMAN-06443: error upgrading recovery catalog
ORA-30192: reserved for future use
ORA-06265: NETNTT: break protocol error
ORA-01270: %s operation is not allowed if STANDBY_PRESERVES_NAMES is true
PCC-00135: Result Set Cursor usage is not standard SQL
KUP-04090: big endian byte order mark found when little endian expected in string
ORA-32510: cannot create watchpoint on unreadable memory