Not sure what you mean by the power of Toad in the mere execution of a script, but there is also Toad Script Runner (TSR.exe) installed in the same directory
as Toad.exe which you can use in conjunction with your favorite iterator-supporting language.
From: droeschley_109 [mailto:email@example.com]
Sent: Tuesday, May 26, 2015 3:18 PM
Subject: [Toad for Oracle - Beta Discussion Forum] how to run a script, “looping” through a list of parameters
how to run a script, “looping” through a list of parameters
Thread created by droeschley_109
Is there any straight-forward method in Toad to a run a script multiple times passing in a different parameter for each iteration?
I have tried the Automation Designer List Iterator action with an Execute Script child action but I see no way to pass the %List Iterator1% variable to a script file.or a script text. I tried
a Parameter file, but that applies only to the Execute Script, and not the List Iterator. I see no way in Script Manager to do anything like this.
I know I can use the SQL*Plus method of spooling and executing a dynamically created script file, but I thought I’d check if there’s some way to do this via the power of Toad.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum
this post as spam/abuse.