以下是一段C#中连接Oracle存储过程的代码:
//
调用存储过程
private string CallProcdure( string data,DateTime time, string type)
... {
OracleConnection myconn;
OracleCommand cmd;
//string strcon = "user id=cmes;data source=SHACIICQ;password=cmes";
string strcon = ConfigurationSettings.AppSettings["DatabaseConnection"];
myconn = new OracleConnection(strcon);
cmd = new OracleCommand();
try
...{
myconn.Open();
cmd = new OracleCommand();
cmd.Connection = myconn;
}
catch(Exception e)
...{
throw e;
}
OracleParameter[] parameters=...{
new OracleParameter("DATA",OracleType.VarChar),
new OracleParameter("DATETIME",OracleType.DateTime),
new OracleParameter("I_TYPE",OracleType.VarChar),
new OracleParameter("RES",OracleType.VarChar,20)
};
parameters[0].Value = data;
parameters[1].Value = time;
parameters[2].Value = type;
parameters[3].Direction = ParameterDirection.Output;
try
...{
cmd.CommandText="C_SAVE_INTER_DATA";//存储过程名称
cmd.CommandType=CommandType.StoredProcedure;
foreach(OracleParameter parameter in parameters)
...{
cmd.Parameters.Add(parameter);
}
cmd.ExecuteNonQuery();
myconn.Close();
return parameters[3].Value.ToString();
}
catch(Exception e)
private string CallProcdure( string data,DateTime time, string type)
... {
OracleConnection myconn;
OracleCommand cmd;
//string strcon = "user id=cmes;data source=SHACIICQ;password=cmes";
string strcon = ConfigurationSettings.AppSettings["DatabaseConnection"];
myconn = new OracleConnection(strcon);
cmd = new OracleCommand();
try
...{
myconn.Open();
cmd = new OracleCommand();
cmd.Connection = myconn;
}
catch(Exception e)
...{
throw e;
}
OracleParameter[] parameters=...{
new OracleParameter("DATA",OracleType.VarChar),
new OracleParameter("DATETIME",OracleType.DateTime),
new OracleParameter("I_TYPE",OracleType.VarChar),
new OracleParameter("RES",OracleType.VarChar,20)
};
parameters[0].Value = data;
parameters[1].Value = time;
parameters[2].Value = type;
parameters[3].Direction = ParameterDirection.Output;
try
...{
cmd.CommandText="C_SAVE_INTER_DATA";//存储过程名称
cmd.CommandType=CommandType.StoredProcedure;
foreach(OracleParameter parameter in parameters)
...{
cmd.Parameters.Add(parameter);
}
cmd.ExecuteNonQuery();
myconn.Close();
return parameters[3].Value.ToString();
}
catch(Exception e)