贴一下C#调用的代码: private string Cons()
{
_connectionString = "Data Source=" + _serverVo.Ip + ":1521/orcl;user=" + _serverVo.UserName + ";password=" + _serverVo.Password + ";";
return _connectionString;
} public int ExcuteProcedure(string procedureName)
{
Cons(); OracleConnection conn = new OracleConnection(_connectionString);
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;//指明是执行存储过程
cmd.CommandText = procedureName;
int count = cmd.ExecuteNonQuery();
conn.Close();
return count; }
count的返回值总为1C#Oracle存储过程
{
_connectionString = "Data Source=" + _serverVo.Ip + ":1521/orcl;user=" + _serverVo.UserName + ";password=" + _serverVo.Password + ";";
return _connectionString;
} public int ExcuteProcedure(string procedureName)
{
Cons(); OracleConnection conn = new OracleConnection(_connectionString);
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;//指明是执行存储过程
cmd.CommandText = procedureName;
int count = cmd.ExecuteNonQuery();
conn.Close();
return count; }
count的返回值总为1C#Oracle存储过程
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货