Re: Execute shell script from trigger

From: bigrez <resnimi_at_NOSPAMmail.northgrum.com>
Date: 2000/05/19
Message-ID: <FutxBA.H65%mother@herald.northgrum.com>#1/1

I created the database pipe command processor daemon as defined in the Oracle documentation (PL/SQL Input & output, Database Pipes) and can now execute any system command from within PL/SQL and triggers.

You can tweak their procedure to run the system command as the user running the PL/SQL block (if the daemon is running as root.)

Works rather well for us.

Mike
bigrez_at_mail.hughes.net

m_kelly13_at_my-deja.com wrote in message <8fp6om$epq$1_at_nnrp1.deja.com>...
>How can I execute a UNIX shell script from a trigger? I am running
>Oracle 8i on Solaris.
>
>Thanks
>Matt
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri May 19 2000 - 00:00:00 CDT