Re: A trigger send me a mail

From: Patrick Bourdais <pbourdais_at_free.fr>
Date: Mon, 25 Mar 2002 11:35:20 +0100
Message-ID: <3c9efd68$0$21504$626a54ce@news.free.fr>

Thank you, but it's not really what I want. In fact, I want to launch ANY unix script or command from PL/SQL.

I'm looking for a command like system(char *) in C, but for PL/SQL.

Patrick

"Knut Talman" <knut.talman_at_mytoys.de> a écrit dans le message news: 3C9EDA26.D6699063_at_mytoys.de...
> > How is it possible to call a UNIX command from a plsql block (to send me
a
> > mail, or halt the server ;-) for example)
> > What is the good command please ??
>
> The trigger could have made use of utl_smtp, a package which is used to
send
> mail via smtp (as the name implies).
>
> Regards,
>
> Knut
Received on Mon Mar 25 2002 - 04:35:20 CST