public void DeleteAppUser(string username, string auditUser) { OracleConnection con = new OracleConnection(_connectionString); OracleCommand com = con.CreateCommand(SchemaOwner + PackageName + "delete_user"); com.Parameters.Add("i_app_name", OracleDbType.Varchar2, ApplicationName, ParameterDirection.Input); com.Parameters.Add("i_employee_number", OracleDbType.Varchar2, username, ParameterDirection.Input); com.Parameters.Add("i_audit_user", OracleDbType.Varchar2, auditUser, ParameterDirection.Input); try { con.Open(); com.ExecuteNonQueryEx(); con.Close(); } catch (OracleException oex) { // check if its a custom oracle exception if (oex.Number >= 20000 && oex.Number <= 20999) { // throw a custom exception throw new DalException(Dal.ExtractOracleMessage(oex.Message), oex); } else { throw; } } finally { Dal.Cleanup(con, com); con = null; com = null; } }