Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Using xmltype.existsNode with an xml file which uses parameters
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