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
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
I agree with Mike.
It worked! Thanks
Great to hear please mark my answer as correct to close this one out.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.