PHP 4.0 Bug #4568: Too many open cursor when inserting large number of records

From: clau@hgc.com.hk Operating system: NT 4.0 Server PHP version: 4.0.0 Release PHP Bug Type: ODBC related Bug description: Too many open cursor when inserting large number of records 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