Insert Data in XML format to Oracle Table
Hello All,
I have a requirement where data is coming in XML format and i need to insert it into the Oracle Table. For example I am receiving XML data in following format,
<Results>
<Row>
<BANK_ACCOUNT_ID>10010</BANK_ACCOUNT_ID>
<BANK_ID>300968</BANK_ID>
<LEGAL_ENTITY>Vision Operations</LEGAL_ENTITY>
<BANK_NAME>Bank of America</BANK_NAME>
<BANK_ACCOUNT_NUM>10271-17621-619</BANK_ACCOUNT_NUM>
<BANK_ACCOUNT_NAME>BofA-204</BANK_ACCOUNT_NAME>
<BRANCH_NAME>New York</BRANCH_NAME>
<CURRENCY_CODE>USD</CURRENCY_CODE>
<BALANCE_DATE>2007-11-09</BALANCE_DATE>
<LEDGER_BALANCE>432705900.56</LEDGER_BALANCE>
</Row>
<Row>
<BANK_ACCOUNT_ID>10091</BANK_ACCOUNT_ID>
<BANK_ID>300984</BANK_ID>
<LEGAL_ENTITY>Vision Industries</LEGAL_ENTITY>
<BANK_NAME>Barclay's Bank</BANK_NAME>
<BANK_ACCOUNT_NUM>70986798</BANK_ACCOUNT_NUM>
<BANK_ACCOUNT_NAME>Barclay's Bank Multi Currency-626</BANK_ACCOUNT_NAME>
<BRANCH_NAME>Reading</BRANCH_NAME>
<CURRENCY_CODE>GBP</CURRENCY_CODE>
<BALANCE_DATE>2007-11-14</BALANCE_DATE>
<LEDGER_BALANCE>24244085.24</LEDGER_BALANCE>
</Row>
<Row>
<BANK_ACCOUNT_ID>10127</BANK_ACCOUNT_ID>
<BANK_ID>300968</BANK_ID>
<LEGAL_ENTITY>SSC US 01</LEGAL_ENTITY>
<BANK_NAME>Bank of America</BANK_NAME>
<BANK_ACCOUNT_NUM>4898744</BANK_ACCOUNT_NUM>
<BANK_ACCOUNT_NAME>BofA SSC US 02-7188</BANK_ACCOUNT_NAME>
<BRANCH_NAME>New York</BRANCH_NAME>
<CURRENCY_CODE>USD</CURRENCY_CODE>
<BALANCE_DATE>2007-11-28</BALANCE_DATE>
<LEDGER_BALANCE>10783815.28</LEDGER_BALANCE>
</Row>
</Results>
I want to write PLSQL code which will receive this data with XML tags and insert it into Oracle Table. Is it possible using inbuilt XML functionalities provided in Oracle Database??
Please Guide..
Regards,
Priyanka