Re: trigger --> unix shell script question

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Thu, 12 Aug 1999 07:47:45 -0400
Message-ID: <37B2B461.9996509F@Unforgettable.com>

dbms_pipe will allow you to send a string (like the name of a shell script for example) to a listener which can then execute the shell script.

Ken

Jason Singleton wrote:

> Hi,
>
> Can anyone out there tell me how to have a trigger execute a unix shell
> script. For instance, is there a way in a PL/SQL block to break out
> into the operating system to execute a file/script? I've reviewed the
> DBMS utilities and did not find anything that looked like it would work.
>
> Thanks in advance!
>
> PS - in case my specific operating system matters, I am running Oracle
> 7.3.4 on a Sun Solaris 2.6 system.
>
> Jason
Received on Thu Aug 12 1999 - 06:47:45 CDT