PLS-00320: the declaration of the type of this expression is
incomplete or malformed
- 1 Answers
- 5515 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-09840: soacon: Name translation failure.
ORA-31105: User does not own lock "string"
ORA-16102: remote information is not available on the specified primary
NZE-28786: decryption of encrypted private key failure
ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-16784: The database object name given in property Dependency is incorrect.
TNS-04003: Syntax Error.
ORA-02427: create view failed
TNS-04044: Specified gateways do not exist.
ORA-13020: coordinate is NULL
ORA-31426: cannot modify active subscriptions
ORA-16180: number processes specified for MAX_PARALLEL_SERVERS is too small
Oracle Errors 
