Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Text operator INPATH question
Sully wrote:
> Hi,
>
> I have some XML stored (as a CLOB) which looks like this:
>
> <configObject>
> <attribute name="bnum">
> <value string="435353"/>
> </attribute>
> </configObject>
>
> I want to be able to use INPATH to search for
> the tag "value" whose attribute "string" has a value "435353"
> AND is a direct descendent of a tag "attribute"
> whose attribute "name" has a value "bnum"
>
> I've tried lots of different ways :-),
> like
>
> select * from myTable where contains(xml_col,
> 'bnum INPATH(//attribute[value/@string="435353"])',1)>0;
>
> but to no avail...
>
> I'd appreciate any pointers people may have.
>
> Cheers,
>
> Michael
How did you create the index? Is it CTXCAT or CTXCTX? In the first case, you'll either need to have the ctx service running, or rebuild the index ( parameters 'sync').
-- Regards, Frank van BortelReceived on Sun May 02 2004 - 13:47:27 CDT
![]() |
![]() |