Home » Developer & Programmer » JDeveloper, Java & XML » Urgent Plzzzzzz!!!!!!
Urgent Plzzzzzz!!!!!! [message #183670] Fri, 21 July 2006 19:04 Go to next message
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: Urgent Plzzzzzz!!!!!! [message #183678 is a reply to message #183670] Sat, 22 July 2006 00:17 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Brilliant topic title! Next time, choose some real title. Besides, if it's urgent you're already too late.

MHE

Report message to a moderator

Re: Urgent Plzzzzzz!!!!!! [message #183681 is a reply to message #183670] Sat, 22 July 2006 00:48 Go to previous message
hobbes
Messages: 173
Registered: January 2006
Senior Member
@mrunalhshah: What does the XML data that you're querying look like?

Report message to a moderator

Previous Topic: Uploading File from JSP Application
Next Topic: XML Parsing returns null values
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 00:27:39 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.