Multiple SQL commands in one batch

Hi,

I have managed to send multiple SQL commands in one batch to both MS SQL 
Server and Sybase ASE. But now I have to get data from an Oracle database, 
and this does no longer work as easy as I have got accustomed to.

I use a blank as a delimiter between the different SQL commands. Have also 
tried the ";" character which works in the Oracle Client tool SQL *Plus 
Worksheet, but it does not work when I use MS Query or ADO via Oracle ODBC 
Driver 9.0.1.4.0. I get the same result when I use a data source with 
driver "Microsoft ODBC for Oracle". I don't know if my problem is an issue 
of Oracle syntax, ODBC or something else.

When using a blank delimiter I get the message ORA-00933 (the SQL command 
incorrect ended, which I suppose mean that only the first SQL command is 
sent and/or read). When using the ";" character I get the message ORA-
00911 (bad character, which should mean the ";" character).

Thanks in advance for any help.

Inge
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].