Chapter 27
Paging People with Oracle8i Out of the Box
Hervé Deschamps
This chapter provides a step-by-step method to use Oracle8i Release 2’s UTL_SMTP package, DBMS_JOB package, and a simple subscription model to send e-mails to those people subscribed to specific events that may occur in the database.
Remember how complicated it used to be to send e-mails to people from an Oracle database? It used to require programming in C (or other third-party language), knowing about daemons, using dbms_pipe, etc. These overly complicated techniques disheartened many developers from adding to their application this fairly trivial and essential functionality. And when they did build it, maintenance was an issue because most code developed in our industry ...
Get Oracle Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
