topic Re: System.Runtime.InteropServices.ExternalException ... in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/system-runtime-interopservices-externalexception/m-p/595280#M16006 <HTML><HEAD></HEAD><BODY><P>Our DB Admin increased the <SPAN style="color: #1e1e1e; background: white; font-size: 11.0pt;"> value of OPEN_CURSORS from 1000.&nbsp; Then problem was gone.&nbsp; Thanks for your reviewing.</SPAN></P></BODY></HTML> Thu, 22 Sep 2016 17:54:30 GMT ShaningYu 2016-09-22T17:54:30Z System.Runtime.InteropServices.ExternalException ... https://community.esri.com/t5/arcobjects-sdk-questions/system-runtime-interopservices-externalexception/m-p/595279#M16005 <HTML><HEAD></HEAD><BODY><P>In my ArcObjects AddIns project, there is function to update about 300+ records of a ITable or a FeatureClass stored in Oracle SDE database.&nbsp; As the program is executed for about 180 - 280 records, a System.Runtime.InteropServices.ExternalException throws out:</P><P style="margin: 2.0pt 0in 2.0pt 0in;"><SPAN style="font-size: 9.0pt; color: #1e1e1e; background: white;">{"Underlying DBMS error [ORA-00604: error occurred at recursive SQL level 1\nORA-01000: maximum open cursors exceeded\n] [TblName]"}</SPAN></P><P style="margin: 2.0pt 0in 2.0pt 0in;"><SPAN style="font-size: 9.0pt; color: #1e1e1e; background: white;">By referring to <SPAN style="font-size: 12.0pt;"><A href="http://support.esri.com/technical-article/000005807">http://support.esri.com/technical-article/000005807</A></SPAN>, our DBA <SPAN style="font-size: 11.0pt;">increased the value of OPEN_CURSORS from 300 to 600, and then re-started the Oracle DB.&nbsp; However the error still exists for updating ITable (but OK for FeatureClass).&nbsp; I will appreciate if you can share your experience for this bug.</SPAN></SPAN></P></BODY></HTML> Wed, 21 Sep 2016 11:15:47 GMT https://community.esri.com/t5/arcobjects-sdk-questions/system-runtime-interopservices-externalexception/m-p/595279#M16005 ShaningYu 2016-09-21T11:15:47Z Re: System.Runtime.InteropServices.ExternalException ... https://community.esri.com/t5/arcobjects-sdk-questions/system-runtime-interopservices-externalexception/m-p/595280#M16006 <HTML><HEAD></HEAD><BODY><P>Our DB Admin increased the <SPAN style="color: #1e1e1e; background: white; font-size: 11.0pt;"> value of OPEN_CURSORS from 1000.&nbsp; Then problem was gone.&nbsp; Thanks for your reviewing.</SPAN></P></BODY></HTML> Thu, 22 Sep 2016 17:54:30 GMT https://community.esri.com/t5/arcobjects-sdk-questions/system-runtime-interopservices-externalexception/m-p/595280#M16006 ShaningYu 2016-09-22T17:54:30Z