Re: can 8racle 8.1.5 send emails?

From: Juhan Kundla <juhan_at_ensib.ee>
Date: Thu, 16 Mar 2000 19:56:54 +0200
Message-ID: <38D12066.29B02B25@ensib.ee>

AFAIK you can't send e-mails directly from PL/SQL.

Use PL/SQL to write your e-mails to OS file and create a OS job, which periodically checks for new e-mails and if any found then sends them. Alternativelly, create a mailer OS process and use PL/SQL to write emails directly to that process using a pipe.

Juhan

bombart_at_my-deja.com wrote:
>
> Hello,
> are there mailing functions within the oracle 8.1.5?
> I think about pl/sql procedures. They should send emails on special
> events. If Oracle doesn't support email, do I need an external mailer?
> We have Oracle 8.1.5.1 on Nt4.
> Thanks in advance
>
> Thomas
Received on Thu Mar 16 2000 - 11:56:54 CST