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