| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Send Email
On Wed, 01 Aug 2007 03:29:27 -0700, Roy <royashish_at_gmail.com> wrote:
>Hi ,
>
>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 .
>
>Thanks and regards,
>
>Roy.
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.
BChase
bsc7080mqcXX_at_myoracleportal.com
(remove XX to contact)
 |
 |