Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle 8.1.6, Solaris, and e-mail
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: FALLOALADDINO!!!'||salt||salt||' ofertas i noticias!! FALLO ALADDINO!!!!!'||salt||'Javier');
utl_smtp.quit (conexio);
end;
Regards,
Javier
-----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
>=20> To REMOVE yourself from this mailing list, send an E-Mail message
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
--=20
Charlie Mengler Maintenance Warehouse =20 charliem_at_mwh.com 10641 Scripps Summit Ct =20 858-831-2229 San Diego, CA 92131 =20You don't know what you don't know. Think about it. --=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
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 Received on Fri Nov 17 2000 - 11:27:38 CST