How can I run Toad from VBScript

From: RN <rlntemp-newsgroup_at_yahoo.com>
Date: 6 Oct 2006 08:59:43 -0700
Message-ID: <1160150383.502260.109520_at_m73g2000cwd.googlegroups.com>



[Quoted] Re: Oracle 9i / Toad 8.6

[Quoted] I have a situation where I need to launch Toad within a Batch environment to run 5 separate SQL scripts and export the data from these five scripts to five separate Excel Files. Example:
"Toad.exe","MySqlScript_1.SQL","MySql_1_Exported Data.XLS"
"Toad.exe","MySqlScript_2.SQL","MySql_2_Exported Data.XLS"
"Toad.exe","MySqlScript_3.SQL","MySql_3_Exported Data.XLS"
"Toad.exe","MySqlScript_4.SQL","MySql_4_Exported Data.XLS"
"Toad.exe","MySqlScript_5.SQL","MySql_5_Exported Data.XLS"

[Quoted] Does anyone have an example where they launched Toad in a 'batch mode' to run multiple scripts?
I am hitting brick walls in trying to do this.

I would welcome your examples/suggestions.

Thanks. Received on Fri Oct 06 2006 - 17:59:43 CEST

Original text of this message