Bulk insertion in Oracle Table via SAP PO
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"?>
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.