Re: Inserting Rows in Bulk

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 3 Oct 2001 00:04:35 +0200
Message-ID: <trkfsnlttrlne2@news.demon.nl>

"FaheemRao" <faheemrao_at_yahoo.com> wrote in message news:43b58913.0110021349.2dc275f3_at_posting.google.com...
> I want to insert many rows in one Database Call.
>
> like in the Insert SQL statement
>
> insert table_name values(........);
>
> but this will insert only one row in the database.
>
> My Application code is inserting a huge amount of data at one time, so
> it is taking a longgggg time to insert thousands of records.
>
> My application is connected to Oracle through ODBC.
>
> so I need something through which I can insert X number of rows at one
> database call so to take les time.
>
> Any help wuld be apprecited..
>
>
> Thanks
>
>
> Faheem Rao

'My application is connected to Oracle through ODBC.'

So it will never be fast.
If you can, get rid of the ODBC driver and replace it by Oracle Objects for Ole (comes free with Oracle) aka OO4O.
OO4O has an array interface.
I doubt ODBC has this.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Tue Oct 02 2001 - 17:04:35 CDT