Commit at the end of an insert into an Oracle table.

, ,
1

Hi There,

I created a component in Enterprise Integrator to insert into an Oracle table (from a flat file). Rows are inserted and a commit is performed on each row. Instead, I would like to have a COMMIT after all rows are inserted and not after insertion of each row. Anybody knows how to do this. I greatly appreciate your help in this matter.

Thanks.

Nour.

2

How are you doing the processing - are you doing an insert (in another integration component to the file processing)? If you publish an event for each row, you’ll end up with this. Try using a struct array and publishing one event containing all rows to be inserted, and in the Oracle component, put the insert into a loop step. It improves processing quite a lot (and shouldn’t do a commit for each row)

W

3

I tried it and it worked.

Thanks a lot.

Nour.