Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Send mail from pl/sql
Roland,
Check out the Oracle supplied PL/SQL package UTL_SMTP:
http://download-uk.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/utl_ smtp.htm
HTH Mark
-----Original Message-----
Roland.Skoldblom_at_ica.se
Sent: 05 April 2002 08:33
To: Multiple recipients of list ORACLE-L
Hallo,
Does anyone have a good example on a procedure how to send email from Pl/SQL. What I want to happen is to do a select statement and then send a mail with the result to the address roland_at_test.se. Please help me with this. I would appreciate it very miuch.
Thanks in advance
Roland
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Roland.Skoldblom_at_ica.se 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-LReceived on Fri Apr 05 2002 - 03:43:20 CST
(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: Mark Leith INET: mark_at_cool-tools.co.uk 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).
![]() |
![]() |