RE: Oracle 8.1.6, Solaris, and e-mail

From: Javier Morales <Javier_at_infojobs.net>
Date: Fri, 17 Nov 2000 18:27:38 +0100
Message-Id: <10683.122389@fatcity.com>

there's a sample... eheheh... a very simple sample!! ;-)

declare

	    salt varchar2(2) :=3Dchr(13)||chr(10);
	    conexio  utl_smtp.connection;
begin
	   conexio:=3Dutl_smtp.open_connection('172.5.5.246',  25);
	   utl_smtp.helo (conexio, '172.5.5.246');
	   utl_smtp.mail (conexio, '<sender_at_infojobs.net>');=20
	   utl_smtp.RCPT (conexio, '<javier_at_infojobs.net>');
	   utl_smtp.data (conexio, 'Subject: FALLO

ALADDINO!!!'||salt||salt||' ofertas i noticias!! FALLO ALADDINO!!!!!'||salt||'Javier');

utl_smtp.quit (conexio);
end;

Regards,
Javier

Javier Morales - javier_at_infojobs.net
Administraci=F3n Bases de Datos Oracle - InfoJobs.net Tel. +34 902 10 60 90 Ext. 2067
Fax. +34 (93) 580 56 60
=20

-----Mensaje original-----
De: Day, Tom [mailto:tday_at_grci.com]
Enviado el: viernes 17 de noviembre de 2000 16:51 Para: Multiple recipients of list ORACLE-L Asunto: RE: Oracle 8.1.6, Solaris, and e-mail

The only documentation that I have handy is for 8.0.5 and doesn't = include
that package. Do you know anywhere where an example of the use of this package is available?

Thanks

-----Original Message-----
Sent: Friday, November 17, 2000 9:51 AM
To: Multiple recipients of list ORACLE-L

Use the Oracle supplied UTL_SMTP package

"Day, Tom" wrote:
>=20
> Does anybody know how to have Oracle automatically fire off an e-mail =
when
a
> particular table is updated?

>=20
> I seem to remember a discussion from some time ago about DBA's who =
had set
> up remote Oracle databases that would fire off an e-mail when certain
> problems arouse, but I didn't save any particulars.

>=20

> Thanks
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Day, Tom
> INET: tday_at_grci.com

>=20


> 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).

--=20

Charlie Mengler               Maintenance Warehouse =20
charliem_at_mwh.com              10641 Scripps Summit Ct  =20
858-831-2229                  San Diego, CA 92131   =20

You don't know what you don't know. Think about it. --=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author: Charlie Mengler
INET: charliem_at_mwh.com

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). --=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author: Day, Tom
INET: tday_at_grci.com

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