| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Off-Topic: How to send email from PL/SQL
Hi Saj,
Thanks. It works. Now I can cc to other people. :-)
Regds,
ChorLing
-----Original Message----- From: saj.raza_at_qxl.com [mailto:saj.raza_at_qxl.com] Sent: Thursday, December 14, 2000 7:36 PM To: Multiple recipients of list ORACLE-L Subject: RE: Off-Topic: How to send email from PL/SQL If I remember correctly, just do a second call to utl_smtp.rcpt with a different recipient address eg utl_smtp.rcpt(mail_conn, recipient1); utl_smtp.rcpt(mail_conn, recipient2); Saj -----Original Message----- From: CHAN Chor Ling Catherine (CSC) [SMTP:clchan_at_nie.edu.sg] Sent: Thursday, December 14, 2000 10:36 AM To: Multiple recipients of list ORACLE-L Subject: RE: Off-Topic: How to send emailfrom PL/SQL
Hi Arun,
The PL/SQL code is below. It does not seem to be able to cc email.
Qn : Has anyone successfully sent and cc emails in PL/SQL ? Please
help.
Thanks.
Regds,
Chorling
DECLARE
c utl_smtp.connection;
PROCEDURE send_header(name IN VARCHAR2,
header IN VARCHAR2)
AS
BEGIN
utl_smtp.write_data(c, name || ': ' ||
header ||
utl_tcp.CRLF);
END;
BEGIN
c :=
utl_smtp.open_connection('smtp-server.acme.com');
-- your
smtp server
utl_smtp.helo(c, 'foo.com'); -- your
domain
utl_smtp.mail(c, 'sender_at_foo.com');
utl_smtp.rcpt(c, 'recipient_at_foo.com');
utl_smtp.open_data(c);
send_header('From', '"Sender" <sender_at_foo.com>');
send_header('To', '"Recipient" <recipient_at_foo.com>');
send_header('Subject', 'Hello');
utl_smtp.write_data(c, utl_tcp.CRLF || 'Hello, world!');
utl_smtp.close_data(c);
utl_smtp.quit(c);
EXCEPTION WHEN utl_smtp.transient_error OR utl_smtp.permanent_error
THEN utl_smtp.quit(c);
raise_application_error(-20000,
'Failed to send mail due to the following error: ' ||
sqlerrm);
END;
-----Original Message----- From: arun_at_ssind.stpn.soft.net [mailto:arun_at_ssind.stpn.soft.net] Sent: Thursday, December 14, 2000
Hi,
Can you send the details how you
implemented this.
Thanks and Regards Arun ----- Original Message ----- From: "CHAN Chor Ling Catherine (CSC)" < > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, 14 December, 2000 01:31 PM Subject: Re: Off-Topic: How to send email from PL/SQL > Hi > > I've tried using the package utl_smtp. It works. > > Regds, > ChorLing > -----Original Message----- > From: CHAN Chor Ling Catherine (CSC) > Sent: Thursday, December 14, 2000 3:26 PM > To: 'ORACLE-L_at_fatcity.com' > Subject: Off-Topic: How to send email from PL/SQL > > Hi, > > Is it possible to send email in PL/SQL ? Is there any Oracle function that > send email in PL/SQL ? If not, I guess I've to write the email information > into a table, use a C-program to extract the information in the table and > email it to the sender. Any advice ? Thanks in advance. > > Regds, > Chorling > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: CHAN Chor Ling Catherine (CSC) > INET: clchan_at_nie.edu.sg > > 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: CHAN Chor Ling Catherine (CSC) INET: clchan_at_nie.edu.sg 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).
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.comMailing Lists
--
Author: INET: saj.raza_at_qxl.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access /
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') Received on Thu Dec 14 2000 - 22:07:58 CST
 |
 |