Re: Using host arrays in PLSQL

On Wed, 30 Sep 1998 17:35:13 +0200, Flemming Jans <fj_at_belle.dk> wrote:

>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
>

When you call bind_array, the contents of the tables are copied from your
private global area to the DBMS_SQL buffers. Consequently, any change you
make to your tables (arrays) should be followed by a bind_array call. Received on Wed Sep 30 1998 - 00:00:00 CDT