Re: UNIX shell command from ORACLE

From: Richard Gowan <roxl_at_techno.net.au>
Date: 1997/09/21
Message-ID: <01bcc671$43a4a900$adcf1ccb@ca127197>#1/1

> I want to create a trigger on the table that fires each time the UPDATE
> or the SELECT statement is executed on this table. The trigger would run
> a stored procedure, which, in turn, would launch the program on UNIX. How
> do I execute a UNIX command from a stored procedure?
>

> Is there a similar way to execute system commands from ORACLE stored
> procedures?
>

I have a hardcopy document on how to call UNIX from stored Oracle PL/SQL. Unfortunately I don't have the electronic copy, however the article was from
the www.oreview.com site. I believe that the correct URL is http://www.oreview.com/9704flet.htm

/Richard/ Received on Sun Sep 21 1997 - 00:00:00 CDT