Re: Running OS commands from PL/SQL

You could also wait. I heard at a recent Oracle conference that Oracle 8 will provide greater support for OS commands.

Dan Rippel wrote:
>
> We'll if dont want to use pipes and Pro*C, you are pretty much out of
> luck if you want to run the command directly from PL/SQL.
>
> Another alternative would be to write your commands to a table that
> will act like a meesage queue. Then write a shell script to come
> along and loop through the table and execute the commands.
>
> Or instead of a table, you could use the file I/O package to write the
> commands to a data file. Again a shell script or cron job will come
> along and run any commands found in the file.
>
> On Fri, 07 Feb 1997 09:58:05 +0000, Gary Streeter
> <streeterg_at_logica.com> wrote:
>
> >Does anyone know if it is possible to run operating system level
> >commands from within a PL/SQL stored procedure (aka: the SQLPLUS "HOST"
> >command)?
> >
> >I know it is possible to use the pipes package to pass commands to a
> >Pro*C daemon but we wish to avoid Pro*C.
> >
> >We are running Oracle 7.3.2.1.0 with PL/SQL 2.3.2.0.0 under Unix System
> >V release 4.0
> >
> >Gary
> >
> >streeterg_at_logica.com
Received on Tue Feb 11 1997 - 00:00:00 CET