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;
}
}