Re: Help: I need to trigger a Unix program from Oracle Net on a PC

From: Sandor Nieuwenhuis NL <snieuwen_at_nl.oracle.com>
Date: Thu, 26 Aug 1993 11:49:59 GMT
Message-ID: <CCD7JC.CGr_at_nl.oracle.com>


Joe Tang (jtang_at_ctp.com) wrote:

: >From a PC with Oracle Net, connected to an Oracle Server on an RS6000
: (Oracle Version 7), I need to initiate/trigger a Unix program (acutally
: a COBOL program that is compiled to an executable) on the IBM.

You can do this using the DBMS_PIPES package. An example of how to do this is in the Oracle7 Application developers guide and also some guidelines are in

$ORACLE_HOME/rdbms/admin/dbmspipe.sql source file.

I have personally setup a demo for reading information from an Unix file by a Stored Procedure (callable from SQL*Forms), in my case the /etc/passwd file. If you would like to send you this, just send me an e-mail message.

Sandor Nieuwenhuijs
(snieuwen_at_nl.oracle.com)
Oracle Netherlands

  • These opinions (if any) are just mine. I do not represent Oracle ---
  • Corporation in this Posting ---
Received on Thu Aug 26 1993 - 13:49:59 CEST

Original text of this message