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 -> Using xmltype.existsNode with an xml file which uses parameters

Using xmltype.existsNode with an xml file which uses parameters

From: J Englert <jason.englert_at_paetec.com>
Date: 14 Feb 2007 05:23:27 -0800
Message-ID: <1171459407.281489.309650@l53g2000cwa.googlegroups.com>


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 Received on Wed Feb 14 2007 - 07:23:27 CST

Original text of this message

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