Re: multiple queries in toad

Anon-o-mouse <Anonomouse_at_notmail.com> wrote in message news:<n2fbd0tsftq78gurhu82c90ma6fk8htll5_at_4ax.com>...
> On 19 Jun 2004 16:53:29 -0700, cambridgeways_at_hotmail.com
> (Cambridgeways) wrote:
>
> >I'm new to Toad (free version). I would like to execute a series of
> >SQL statements like this:
> >
> >select table_code, table_val from address_types;
> >
> >select table_code, table_val from name_types;
> >
> >When I select either one and select 'Execute Current SQL' it runs.
> >When I select 'Execute SQL All', I get an error 'ORA-00911: invalid
> >character' and the first statement is highlighted until the semicolon.
> > So it seems to be objecting to the semicolon. When I select 'Execute
> >SQL Window Via SQL Plus', both statements run successfully.
> >
> >Am I missing a setting somewhere that would allow Toad to understand
> >that I want multiple statements to run? Any help is appeciated.
>
>
> You need to select the execute as a script option.
>
> --
I tried this but nothing appears in the results grid. Received on Mon Jun 21 2004 - 01:46:14 CEST