How can I use execute SQL to insert records to a Oracle table and looping through a list . I have tried calling the Startworkflow on list item, but it seems to insert the
same row over and over
Inside your workflow you will first do a Query List action to capture all the list items into a Collection variable. You will then use a For Each action to loop through the collection and inside of this loop using the Execute SQL statement to insert your records row by row.
Thanks
+7
I agree with Mike.
+1
It worked! Thanks
Great to hear 
please mark my answer as correct to close this one out.
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.