This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Oracle Procedure Snap runs as many as rows inserted in table

amit_saroha
New Contributor III

‎06-11-2022 07:03 AM

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?

0 Kudos
Reply
1 REPLY 1

Supratim
Contributor III

‎06-12-2022 10:40 PM

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

image

0 Kudos
Reply