Re: Send Email

Roy 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.

Oracle 9i use UTL_SMTP
Oracle 10g use UTL_MAIL.

Both are documented with working demos in Morgan's Library at www.psoug.org.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org