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

ORA-19036: Invalid query result set in newContextFromHierarchy()
Cause: The 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.
Action: 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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:43

ORA-19036：在newContextFromHierarchy（）中设置的查询结果无效,
.原因：在newContextFromHierarchy（）中使用的查询的结果集不具有与CONNECT BY查询生成的结果集相同的属性。,
.操作：确保在newContextFromHierarchy（）中使用的查询是CONNECT BY查询，或者查询返回的结果集具有与CONNECT BY查询生成的结果集相同的属性。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题