Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can I execute OS command from PL/SQL ???

Re: How can I execute OS command from PL/SQL ???

From: Rich Woods <rawoods_at_concentric.net>
Date: 1997/03/05
Message-ID: <331E3AD7.73B8@concentric.net>#1/1

MC12250 wrote:
>
> Hello,
> Is there a way to execute operating system commands from a stored
> procedure? Also, is there any Oracle-supplied package to initiate an
> export?
>
> Thanks,
> Andy
> andy_at_mcdirect.com

From a stored procedure, you can 'call' an anonymous PL/SQL block within a PRO*C daemon process via the DBMS PIPES package, and have it perform your O/S command.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.
Received on Wed Mar 05 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US