PLS-00320: the declaration of the type of this expression is
incomplete or malformed
- 1 Answers
- 5702 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 |
PCC-02420: Incomplete (or missing) type specification
ORA-16517: the object handle is invalid
DRG-11532: error reading through end of line string for file string
RMAN-06094: datafile string must be restored
ORA-28180: multiple authentication methods provided by proxy
IMP-00003: ORACLE error number encountered
SQL-02147: ANSI Dynamic occurrence value out of range
TNS-12596: TNS:internal inconsistency
ORA-06435: ssaio: write error, unable to write requested block to database file.
UDE-00007: attempt to free unallocated memory
ORA-30371: column cannot define a level in more than one dimension
NCR-04018: NCRR: Unable to create the TNS address list
Oracle Errors 
