Problem with Cursor and Commit

I have a situation where I'm setting a cursor on a very large table (between 3 and 10 million records). I'm extracting data from each row in that table and writing it to a second table. I want to do a commit at some interval (about 1000 updates). The problem that I'm having is that performing the commit on the updates is closing the cursor on the 'input' table.

The apps are written in Pro-C on an HP-Unix box. Help, I don't really want to go 3 million recs without a COMMIT. Actually, I may be committed if I let that go into production. The program was written MODE=ORACLE. Received on Wed Mar 14 2001 - 20:56:15 CST