AnsweredAssumed Answered

System.Runtime.InteropServices.ExternalException ...

Question asked by shaningesri on Sep 21, 2016
Latest reply on Sep 22, 2016 by shaningesri

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.

Outcomes