Oracle Procedure Snap runs as many as rows inserted in table

[amit_saroha]

Hi,
I am reading a CSV file, inserting data into a table, and then calling Oracle Procedure snap to process those inserted rows. Now, the problem is Oracle Procedure snap run as many times as rows inserted in the table.

Could you suggest how I can let all rows be inserted first and then only run the Oracle procedure snap?

[Supratim]

amit.saroha:

Procedure sna

@amit.saroha After oracle insert use Gate snap and use below config. You can add mapper if any validation required then call procedure snap.