Re: executing shell scripts from PL/SQL
Date: 1996/02/09
Message-ID: <4fg7nq$f1t_at_lois.Read.TASC.COM>#1/1
kjartang_at_ejs.is (Kjartan R Gudmundsson) wrote:
>bmanry_at_ibmgate-aix.us.oracle.com (Bill Manry - Oracle Corp.) wrote:
>Few weeks ago in comp.databases.oracle, HOBSONA_at_prc4wc.igw.bt.co.uk
>(Andy Hobson) wrote:
>This code implements a DMBS_PIPE between a oracle session and a C
>program running as a server. The C prorgram executes thethe command
>using a call to system. It returns information about success or
>failure of the command. No output from the command.
Not sure if this is the same paper, but Oracle sent me a paper and source code for an Oracle written, but not supported package called PLEX. It contains examples of how to setup procedures to execute operating system commands from a call to a stored procedure. I was able to install the PLEX package and did have it working, but I had not incorporated into an application. The way that PLEX works is to startup a server (PRO*C program on server machine) and send DBMS_PIPE messages to the server which the PRO*C program executes. The results of the command are written into a table which can be later retrieved.
I found the product to be very stable and it comes with commands to stop and start the PLEX server.
Tom
tlhillson_at_tasc.com
Thomas Hillson
TASC
55 Walkers Brook Dr
Reading, MA 01867
>regards
>krg.
>kjartang_at_ejs.is
Received on Fri Feb 09 1996 - 00:00:00 CET