ORA-01000:超出打开游标的最大数 的解决办法（C#）

C#包装了一个数据库操作类，提供一个批量执行sql的函数，执行中遇到【ORA-01000:超出打开游标的最大数 的解决办法】的错误。

查看MSDN的ADODB.Connection的函数Execute说明，发现是调用时一个参数的问题。下面是我包装的函数：

public bool ExecuteSql(string[] strSqlArray)        {            try            {                m_cn.BeginTrans();                for (int i = 0; i < strSqlArray.Length; i++ )                {                    object objAffected;                    m_cn.Execute(strSqlArray[i], out objAffected, 0); //参数【0】捣的鬼                }                m_cn.CommitTrans();                return true;            }            catch (System.Exception e)            {                MsgBoxCtrl.MsgBoxException(e.Message, "CDatabase.ExecuteSql");                if (m_cn.State == (int)ConnectionState.Open)                {                    try                    {                        m_cn.RollbackTrans();                    }                    catch (System.Exception e1)                    {                        MsgBoxCtrl.MsgBoxException(e1.Message, "CDatabase.ExecuteSql");                    }                }                return false;            }        }

将上面的Execute调用改一下就Ok了

m_cn.Execute(strSql, out objAffected, (int)ADODB.ExecuteOptionEnum.adExecuteNoRecords);

下面是MSDN的说明：

Using the Execute method on a Connection Object (ADO) object executes whatever query you pass to the method in the CommandText argument on the specified connection. If the CommandText argument specifies a row-returning query, any results that the execution generates are stored in a new Recordsetobject. If the command is not intended to return results (for example, an SQL UPDATE query) the provider returns Nothing as long as the option adExecuteNoRecords is specified; otherwise Execute returns a closed Recordset.

MSDN链接地址：https://msdn.microsoft.com/en-us/library/windows/desktop/ms675023(v=vs.85).aspx