Re: multiple queries in toad

[Quoted] 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.

--