Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I execute OS command from PL/SQL ???
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