Re: Oracle equivalent to SQL Server's xp_cmdshell?

In article <tsj95r20o6rrcb_at_corp.supernews.com>, "John says...
>
>Thanks, Jim!
>
>I think I found the relevant link on Ask Tom:
>
>http://asktom.oracle.com/pls/ask/f?p=4950:8:184840::NO::F4950_P8_DISPLAYID,F
>4950_P8_B:150612348067,Y
>
>However, it doesn't appear as if the results from the execution are returned
>to the calling procedure. But I suppose this is a start. I wish Oracle had
>better native support for this type of thing...
>
>Thanks again, Jim! :-)
>

use this one:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:952229840241

instead....

>"Jim Kennedy" <kennedy-family_at_home.com> wrote in message
>news:Cr9y7.24510$JN.89963_at_news1.sttls1.wa.home.com...
>> 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
>> >
>> >
>>
>>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp