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: J Englert <jason.englert_at_paetec.com>
Date: 14 Feb 2007 11:30:09 -0800
Message-ID: <1171481409.333771.49760@k78g2000cwa.googlegroups.com>


On Feb 14, 10:49 am, Ko van der Sloot <Ko.vanderSl..._at_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 Received on Wed Feb 14 2007 - 13:30:09 CST

Original text of this message

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