Oracle Error ORA-39785: SQL expressions returning ADT objects are not allowed in direct path

Oracle Error Message

ORA-39785: SQL expressions returning ADT objects are not allowed in direct path

Reason for the Error

The passed SQL expression returned a user-defined ADT which was not supported.

Solution

Remove the SQL expression.