Two ways of implementing Oracle stored procedure calls in ADO

1 , regular stored procedure calls

String or=configurationmanager.connectionstrings["Conn"]. ToString (); OracleConnection OC=NewOracleConnection (or); Oc.open (); OracleCommand om=OC. CreateCommand (); Om.commandtype=Commandtype.storedprocedure;om.commandtext="proc2"; OM.PARAMETERS.ADD ("v_id", Oracletype.number). Direction =parameterdirection.input;om.parameters["v_id"]. Value = This. TextBox2.Text.Trim (); OM.PARAMETERS.ADD ("V_name", Oracletype.nvarchar). Direction =parameterdirection.input;om.parameters["V_name"]. Value = This. TextBox3.Text.Trim (); Om. ExecuteNonQuery (); Oc.close ();

2 , call no return value stored procedure

String or=configurationmanager.connectionstrings["conn"new  =="callPro_user_boss (a,b,c)";//A, B, c is the stored procedure parameter and value passed in

Om. ExecuteNonQuery (); Oc. Close ();

Two ways of implementing Oracle stored procedure calls in ADO