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" >

Has anyone ever seen this before? If so, how did you work around it?

Thanks for the help,
Jason

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

On Feb 14, 10:49 am, Ko van der Sloot <Ko.vanderSl...@uvt.nl> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

Thanks for the help.

I actually had to use

a.col1.existsNode('/OpGetListResponse', 'xmlns=urn:HPD_Help_Desk')

but your suggestion put me on the right path.

Thanks again,
Jason