Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using xmltype.existsNode with an xml file which uses parameters
J Englert wrote:
> Hi all,
>
> I am trying to use xmltype.existsNode as part of a select to parse an
> xmltype variable. I've noticed that existsNode doesn't seem to be
> able to handle situations in which an element of the xmltype has
> paramters. Here is an illustration of the problem:
>
> select a.col1.existsNode('/OpGetListResponse')
> from jason_xml_test a
>
> returns 1 if the root element looks like this:
>
> <OpGetListResponse>
>
> and returns 0 if the root element looks like this:
>
> <OpGetListResponse xmlns="urn:AST_CDROMDrive" >
This is not a 'parameter' but an 'attribute', but ok,
what about something like:
a.col1.existsNode('/OpGetListResponse', 'AST_CDROMDrive' )
> Has anyone ever seen this before? If so, how did you work around it?
in case of a namespace declariation, existsNode needs an extra parameter!
> Thanks for the help,
> Jason
Ko vd Sloot
Tilburg Univerity
Received on Wed Feb 14 2007 - 09:49:42 CST