C#调用Oracle存储过程或者函数

string connStr = ConfigurationUtility.ConnectionString;
conn = new OracleConnection(connStr);
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = adapter1.Connection;
cmd.CommandText = "FUNC_APPROVE_HISTORY";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("KBN", OracleType.Char, 1).Value = "1";
cmd.Parameters.Add("USER", OracleType.Char, 5).Value = UPD_USER;
cmd.Parameters.Add("returnValue", OracleType.Number, 10).Direction = ParameterDirection.ReturnValue;
flag = (int)cmd.Parameters["returnValue"].Value;
cmd.ExecuteNonQuery();