| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: can 8racle 8.1.5 send emails?
Finn Ellebaek Nielsen wrote:
>
> 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
And 8.1.6 has a DBMS_SMTP package.
HTH
--
We are born naked, wet and hungry...then things get worse Received on Mon Mar 20 2000 - 08:16:08 CST
 |
 |