Oracle Error ORA-22833: Must cast a transient type to a persistent type

Oracle Error Message

ORA-22833: Must cast a transient type to a persistent type

Reason for the Error

An attempt was made to use the transient type in the query result.

Solution

Cast the transient type to a structurally equivalent persistent type.