ORA-01000 error with text importer

[marybeth]

I used text importer to create a script which was inserting 284 records. About 2/3 of the way I received this error: ORA-01000 maximum open cursors exceeded. I added several commit statements throughout the script but it still happened. Any ideas as to what this means?

 

[Marco Kalter]

It probably means that you should increase the OPEN_CURSORS initialization parameter of this database instance. The default value is 50, which may be too low.

 

[marybeth]

Our open cursors are set to 255 which should be plenty. Any other ideas, or do you think this is a bug?

 

[Marco Kalter]

Maybe. What is your exact PL/SQL Developer version?

 

[marybeth]

My version is 7.0.0.1050 01.30119

 

[Marco Kalter]

Thanks, we'll check if there are any cursor leaks in this version.