Re: Using host arrays in PLSQL

Hi Hicham,

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

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

Ok, makes sense .. just thought it might be some pointer that you only needed to set once.

Thanks alot

Regards,

Flemming Jans Received on Thu Oct 01 1998 - 00:00:00 CDT