Re: [Potential Spam] How to send e-mail from Oracle

Try UTL_SMTP. There are a lot of links from Google.

"Subbiah, Nagarajan" <Nagarajan.Subbiah_at_aetn.com> Sent by: oracle-l-bounce_at_freelists.org
03/08/2005 12:27 PM
Please respond to
Nagarajan.Subbiah_at_aetn.com

To
'List' <Oracle-L_at_freelists.org>
cc

Subject
[Potential Spam] How to send e-mail from Oracle

Hi,

We are sending the e-mails using the mailx client from the unix cron jobs. The new requirement is, after the stored procedure is executed using the job
scheduler (dbms_job), we would like to send the e-mail from Oracle. Is there
a way to send the e-mail from oracle? Can anyone point to any link which has
the procedure how to implement this?

Thanks in Advance.

Raja

--
http://www.freelists.org/webpage/oracle-l




*************************************************************************************************

The following message has been automatically added by the Internet mail 
gateway 
to comply with Royal & SunAlliance IT Security Policy.

"This e-Mail has arrived via the Internet and, therefore, you should be 
cautious 
about its origin and content.  Replies which contain sensitive information 
or 
legal/contractual obligations are particularly vulnerable.  In these cases 
you should
not reply unless you are authorized to do so."


If you have any questions, please speak to your local desktop support team 
or IT 
security contact.



*************************************************************************************************







***********************************************************************************

Notice of Confidentiality 

This transmission (including attachments) contains information that 
may be privileged, confidential and protected from disclosure. Unless 
you are the intended recipient of the message (or authorized to receive 
it for the intended recipient) you may not copy, forward, or otherwise 
use it, or disclose it or its contents to anyone. If you received this 
transmission in error please notify us immediately, permanently delete 
the transmission(including attachments) from your system, and destroy 
all hard copies.  Thank you.


Email: security_usa_at_rsausa.com


***********************************************************************************




--
http://www.freelists.org/webpage/oracle-l