OraFAQ Forum: JDeveloper, Java & XML » XML Parsing returns null values

Home » Developer & Programmer » JDeveloper, Java & XML » XML Parsing returns null values

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

XML Parsing returns null values [message #183669]

Fri, 21 July 2006 18:26

mrunalhshah
Messages: 15
Registered: June 2006

Junior Member

I am trying to do XML Parsing
using the statement

select rx_id, 
       rx_record_x, 
       rx_record_y, 
       rx_request_number, 
       rx_action, 
       rx_catalog,
       extractValue(value(xmlType(rx.rx_attribute_xml)),   '/cXML/Request/OrderRequest/ItemOut/@lineNumber') att_line_number,
       extractValue(value(xml), '/Segment/@type') att_name
from rx, 
table (xmlsequence(extract(rx_attribute_xml, '/cXML/Request/OrderRequest/ItemOut/Distribution/Accounting/Segment'))) xml;

I am getting the output with all the columns mentioned above but the values for the column "att_line_number" returned at null.
Please help how get those values as well.
Thanks.

Report message to a moderator

Re: XML Parsing returns null values [message #183692 is a reply to message #183669]

Sat, 22 July 2006 02:59

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

I don't think anyone can answer this question without seeing some sample data. Can you post an example of what is in rx.rx_attribute_xml?

Report message to a moderator

Previous Topic:	Urgent Plzzzzzz!!!!!!
Next Topic:	Getting data from a file and pass it to a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 19:26:18 CDT 2024