In my ArcObjects AddIns project, there is function to update about 300+ records of a ITable or a FeatureClass stored in Oracle SDE database. As the program is executed for about 180 - 280 records, a System.Runtime.InteropServices.ExternalException throws out:
{"Underlying DBMS error [ORA-00604: error occurred at recursive SQL level 1\nORA-01000: maximum open cursors exceeded\n] [TblName]"}
By referring to http://support.esri.com/technical-article/000005807, our DBA increased the value of OPEN_CURSORS from 300 to 600, and then re-started the Oracle DB. However the error still exists for updating ITable (but OK for FeatureClass). I will appreciate if you can share your experience for this bug.
Our DB Admin increased the value of OPEN_CURSORS from 1000. Then problem was gone. Thanks for your reviewing.