Re: off topic - E-mail from DB

Hi.

You can use UTL_SMTP stored package, but only on Oracle8i v8.1.6 and over (*sorry*). See Note 106513.1 at Oracle Metalink for "Basics on How to use UTL_SMTP". Another option in Unix is calling sendmail command from PL/SQL. See Note 66347.1 at Oracle Metalink for "How to Generate E-mail within PL/SQL Routines".

You better use UTL_SMTP, fully supported by Oracle Corporation, if you can upgrade the RDBMS version.

Hope it helps,
Juan Guillermo.

prem_at_ibsplc.com wrote:

> Does anyone tell me is it possible to send e-mails from the Oracle
> database, If so how?
> we are using Oracle8.0 for the development.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: prem_at_ibsplc.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).

--
----------------------------------------
Juan Guillermo Rodríguez
Consultor Principal

Oracle Consulting Services
Oracle Ibérica, S.R.L.
Navaluenga, 1 y 3
28230 Las Rozas
Madrid
España

Oracle:
+ Centralita: 916312000
+ Directo:    916312069
+ Fax:        916312189
+ e-mail: JuanGuillermo.Rodriguez_at_oracle.com
+ http://www.oracle.com/

In situ (Telefónica I+D):
+ Directo:    913374936
+ e-mail: jgrb16_at_tid.es

Personal:
+ Móvil:      609588941
----------------------------------------
DISCLAIMER: The statements and opinions expressed here are my own and do not
necessarily represent those of Oracle Corporation.

RENUNCIA: Las opiniones e ideas expresadas son propias y no necesariamente
representan las de Oracle Corporation.