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

NNL-00987: Authoritative answers when authority: number

1 Answers  

---

ORA-02276: default value type incompatible with column type

1 Answers  

---

ORA-36997: (XSRELGID14) For variable or relation grouping ids, a level relation is needed when a level order valueset is specified.

1 Answers  

---

ORA-30044: 'Retention' can only specified for undo tablespace

1 Answers  

---

ORA-37043: (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.

1 Answers  

---

NNL-01063: Statistic counters next reset in: string

1 Answers  

---

ORA-32801: invalid value string for string

1 Answers  

---

TNS-12630: Native service operation not supported

1 Answers  

---

ORA-39043: Object type string is not supported for string jobs.

1 Answers  

---

ORA-19707: invalid record block number - string

1 Answers  

---

ORA-30500: database open triggers and server error triggers cannot have BEFORE type

1 Answers  

---

DRG-12602: index owner does not have access to user datastore procedure: string

1 Answers  

---