multiple queries in toad

From: Cambridgeways <cambridgeways_at_hotmail.com>
Date: 19 Jun 2004 16:53:29 -0700
Message-ID: <e0774553.0406191553.4637d3d1_at_posting.google.com>

[Quoted] [Quoted] I'm new to Toad (free version). I would like to execute a series of [Quoted] 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. Received on Sun Jun 20 2004 - 01:53:29 CEST