XML query generates ORA-00604
Problem query:
select po.product_order_id
from oasis.product_order po
where PO.product_order_detail.existsnode ('//serviceAttributesList/ns1:serviceAttribute[ora:contains(attributeName/text(),"BGP Input Filter")>0]','xmlns:ns1="http://www.powertel.com.au/Common/xsd" xmlns:ora="http://xmlns.oracle.com/xdb"')=1
order by product_order_id
from oasis.product_order po
*
ERROR at line 2:
ORA-29913: error in executing contains callout
ORA-20000: Oracle Text error:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
Schema was recently upgraded to 11.2.0.3 from 11.2.0.2 using data pump to load the schema into a fresh 11203 instance. The XMLTYPES where changed from CLOB in 11202 to XML BINARY. XDB was installed into the 11203 instance.
0