XPath query

[avjoshi]

Hi,

Not sure if this forun deals with XML. In not, please excuse my intrusion.

I am a complete Newbie to XML.

I registered the xml schema, which also created the XMLType table. (PurchaseOrder from Oracle Documentation) I alsoinserted one record into the table.

I can successfully extract the node using extract() function like so,

SQL> select extract(object_value,'/PurchaseOrder') from "PurchaseOrder2148_TAB";

EXTRACT(OBJECT_VALUE,'/PURCHASEORDER')
--------------------------------------------------------------------------------
<po:PurchaseOrder xmlns:xsi="[URL unfurl="true"]http://www.w3.org/2001/XMLSchema-instance"[/URL] xmlns:po
="[URL unfurl="true"]http://xmlns.oracle.com/xdb/documentation/purchaseOrder"[/URL] xsi:schemaLocation="h
ttp://xmlns.oracle.com/xdb/documentation/purchaseOrder [URL unfurl="true"]http://xmlns.oracle.[/URL]
com/xdb/documentation/purchaseOrder.xsd">
<Reference>SBELL-2002100912333601PDT</Reference>
<Actions>
<Action>
<User>SVOLLMAN</User>
</Action>
</Actions>
<Reject/>
.....
.....
</PurchaseOrder>

SQL>

And now I am trying to extract value of reference column when I don't get any results back,

SQL> select extractValue(object_value,'/PurchaseOrder/Reference') from "PurchaseOrder2148_TAB";


E
-

SQL>

What am I doing wrong?

Any help on this would be greately appreciated.

Thanks,
AJ

Anand