| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Running OS commands from PL/SQL
Is it just PRO*C you are trying to avoid or does the same apply to PRO*Cobol ? 'cos MicroFocus Cobol for Unix allows you to 'host out' to the OS as well
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 23 1997 - 00:00:00 CST
 |
 |