Re: Calling shell script from stored procedure
From: Scott Urman <surman_at_wwsun10.us.oracle.com>
Date: 5 Dec 1994 22:26:24 GMT
Message-ID: <3c042g$77_at_dcsun4.us.oracle.com>
Date: 5 Dec 1994 22:26:24 GMT
Message-ID: <3c042g$77_at_dcsun4.us.oracle.com>
In article <3bvqur$gpk_at_apakabar.cc.columbia.edu>, sb63_at_aloha.cc.columbia.edu (Semyon Basin) writes:
|> Hi Netters!
|> Is there any way to call an external program (let's say a shell script) from
|> stored procedure?
|> Thanx in advance to all who reply.
Not directly. The best way is to use the DBMS_PIPE package. It allows you to send messages between two sessions connected to the same database. One is your stored procedure, and the other is usually a C program that would then execute the shell script. Check out Appendix A of the Application Developer's Guide for more info on this package (and the other DBMS_ packages as well). Received on Mon Dec 05 1994 - 23:26:24 CET