6 Replies Latest reply: Nov 4, 2007 8:52 AM by mdrake-Oracle RSS

    ORA-20000 Oracle text error DRG-10599 column is not indexed

    450482
      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?