文档解释
ORA-19035: Invalid select item of the query in newContextFromHierarchy()
Cause: The query does not have a number select item followed by an XMLType select item only.
Action: Make sure the result set of the query used in the newContextFromHierarchy() must have only two selected items: the first item must be number type and the second item must be XMLType.
ORA-19035: Invalid select item of the query in newContextFromHierarchy():
该错误提示出现在Oracle数据库操作时,指明查询中发生了一些非法操作。
官方解释
当尝试在给定的“Hierarchy”上下文上创建新的上下文,并且该Hierarchy中存在无效的查询项(SELECT)时,就可能引发ORA-19035: Invalid select item of the query in newContextFromHierarchy() 错误。
常见案例
场景一:
当查询的SELECT子句的个数不是1时,就可能会抛出ORA-19035: Invalid select item of the query in newContextFromHierarchy() 错误。例如:
SELECT * FROM test;
将会引发ORA-19035: Invalid select item of the query in newContextFromHierarchy() 错误。
场景二:
当查询的SELECT子句返回字段类型与Hierarchy上下文中要求的字段类型不匹配时,就可能会抛出ORA-19035: Invalid select item of the query in newContextFromHierarchy() 错误。
一般处理方法及步骤
1、确保SELECT子句的个数符合Hierarchy上下文的要求:
正确的查询格式如下:
SELECT FROM