Bulk insertion in Oracle Table via SAP PO

[Former Member]

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

[iaki_vila]

Hi Asif,

Have you tried the recommendation of this blog ?

Regards.

[Former Member]

that blog is not clear as how to use both INSERT and Select so if you know more about this blog then please let me know.