Re: Problem with XML

If I run this in TOAD:

select extract(p.po, '//PURORD') p1 from po p;

I do see the correct content. However, all the attempts to retrive it return empty values:

select id, extract(p.po, '//PURORD/COMPANY') p0, extract(p.po, '//PURORD/PONUM') p01, extract(p.po, '//PURORD') p1 from po p

select id, extractValue(p.po, '/PURORD/COMPANY') p0, extractValue(p.po, '/PURORD/PONUM') p01 from po p
; Received on Wed May 24 2006 - 10:33:31 CDT