Re: trigger --> unix shell script question

Old method:
use a database pipe and have a daemon process (pro*C, perl , etc.) listening on
the other end of the pipe to handle requests.

New method:
Oracle8 lets you register libraries (dll's or so's) that you can execute from within Oracle.

Theres no EASY way. Its a major complaint about Oracle.

-jay

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 Fri Sep 17 1999 - 10:39:15 CDT