Using collections in OCI

Hi,

We've been trying for a while to read and write collections using the OCI api, but so far all we managed to do was write and read single records.

The only sample code we found that deals with collections is the following:

-----------
NAME: cdemocoll.c - collection demo program in OCI
DESCRIPTION: demo of insertion(bind) and selection(define) of collectioncolumns(nested table and varray) as named datatype SQLT_NTY using OCI interface.
-----------

This sample program works nicely, but the main problem is that it writes things to the database one record at a time; considering we are writing thousands of rows from Europe to a database located in America through a VPN, the latency is not acceptable.