Oracle Solution for Error ora-19036

ORA-19036: Invalid query result set in newContextFromHierarchy()

What triggered the Error:

e result set of the query used in the newContextFromHierarchy() does not have the same property as the result set generated by a CONNECT BY query.

What should we do to fix it:

ke sure the query used in newContextFromHierarchy() is a CONNECT BY query or the query returns the result set have the same property as the result set generated by a CONNECT BY query.