Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

user12110856Oct 24 2013 — edited Jan 2 2014

Hi,

I'm getting this error occasionally when using a CONNECT BY query to generate a hierarchical XML. Using Oracle 10g. The action suggested is "Make 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." Not very helpful since I am using a CONNECT BY query which works fine 99% of the time. Appreciate any help.

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 30 2014
Added on Oct 24 2013
#pl-sql-xml-programming, #xml
2 comments
1,853 views