Re: SQL-Commands in one big statement

Hopefully, someone else will reply to your post with a much more detailed technical answer relating to Oracle access via ADO but here's my 2c.

If you're thinking big picture and highly scalable application, you wouldn't wanna do that statement-by-statement insert of several thousand records. Just not fast enough. Consider using bulk/array inserts. Bind variables too. I'm almost certain ADO has some way of letting you do those.

"Tolle Meus" <spamschutz_at_muelltonne.de> wrote in message news:<cansot$4ac$07$1_at_news.t-online.com>...
> Hi,
> I have merged many sql-insert-statements in one big command-statement and
> have sent this big command-statement to a DBMS years ago. (I can't remember
> which DBMS it was - SQL-Server, Informix or Oracle)
>
> So now - I am working on a "Oracle 8.1.7"-version and have tried to repeat
> this. I tried to send many INSERT-Statement separated by an ";"-Sign to
> Oracle via ADO - but it failed to succeed.
>
> My Question:
> Is there a way to send more than only one SQL-command directly to oracle?
>
> Like: "INSERT into Table1 (..);INSERT into Table1 (..);INSERT into Table1
> (..);INSERT into Table1 (..);... "
>
> Thanx in advance
> Tolle
Received on Tue Jun 15 2004 - 22:10:57 CDT