XML Parsing Question

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" ?>
<ETF_Report>
<ReportFile>etf_research_mcg.pdf</ReportFile>
<Title>ETF_RESEARCH</Title>
<ReportType>3</ReportType>
<ReportTypeDescription>Style Box ETF Report</ReportTypeDescription>
<Tickers>
<Ticker>IWP</Ticker>
<Ticker>IVOG</Ticker>
<Ticker>MDYG</Ticker>
<Ticker>RFG</Ticker>
<Ticker>FNY</Ticker>
<Ticker>IJK</Ticker>
<Ticker>PXMG</Ticker>
<Ticker>VOT</Ticker>
<Ticker>JKH</Ticker>
<Ticker>FVL</Ticker>
</Tickers>
</ETF_Report>

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