Re: Using host arrays in PLSQL

Hi Hicham,

> >Is there any way I can use arrays or host arrays to INSERT/UPDATE/DELETE
> >for example 100 rows in one operation in PL/SQL (as you can do it in Pro
> >C)
>
> The following is an example that uses the array processing feature of
> Oracle 8.
>

Works great ... it doubled the performance in my script ! Thanks a lot

Do you know if I have to call the function bind_array for every bulk insert I make.
(I insert the same 100 array entries many times, but with different data.)

Regards, Flemming Received on Wed Sep 30 1998 - 00:00:00 CDT