Re: Can I Send mail from Oracle Server

From: <juturi_at_workmail.com>
Date: Wed, 08 Sep 1999 20:46:57 GMT
Message-ID: <7r6hvs$2cp$1@nnrp1.deja.com>

Use the UTL_FILE package to open send mail and close it. you open /usr/bin/sendmail just like a normal file and then write to it as you would write to sendmail( look for help using sendmail in perl forums) and then close it.
This should work, post reply if you need additional help. -Juturi

In article <01bef9fd$b5a45340$1b3214ac_at_wstk326>, "Radiomobil a.s." <hruzat_at_radiomobil.cz> wrote:
> Hi all,
> I need send mail from Oracle (PL/SQL procedure), but I do not
know how it
> send. version of my Oracle Server is 8.0.5 on Digital UNIX. Is another
way
> for sending mail than external procedure (that send mail or another
mail
> systems via UNIX) ? When I am using external procedure, sender of mail
is
> oracle user, because owner of external procedure is the same user as
owner
> Oracle sw. Can I change it ?
>
> Thank you for some answer,
>
> Tom
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 08 1999 - 15:46:57 CDT