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

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with XML

Re: Problem with XML

From: <fordesperado_at_yahoo.com>
Date: 24 May 2006 08:49:20 -0700
Message-ID: <1148485760.799286.52390@j55g2000cwa.googlegroups.com> 





when I run



select id, existsNode(p.po, '//PURORD/COMPANY') p0, existsNode(p.po,


'//PURORD/PONUM') p01, extract(p.po, '//PURORD') p1 from po	p




I am gettting 0 for both existsNode calls, but for extract(p.po,


'//PURORD') I am gettting




<po:PURORD xmlns:po="http://www.oracle.com/ABCD.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.oracle.com/ABCD.xsd
http://www.oracle.com/ABCD.xsd">


  <PONUM>1001</PONUM>


  <COMPANY>ORACLE</COMPANY>


</po:PURORD>



What am I missing?
Received on Wed May 24 2006 - 10:49:20 CDT












Original text of this message













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