Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Berkeley DB XML
Performance & Availability
Berkeley DB Family
Berkeley DB XML
This discussion is archived
on Jan 23, 2012 6:34 PM by "Andrei Costache, Oracle-Oracle"
XML accessing nodelist elements within nodes
Jan 9, 2012 1:39 PM
I have an XML document structure (see example below) that contains an Nodelist element <SPs> of <SP> nodes
where each <SP> node itself contains a Nodelist element <SetDts> containing <SetDt>
Assuming have parsed the XML into a document called l_doc, can now successfully can get a list of the SP nodes
SP_nl := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(l_doc),'/Int86Data/SPs/SP');
and get a SP node (the first in this case) from the SP_nl nodelist
SP_n := dbms_xmldom.item(SP_nl, 0);
I now have the first SP node in SP_n. My question is What is the syntax for getting the SetDts NodeList
out of parent SP_n node.
I have tried the following but get error - ORA-01405: fetched column value is NULL
SetDt_nl := dbms_xslprocessor.selectNodes(SP_n,'/SetDts/SetDt')
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: XML accessing nodelist elements within nodes
"Andrei Costache, Oracle-Oracle"
Jan 23, 2012 6:34 PM
in response to
This is the Oracle Berkeley DB XML (BDB XML or DBXML) forum. You were likely looking to post your question on the Oracle XML DB (XMLDB) forum,