Oracle-L: RE: DBMS

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Thu, 18 Apr 2002 09:43:30 -0800
Message-ID: <F001.0044840B.20020418094330@fatcity.com>

Never mind, I found the answer: It's not possible.

Instead, since 8.1.6., it's better to use the utl_smtp package.

e.g. from MetaLInk:
DECLARE conn UTL_SMTP.CONNECTION;
crlf VARCHAR2( 2 ):= CHR( 13 ) || CHR( 10 ); mesg VARCHAR2( 1000 );

BEGIN conn:= utl_smtp.open_connection( 'smtp01.us.oracle.com', 25 );

utl_smtp.helo( conn, 'smtp01.us.oracle.com' ); 
utl_smtp.mail( conn, 'user1_at_us.oracle.com' ); 
utl_smtp.rcpt( conn, 'user2_at_us.oracle.com' ); 
utl_smtp.rcpt( conn, 'cc:user1_at_us.oracle.com' );

mesg:= 'Date: ' || TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' ) || crlf || 'From: User1 <user1_at_us.oracle.com>' || crlf || 'Subject: Just testing' || crlf || 'To: User2 <user2_at_us.oracle.com>' || crlf || 'Cc: User1 <user1_at_us.oracle.com>' || crlf || '' || crlf || ' This is just a test,

please disregard. ' || crlf || '****************************************';

utl_smtp.data( conn, mesg ); utl_smtp.quit( conn );

END;
/

I am getting ready to test that now, to see if it works.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-----Original Message-----

Sent:	Thursday, April 18, 2002 12:38 PM
To:	Multiple recipients of list ORACLE-L
Subject:	DBMS_MAIL

Has anyone used this package to send e-mails to an Exchange server?

Is it possible?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Boivin, Patrice J
INET: BoivinP_at_mar.dfo-mpo.gc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Boivin, Patrice J
INET: BoivinP_at_mar.dfo-mpo.gc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

RE: DBMS_MAIL