Re: LAUNCHING EXTERNAL PROCESS FROM TRIGGER

From: x <x_at_bob.gov>
Date: 1996/12/16
Message-ID: <32B4D003.5856@bob.gov>#1/1

Yes - use the dbms_alert or dbms_pipe stored procedures.

That way your trigger/procedure can send a message to a listening program which can in turn call anything it likes. I have successfully done this a number of times - can send ?some? examples if U like...

TBL. Steve Chell wrote:
>
> Is it possible for a stored procedure or database trigger
> to launch an independant server-side process (such as mailx,
> or any other non-oracle process)? Our database is version 7.1.6
> running under Solaris.
>
> (We don't have OCI or PRO*C, which I suspect we need to do
> this sort of thing.)
>
> Thanks in advance ...
>
> Steve Chell
> slc_at_stevensons.co.nz
Received on Mon Dec 16 1996 - 00:00:00 CST