Re: Oracle equivalent to SQL Server's xp_cmdshell?

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! :-)

"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
> >
> >
>
>
Received on Sun Oct 14 2001 - 09:44:11 CDT