PLS-00320: the declaration of the type of this expression is
incomplete or malformed
- 1 Answers
- 5921 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: In a declaration, the name of a variable or cursor is
misspelled or the declaration makes a forward reference.
Forward references are not allowed in PL/SQL. A variable or
cursor must be declared before it is referenced it in other
statements, including other declarative statements. For
example, the following declaration of dept_rec raises this
exception because it refers to a cursor not yet declared:
DECLARE dept_rec dept_cur%ROWTYPE; CURSOR dept_cur IS SELECT
... ...
Action: Check the spelling of all identifiers in the
declaration. If necessary, move the declaration so that it
makes no forward references.
Please add more information about this Error
| Is This Answer Correct ? | 2 Yes | 0 No |
ORA-09218: sfrfs: failed to refresh file size
TNS-12583: TNS:no reader
ORA-01225: thread number string is greater than MAXINSTANCES string
DRG-12437: highlight table release failed
ORA-03222: average row size and row count must be greater than zero
KUP-04091: little endian byte order mark found when big endian expected in string
ORA-02808: Allocation of memory of open files array failed.
ORA-02855: Number of requests is less than the number of slaves
ORA-01192: must have at least one enabled thread
ORA-02024: database link not found
ORA-39022: Database version string is not supported.
NZE-28796: access method is not supported
Oracle Errors 
