Oracle Error ORA-22800: invalid user-defined type

Oracle Error Message

ORA-22800: invalid user-defined type

Reason for the Error

An attempt was made to use an incomplete type as a constructor.

Solution

Complete the type definition before using it in a query.