OCI: Array Interface - multiple inserts

Hi,

I would like to speed up my inserts but I have some difficulties understanding the OCI Array Interface.

I have say 1000 statements that all should be inserted into the same table.

Should I build an array of structs holding the values to be inserted, ie. I must allocate 1000 structs for the statements and then bind every statement to its own struct?

Should I have a bind handle for every struct or for every field in the struct?

If someone could show me an example I would be very happy.

Thanks in advance!

Br,

Ole Hansen Received on Wed Oct 16 2002 - 09:57:06 CEST