Home » RDBMS Server » Server Administration » Re: Sending E-Mail from Oracle
Re: Sending E-Mail from Oracle [message #369709] Mon, 21 August 2000 09:39 Go to next message
Messages: 56
Registered: May 1999
In Oracle 8.1.6 there ia a package UTL_SMTP that can send email, I'm not sure if you have it in Oracle 8.0.5.
Re: Sending E-Mail from Oracle [message #369711 is a reply to message #369709] Wed, 23 August 2000 20:27 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
You could write an alert (or "flag") to a new table of your own (using a trigger or your stored proc). After this, simply schedule a job to look for that "flag" in your table, if found send email, then reset your "flag". This is not too elegent though.
Previous Topic: Date Problem???
Next Topic: numeric varchar2
Goto Forum:

Current Time: Wed Oct 21 11:18:19 CDT 2020