Re: Running OS commands from PL/SQL

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 Sun Feb 09 1997 - 00:00:00 CET