XML Database (MOSC)

MOSC Banner

XML query generates ORA-00604

edited Dec 10, 2012 10:36AM in XML Database (MOSC) 4 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center