Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: can 8racle 8.1.5 send emails?
Almost everything is possible. I bet there's a C interface on your platform
to send mails. By using something like PLEX on Oracle7
(http://osi.oracle.com/~tkyte/plex/index.html) or external procedures on
Oracle8 (http://technet.oracle.com/tech/pl_sql/index2.htm?Code&listing.htm)
you can achieve this. In 8.1.5 theres the COM Automation interface as well
for Windows so you would be able to call eg Outlook.
HTH. Finn
Juhan Kundla <juhan_at_ensib.ee> wrote in message
news:38D12066.29B02B25_at_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 Mon Mar 20 2000 - 13:04:10 CST