Re: How can I run Toad from VBScript

"RN" <rlntemp-newsgroup_at_yahoo.com> schreef in bericht news:1160150383.502260.109520_at_m73g2000cwd.googlegroups.com...
> Re: Oracle 9i / Toad 8.6
>
> 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"
>
> 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.
>

RN,

I think Toad is not the right tool to do this. Never heard of 'running Toad in batch mode'. There must be better ways to generate Excel files from within the database, or at least generate output in a format that can be read by Excel.
If you use google and search on words like 'Excel', 'SQLplus', 'Oracle' I'm sure you'll find better solutions.
I'll give you one sneak preview:

A very simple way of doing this is to create a tab delimited report (chr(9) between each column) and spool a .xls data file within SqlPlus. This creates and excel-like file that can be opened directly by Excel. http://www.freelists.org/archives/oracle-l/01-2005/msg00284.html

If you still want to use Toad, be my guest... but I suggest you stop hitting brick walls! Keep it simple!

Robbert van der Hoorn
OSA it BV
The Netherlands Received on Fri Oct 06 2006 - 23:16:33 CEST