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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxx]=20
Sent: Tuesday, March 08, 2005 12:37 PM
To: Nagarajan.Subbiah@xxxxxxxx
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

Other related posts: