This has been addressed a bunch of times in the ng. You can do it a couple
of ways. dbms_pipe with an external program reading the pipe and doing what
you want, use a Java stored procedure, an external program called from a
stored procedure. See MetalLink or Thomas Kyte's site (Ask Tom).
Jim
"John Peterson" <johnp_at_azstarnet.com> wrote in message
news:tsi88teg6qqh82_at_corp.supernews.com...
> (Oracle 8.1.7.2.1 on Windows 2000)
>
> Hello, all!
>
> I'm eager to learn if Oracle has an equivalent to SQL Server's xp_cmdshell
> extended stored procedure. The xp_cmdshell function essentially shells
out
> to the OS and executes the provided string. One of the nice features of
> xp_cmdshell is that it will return the output as rows of text and can thus
> be handled as a result set you can cursor through.
>
> I'm having a tough time figuring out how to execute an OS command from
> Oracle, in general. Would DBMS_PIPE be something that can be leveraged?
Is
> there something like xp_cmdshell?
>
> Thanks for your help! :-)
>
> John Peterson
>
>
Received on Sun Oct 14 2001 - 00:32:18 CDT
