Re: executing shell scripts from PL/SQL
Date: 1996/02/09
Message-ID: <4ff7nk$lfn_at_njala.saga.is>#1/1
bmanry_at_ibmgate-aix.us.oracle.com (Bill Manry - Oracle Corp.) wrote:
>Gee Wong (gwong_at_microfone.net) wrote:
>>I can not find any documentation on the host command. Which package
>>is this procedure in?
>Mr. Alari probably was referring to the 'host' function in
>SQL*Forms et al. Currently there is no direct means of
>invoking a user program or script from within the RDBMS.
>An indirect method using dbms_pipes exists...but it requires
>writing code to run at the other end of the pipe.
Few weeks ago in comp.databases.oracle, HOBSONA_at_prc4wc.igw.bt.co.uk
(Andy Hobson) wrote:
..., several people
mentioned DBMS_PIPE and others asked me to pass on a solution if I
came across it. This is a technical paper from Oracle Worldwide
support which describes the process & includes source code for client
and server side. I have not had time to test it yet so don't blame me
if there are any bugs ! I have been assured by Oracle that this
paper is freely distributable.
Article-ID: <Note:14082.1> Revision: 0 PUBLIC
Circulation: ** Available to Customers on OCIS ** Creator: OLSBB Folder: product.cde.plsql Topic: ** Using RDBMS distributed packages ** Subject: DYNAMIC SQL AND SYSTEM COMMANDS USING DBMS_PIPE Modified: 03 Oct 95 11:50:19 Attachments: NONE
You can also get this from the Oracle Support Notes CD.
regards
krg.
kjartang_at_ejs.is
Received on Fri Feb 09 1996 - 00:00:00 CET