If database is 8.1.6 you can use UTL_SMTP to send DBA mail from exception handler.