RE: How to send e-mail from Oracle

On the platforms that you mention, you will be using UTL_SMTP. You're database may not come installed with all the necessary components; IIRC, = you
will need JAVA_XA, DBMS_JAVA, and TCPConnection installed (from
$ORACLE\javavm\install\initjvm.sql (for the first two packages) and
$ORACLE\rdbms\admin\initplsj.sql (for TCPConnection))

You should also be conversant with RFC821, because with UTL_SMTP, you = will
basically be acting as the Mail Transfer Agent (MTA) talking to a = destination
SMTP server and forming your own RFC821 compliant messages.

Good luck. YMMV (especially installing the Java stuff.)

...Rudy

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Subbiah, Nagarajan
Sent: Tuesday, March 08, 2005 12:43 PM
To: 'Niall Litchfield'; Subbiah, Nagarajan Cc: 'List'
Subject: RE: How to send e-mail from Oracle

We are using both Oracle 9.2.0.5 and Oracle 8.1.7.4 on HP-UX 11.11. We = have
the sendmail running on the server which I believe communicate to our Exchange mail server and I am using the 'mailx' command on the unix = machine
to send the e-mail.

Raja.

-----Original Message-----
From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com]=20 Sent: Tuesday, March 08, 2005 12:37 PM
To: Nagarajan.Subbiah_at_aetn.com
Cc: List
Subject: Re: How to send e-mail from Oracle

Version of the database and email requirements would be nice. It sounds = like
9i or lower, in which case you will probably be looking at UTL_SMTP = unless
you require attachments, but version does make a difference.

In the mean time I'm pretty sure that there is a good discussion of the issues on asktom.

--=20
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

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