Re: Help needed with "ORA-01000: maximum open cursors exceeded" error

>Every SQL statement requires at least one cursor, whether you explicitly
>declare it or not. Some cursors are implicitly defined.

Is there a way of reusing the cursors?

I am parsing a flatfile in my application and insert the data one row at a time.
Some flatfiles might contain millions of rows, i.e. I need to be able to insert millions of rows in one session. Received on Wed Apr 05 2006 - 13:54:57 CDT