Re: Calling external shell scripts from sql code

From: <xsun1913_at_my-dejanews.com>
Date: Wed, 28 Oct 1998 14:19:49 GMT
Message-ID: <717966$6ek$1@nnrp1.dejanews.com>

In article <3636CCBB.685A1534_at_hand-el.no>, Espen Ekeroth <espene_at_hand-el.no> wrote:
>
> Help, I'm in need of calling an external shell script or .c program from
> sql (sql*plus) or plsql.
>
> How do I do it ?
>
> We are running v. 8 og ORACLE on a UNIX plattform (Digital Alfa).
>
> Thanx for any answer.
>
> Espen
>
> --

Hi,

You could add a line like "HOST(proper_path/my_shell_script);" in your SQL script, running from SQL*Plus.

Xuening Sun

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Oct 28 1998 - 08:19:49 CST