net core连接oracle,.net core oracle

我用了 Oracle.ManagedDataAccess.Client

string connectionString = "。。。";

using (OracleConnection conn = new OracleConnection(connectionString))

{

if (conn.State == ConnectionState.Closed)

{

conn.Open();

}

//OracleTransaction transaction = conn.BeginTransaction();

try

{

using (OracleCommand com = new OracleCommand())

{

foreach (HosDept dept in listDepts)

{

string sql = "。。。";

OracleParameter[] par = new OracleParameter[13];

。。。

par[12] = new OracleParameter("DESCRIPTION", dept.Desc);

com.Parameters.AddRange(par);

//com.Transaction = transaction;

com.CommandType = CommandType.Text;

com.CommandText = sql;

com.ExecuteNonQuery();

}

}

}

catch (Exception e)

{

//transaction.Rollback();

throw e;

}

这样执行报错，报错内容如下：

{System.InvalidOperationException: Operation is not valid due to the current state of the object.

at Oracle.ManagedDataAccess.Client.OracleCommand.ValidateStatePriorToExecution()

at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteScalar()

at PlatformAdmin.DBUtils.DeptsDAL.CreateHosDepts(List`1 listDepts) in C:\Users\HY\Desktop\projects\SRC\CapInfo.BJHL\RealtimeBiz\CenterSide\WeChat\HisAdapterApi\PlatformAdmin\DBUtils\DeptsDAL.cs:line 51}