Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Bulk insertion in Oracle Table via SAP PO

Hi Guys,

Can somebody please help me.

Basically, I have a requirement in which I have to insert 0.5 million records in the Oracle database.

I have tried inserting the record for 10,000 and it took around 10 minutes which is too long so I am wondering is there any way to insert the records in bulk.

I am using EOIO mechanism and tried the Batch mode in JDBC Receiver channel but no luck.

I have also tried various different way of insertion such as multiple Statement node or multiple access node but still the same result.

<?xml version="1.0" encoding="UTF-8"?>

<ns0:Test xmlns:ns0="http://test">

   <Statement>

      <dbTableName action="INSERT">

<table>TEST</table>

      <access>

           <MESSAGE_ID/>

           <ID>12345</ID>

     </access>

      <access>

           <MESSAGE_ID/>

           <ID>12345</ID>

     </access>

      <access>

           <MESSAGE_ID/>

           <ID>12345</ID>

      </access>

We tried to load the file through Oracle data loader and it took around 2 secs to load the data in the table.

Please suggest if this can be achieve without writing Stored Procedure.

Regards,

Asif

Not what you were looking for? View more on this topic or Ask a question