 XML to PLSQL [message #171160] |
Mon, 08 May 2006 15:36 |
ksoule
Messages: 13
Registered: November 2003
Location: Austin, TX
|
Junior Member |
|
|
I m reading from an XMl file and putting the data in Oracle Table. My Xml file has the following structure.
Root
+---Node 1
+---Node 2
+---Node 3
+--- Sub Node 1
+--- Sub Sub Node 11
+--- Sub Sub Node 12
+--- Sub Node 2
+--- Sub Sub Node 21
+--- Sub Sub Node 22
I want to Extract Sub Node 1 and process Sub Sub Node 11 and Sub Sub Node 12, with the value of Sub node 1. Then go down to Sub node 2 extract the value and process Sub Sub Node 21 and Sub Sub Node 22. But when I do
xslprocessor.selectNodes(Node_in,'/Root/Sub Node /Sub Sub Node'), where Node_in = Selected_Nodes (Doc_In, '/APPHDR/MEMBER'); It extract the sub sub node all together, so instead of having 2 processes per sub node, I have 4 processes when I navigate onto the Sub Node 1.
Note: the tag which represent sub node1 and sub node 2 is the same( ie Service). The tage which represent Sub Sub Node 11,12,21,22 is the same (ie Emp).
Could Some one Help me, I hope my request is clear.
Thanks. This is urgent. Please
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
