Environment:
Oracle 8i on NT 4.0 Server with 2GB RAM and 700G Harddisk
PHP 3.6 on NT 4.0 Server with 2GB RAM and 160G Harddisk

We open a connection to Oracle database either through ODBC and OCI interface, and tried to update 30,000 records:

Procedure like:
open database connection;
loop over the available records in text file,
insert each records into Oracle
close database connection after finish

However, after inserting 200-300 records, it result in error like too many cursor opened

Then we modify the procedure to:
loop over the text file;
open connection;
insert one record;
close connection;
loop until finish;

This time it is bettre without error. However, still the program can insert 2,000-3,000 records only and then stop.

Is this generic problem, or there is a missing document to overcome this?

Regards,

Chun Lau