Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Using xmltype.existsNode with an xml file which uses parameters

Re: Using xmltype.existsNode with an xml file which uses parameters

From: Ko van der Sloot <Ko.vanderSloot_at_uvt.nl>
Date: Wed, 14 Feb 2007 16:49:42 +0100
Message-ID: <d19b$45d32f97$89382996$19741@news1.tudelft.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US