C calls the method of the Oracle stored procedure

This article is an example of how C# calls Oracle stored procedures. Share to everybody for everybody reference. Specific implementation methods are as follows:

The Oracle database code is as follows:

create or replace procedure proce_test(paramin in varchar2,paramout out varchar2,paraminout in out varchar2)

as

  varparam varchar2(28);

begin

  varparam:=paramin;

  paramout:=varparam|| paraminout;  

end;

The c# invocation code is as follows:

OracleConnection conn = null;

OracleCommand cmd = null;
string strConn = "data source=clientag;user id=ay_plan;password=ayplan";  // Connect to database 

conn = new OracleConnection(strConn);

try

{

 conn.Open();

 cmd = new OracleCommand();

 cmd.Connection = conn;

}

catch (Exception e)

{

 throw e;

}
OracleParameter[] parameters ={

 new OracleParameter("paramin",OracleType.VarChar,20),

 new OracleParameter("paramout",OracleType.VarChar,20),

 new OracleParameter("paraminout",OracleType.VarChar,20)

};

parameters[0].Value = "bjd";

parameters[2].Value = "cs";

parameters[0].Direction = ParameterDirection.Input;

parameters[1].Direction = ParameterDirection.Output;

parameters[2].Direction = ParameterDirection.InputOutput;

try

{

 cmd.CommandText = "proce_test";// Declare the stored procedure name 

 cmd.CommandType = CommandType.StoredProcedure;

 foreach (OracleParameter parameter in parameters)

 {

     cmd.Parameters.Add(parameter);

 }

 cmd.ExecuteNonQuery();// Execute stored procedure 
 Console.WriteLine(parameters[1].Value.ToString());

 Console.Read();

}

catch (Exception e)

{

 throw e;

}

Hopefully this article has helped you with your C# programming.