look into external procedure calls. You will need to configure your listener
to allow this but this should provide what you want.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Patrick Bourdais" <pbourdais_at_free.fr> wrote in message
news:3c9efd68$0$21504$626a54ce_at_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:41:21 CST
