XML Parsing Question

From: ExecMan <artmerar_at_yahoo.com>
Date: Mon, 30 Apr 2012 22:50:49 -0700 (PDT)
Message-ID: <011fde1a-df96-4a39-8dd3-b6c16e954301_at_g38g2000yqh.googlegroups.com>


I have a procedure that parses an XML file. It works fine. I use the following notations:

v_etf_tab(v_etf_tab.LAST).title := xslprocessor.valueOf(v_n,'/ ETF_Report/Title');
v_etf_tab(v_etf_tab.LAST).ticker := xslprocessor.valueOf(v_n,'/ ETF_Report/Tickers/Ticker');

However, they have just introduced a new XML file where the TICKER element can occur more than once:

<?xml version="1.0" encoding="ISO-8859-1" ?>
<ReportTypeDescription>Style Box ETF Report</ReportTypeDescription>

How can I go through all the TICKER tags and get those values using the XML parsing that Oracle provides? Is there some looping constructor? Received on Tue May 01 2012 - 00:50:49 CDT

Original text of this message