Answer / guest

Cause: The datatype specifier in a variable declaration does
not designate a legal type. For example, the %TYPE attribute
might not have been added to a declaration, as in DECLARE
my_sal emp.sal%TYPE; my_ename emp.ename; -- missing %TYPE
... When declaring a constant or variable, to provide the
datatype of a column automatically, use the %TYPE attribute.
Likewise, when declaring a record, to provide the datatypes
of a row automatically, use the %ROWTYPE attribute.

Action: Make sure the datatype specifier designates a legal
type. Remember to use the %TYPE and %ROWTYPE attributes when
necessary.

Please add more information about this Error

QSM-00510: statistics missing on materialized views

1 Answers  

---

ORA-32510: cannot create watchpoint on unreadable memory

1 Answers  

---

EXP-00003: no storage definition found for segment(number, number)

2 Answers  

---

ORA-00028: your session has been killed

1 Answers  

---

ORA-16116: no work available

1 Answers  

---

DRG-11435: primary key value is invalid

1 Answers  

---

ORA-14150: missing SUBPARTITION keyword

1 Answers  

---

ORA-02320: failure in creating storage table for nested table column string

1 Answers  

---

ORA-22313: cannot use two versions of the same type "string"

1 Answers  

---

NZE-29050: Installed client authentication mode is not supported.

1 Answers  

---

ORA-39137: cannot specify a TABLE_EXISTS_ACTION of string for a job with no metadata

1 Answers  

---

RMAN-06740: database name is not specified

1 Answers  

---