Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert Data in XML format to Oracle Table

Priyanka PawarOct 18 2012 — edited Oct 18 2012
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
This post has been answered by odie_63 on Oct 18 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2012
Added on Oct 18 2012
4 comments
6,477 views