Re: Execute Unix script from trigger or SP ?

From: <saropani_at_my-dejanews.com>
Date: Wed, 03 Jun 1998 08:03:48 GMT
Message-ID: <6l3013$efu$1@nnrp1.dejanews.com>

In article <3572e526.0_at_feed1.realtime.net>, sadair_at_bga.com (Steven W. Adair) wrote:
>
> I need to do a couple of things when a row is inserted.
> 1) Collect the data from the insert and
> 2) E-mail that data to a troubleshooter.
>
> We are using Oracle 7.3 on a Digital Unx box.
>
> Suggestions ?
> Steve
>
> --

Hi Steve,

I think you can use DBMS_PIPE procedure to send messages to a pipe which is read by a daemon (by which you can mail). However this is only a rough idea.

Hope you can develope it furthur.

Regards,
Saravanan

>
> ***********************************************************************
> * It is unfortunate that we do * Steve Adair - Austin, Texas *
> * not feel pangs of ignorance * sadair_at_bga.com *
> * as we feel pangs of hunger. *
*
> * M.J. Adler * *
> * * Team OS/2 !!! *
> ***********************************************************************
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 03 1998 - 03:03:48 CDT