System.Runtime.InteropServices.ExternalException ...

987
1
09-21-2016 04:15 AM
ShaningYu
Frequent Contributor

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.

0 Kudos
1 Reply
ShaningYu
Frequent Contributor

Our DB Admin increased the value of OPEN_CURSORS from 1000.  Then problem was gone.  Thanks for your reviewing.

0 Kudos