Oracle Error ORA-22808: REF dereferencing not allowed

Oracle Error Message

ORA-22808: REF dereferencing not allowed

Reason for the Error

An attempt was made to access an object type’s attributes by dereferencing a REF item.

Solution

Make the item an object type instead of a REF to an object type.