Executing Oracle 9i Stored Procedures with Oracle Managed Data Provider

CREATE OR REPLACE PROCEDURE sp_updateBalance(accNo number, amount number, status OUT varchar2) IS BEGIN              UPDATE customer_account              SET balance = balance + amount              WHERE  accountNo = accNo ;             if SQL%ROWCOUNT = 1 then                   status := 'TRUE' ;                   commit ;             else                   status := 'FALSE' ;             end if ;END ;

// import the required assembliesusing System; using System.Data; using System.Data.OracleClient;

class StoredProc      {             public static void Main()                 {                 // your Database connection string                  string sDBstr = "" ;                   // create an instance of the connection object                 OracleConnection oCn = new OracleConnection(sDBstr) ;

               //create an instance of the command object giving the procedure name                         OracleCommand oCm = new OracleCommand("sp_updateBalance",oCn) ;

               // Define the command type u r executing as a Stored Procedure.                                               oCm.CommandType = CommandType.StoredProcedure ;

               //Add the parameter "accNo" giving it's value and defining it as a Input parameter                        oCm.Parameters.Add("accNo",OracleType.Number,16);                          oCm.Parameters["accNo"].Value = 1 ;                                              oCm.Parameters["accNo"].Direction = ParameterDirection.Input ;

               //Add the parameter "amount" giving it's value and defining it as a Input parameter                         oCm.Parameters.Add("amount",OracleType.Number,16);                        oCm.Parameters["amount"].Value = 200 ;                         oCm.Parameters["amount"].Direction = ParameterDirection.Input ;

               //Add the parameter "status" giving it's value and defining it as a Output parameter                          oCm.Parameters.Add("status",OracleType.VarChar,5);                         oCm.Parameters["status"].Direction = ParameterDirection.Output ;

                        // using the Try Catch Finally Block.                        try                           {                                 // Open the connection                                oCn.Open(); 

                                // giving screen output                                Console.WriteLine("created connection") ;

                                // execute the stored procedure                                oCm.ExecuteNonQuery() ; 

                                // get the confirmation on the screen                                Console.WriteLine(oCm.Parameters["status"].Value) ; ;

                          }                       catch(Exception ex)                           {

                               // catch the error message and put it in the string "msg"                               string msg = ex.Message ;

                               //show the error message on the screen                               Console.WriteLine(msg) ;

                          }                        finally                           {                                  //Close the connection                                 oCn.Close();                                 oCn = null ;                               oCm = null ;

                         }        }

}