Ado.net executes the Oracle Stored Procedure

Oracleconnection con = new oracleconnection (strcon );
Oraclecommand cmd = new oraclecommand ();
Oracletransaction mytrans;
Try
{
Con. open ();
Mytrans = con. begintransaction ();
Cmd. Connection = con;
Cmd. commandtext = "rfgetid ";
Cmd. commandtype = commandtype. storedprocedure;
Cmd. Transaction = mytrans;

Oracleparameter parameter_in = new oracleparameter ("as_bm", oracletype. Char );
Oracleparameter parameter_out = new oracleparameter ("as_sxh", oracletype. number );

Parameter_in.direction = parameterdirection. input;
Parameter_out.direction = parameterdirection. output;

Parameter_in. value = tblname. toupper ();

Cmd. Parameters. Add (parameter_in );
Cmd. Parameters. Add (parameter_out );

Cmd. executenonquery ();
Mytrans. Commit ();
Return Int. parse (parameter_out. value. tostring ());

}
Catch (exception ER)
{
Throw new exception (ER. Message );
Mytrans. rollback ();

}
Finally
{
Cmd. Dispose ();
Con. Close ();

}