Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Send Email

Re: Send Email

From: Wiktor Moskwa <wiktorDOTmoskwa_at_gmail.com>
Date: Wed, 1 Aug 2007 15:40:38 +0000 (UTC)
Message-ID: <f8q9hl$5u6$1@atlantis.news.tpi.pl>


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 Moskwa
Received on Wed Aug 01 2007 - 10:40:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US