Re: Calling external shell scripts from sql code

Hi

In SQL*Plus you can use:

host $XYZ_BIN/abc.sh

or a complicated one like

host (nohup /usr/bin/sleep 300 1> /dev/null;/usr/bin/rm $HOME/rep/report1.lst 2>
 /dev/null) &

The key SQL*Plus command is HOST, which puts you into the UNIX operating system.

Regards

Oracleguru

Waterman Family <waterman_at_iwaynet.net> wrote in article <71anid$nog$1_at_news.iwaynet.net>...
> Oracle 8 has a new feature that allows you to call external functions
from
> PL/SQL. I would start by looking in the Oracle 8 documentation (chap 10
in
> the PL/SQL Manual) and maybe even a training class. I know it has a
> learning curve, but it is definately possible.
> --Gary
> Espen Ekeroth wrote in message <3636CCBB.685A1534_at_hand-el.no>...
> >
> >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
> >
> >--
> >Espen Ekeroth, OM Hand-El AS
> >mailto:espene_at_hand-el.no mailto:e_ekeroth_at_hotmail.com
> >+47 69215581 / +47 92499076
>
>
>
Received on Fri Oct 30 1998 - 13:39:50 CST