Re: Execute Unix Command from Stored Proc

Ed Jennings wrote:
>
> Is there a way to execute a standard unix command from a stored
> procedure? I want a stored proc to be able to touch a unix
> file at run time. Can this be done?
>
> Ed

Follow this link for discussions on doing this:

http://www.altavista.digital.com/cgi-bin/query?pg=q&what=news&fmt=.&q=dbms+pipe

Her is one of the posts:
-----START POST
You can achieve this by using dbms_pipes. You can pass an instruction to pipe. An unix process (pro*c program) will continuously run on the background and check for any information on the pipe. Once it receives an information, the program can fork an child process through a system command which can perform any OS operation like invoking other programs, executing shell scripts and so on.

N.Prabhakar
Socgen Crosby Securities
Singapore
-----END POST Oracle Goverment has a unsupported downloadable utility for doing this at:

http://govt.us.oracle.com/govt/owa/style.page?p_id=62&p_sub=3

-- 
                       \\|//
                       (0-0)
           +-----oOO----(_)-----------+
           | Brian P. Mac Lean        |
           | Database Analyst         |
           | brian.maclean_at_teldta.com |
           | http://www.teldta.com    |
           +-------------------oOO----+
                      |__|__|
                       || ||
                      ooO Ooo