Re: trigger --> unix shell script question

There is an example in Oracle7 Server Application Developer's Guide, chapter 8
PL/SQL Input/Output, section Database Pipes, Example 2: Execute System Commands.

The example shows PL/SQL and Pro*C code that allows to send operating system

commands over a pipe to a Pro*C program that is listening for them.

I hope this will help.

Oleg.

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 - 12:52:53 CDT