Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Send Email
On 01.08.2007, BChase <bsc7080xxmqc_at_myoracleportal.com> wrote:
>>I want to use PL/SQL procedure / triggers to send an email when a new
>>entry is created in a table in Oracle .
>>
>>Kindly suggest the logical way to do so .
>
> If you have Oracle Applications, use Alerts, otherwise use a trigger on the table and call a stored proc that can perform the email
> for you. 9i and above provides utl_smtp to build your own mail routine. 10g has a utl_mail where Oracle has made it a bit easier to
> write procs to send emails... I have a mail routine that I helped put together that uses utl_tcp (9i+) that has been working very
> well for us at my job. Feel free to grab it from my website => http://www.myoracleportal.com . Its opensource with no restrictions.
I think it would be better for a trigger to submit a job that sends an email. That way no email will be sent for transaction rolled back, the mail will be sent on commit only.
-- Wiktor MoskwaReceived on Wed Aug 01 2007 - 10:40:38 CDT