Re: Running os commands from PL/SQL ?

From: Chris Halioris <halioris_chris_nonlilly_at_lilly.com>
Date: 1997/02/10
Message-ID: <32FF8D3A.F84@lilly.com>#1/1

AlBeRt tHe GoD wrote:
>
> I remember reading somewhere that I can user a certain Oracle Package to
> run operating system commands, any info is appreciated.
>
> thanks

One method is to use DBMS_PIPE. Using DBMS_PIPE you can pipe a message which can be picked up by an OS session running a SQL*Plus script that is waiting for a message in the pipe (which is the OS command to run). It can then run the OS command.

Chris Halioris
Tactics, Inc. Received on Mon Feb 10 1997 - 00:00:00 CST