Re: SQL? :multiple operations in one SQL query to oracle

Wrap them up in a begin end, to make a block. This is the same as if you were calling a stored procedure from VB (without using .execute), where the syntax is

begin <procedcedure call:; end;

Hope this helps.

Jim Tench

James Mercer <jpmercer_at_concentric.net> wrote in article <01bc8833$b596cd80$7cd09bcf_at_jpmercer.concentric.net>...
> When I type something like:
>
> select * from table1; select * from table2
>
> from VB or in the Oracle ODBC test program, I get an invalid character
> error (I'm assuming on the ';'). How else could I send two selects in
 one
> SQL statement?
>
> thanks,
> James Mercer
>
Received on Fri Jul 04 1997 - 00:00:00 CDT