How to fix the Oracle error PLS-00320: the declaration of the type of this expression is incomplete or malformed?

In this post, you’ll learn more about the Oracle ErrorPLS-00320: the declaration of the type of this expression is incomplete or malformed with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00320: the declaration of the type of this expression is incomplete or malformed

Reason for the Error PLS-00320: the declaration of the type of this expression is incomplete or malformed

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 … …

How to fix the Error PLS-00320: the declaration of the type of this expression is incomplete or malformed ?

You can fix this error in Oracle by following the below steps

Check the spelling of all identifiers in the declaration. If necessary, move the declaration so that it makes no forward references.