Re: Start shell script from Oracle

From: Neil Hulin <nospam_at_litech.freeserve.co.uk>
Date: 1998/11/12
Message-ID: <72ebnh$ci$1@newsreader2.core.theplanet.net>#1/1

You didn't specify from where you wish to launch the shell script. From a tool such as SQL*Plus or from the RDBMS in response to a trigger?

From a tool, use the appropriate command: sqlplus -> host
c -> system()

From the RDBMS, create a simple Pro*C daemon and use DBMS alert or pipe as appropriate.

...neil {Actually: neil [dot] hulin [at] litech [dot] freeserve [dot] co [dot] uk}
Mike Doland wrote in message <72bjbp$mem_at_drn.newsguy.com>...
>Hi!
>
>Is there a way to start a shell script from withing Oracle 7.3? If there
is, how
>do I do it? If not, how do I go around the problem?
>
>Please, mail me the answer at:
>mdoland_at_hotmail.com
>
>
>Mike
Received on Thu Nov 12 1998 - 00:00:00 CST