I have a complex xml file containing two data level.

I have used xmltocursor("xmlfile", "test", 512) function to convert this file to cursor. Function is working. But It converted only outer part of xml. The inner xml part of this file starting with "TRANSACTION" keyword transfered as TRANSACTION field. The xlm file is below.

How can I transfer this file completely to cursor.

Thanks in advance

<?xml version='1.0' encoding='ISO-8859-9' ?><BANK_VOUCHERS><BANK_VOUCHER DBOP='INS'>
<DATE>27.03.2006</DATE><NUMBER>15370115761</NUMBER><DIVISION> 204</DIVISION><TYPE>3</TYPE><CREATED_BY>1</CREATED_BY><HOUR_CREATED>16</HOUR_CREATED><MIN_CREATED>03</MIN_CREATED><SEC_CREATED>33</SEC_CREATED><TRANSACTIONS><TRANSACTION>
<BANKACC_CODE>34 0601</BANKACC_CODE><ARP_CODE>3463</ARP_CODE><DATE>28.03.2006</DATE><TRCODE>3</TRCODE><MODULENR>7</MODULENR><DESCRIPTION>&#304;st.Bo&#287;aziçi.Perpa 3463 KODLU BAYII</DESCRIPTION>
<DEBIT>252000</DEBIT><AMOUNT>252000</AMOUNT><TC_XRATE>1</TC_XRATE>
</TRANSACTION></TRANSACTIONS></BANK_VOUCHER></BANK_VOUCHERS>