Re: Execute Unix Command from Stored Proc
From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/11/05
Message-ID: <55neok$4q4_at_newton.pacific.net.sg>#1/1
Date: 1996/11/05
Message-ID: <55neok$4q4_at_newton.pacific.net.sg>#1/1
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.
Hope this helps.
Regards
N.Prabhakar
Socgen Crosby Securities
Singapore
Received on Tue Nov 05 1996 - 00:00:00 CET