Database Software

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-20000 Oracle text error DRG-10599 column is not indexed

450482Oct 31 2007 — edited Nov 4 2007

Hi
What am I doing wrong in my following statement - using INPATH to fetch value from xmltype column:

select extract(xmlcol,'/abc/ns1:def/ns1:oper/text()','xmlns:ns1="http://abcd.defg.org/"')
from table1
where contains(xmlcol,'2 INPATH (/abc/ns1:def/ns1:value)' )>0

In other words, I want to get the value of the operator where value tag (in xmltype col) contains the number 2.

I get the error:
ORA-20000 Oracle text error
DRG-10599 column is not indexed

What am I doing wrong here?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 2 2007

Added on Oct 31 2007

#performance-availability, #xml-db

6 comments

15,750 views