Re: Oracle equivalent to SQL Server's xp_cmdshell?

Thanks again, Thomas! I'll give this a whirl! :-)

John Peterson

"Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message news:9qd7i50qeb_at_drn.newsguy.com...
> In article <tsk5u4ghlmda9f_at_corp.supernews.com>, "John says...
> >
> >Hello, Thomas!
> >
> >Thanks for the Java example! This looks like something that I'll be able
to
> >leverage! :-)
> >
> >Out of curiosity, how would you recommend modifying this (or can it be?)
to
> >return the output as a result set that can be "cursored" through?
> >
> >Thanks again!
> >
> >John Peterson
> >
>
> I'd probably do it in the manner I did this:
>
>

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:439619916 584
>
> for getting a directory listing (dumped it into a global temporary table).
run
> the procedure, query the temp table or write a procedure that runs the
procedure
> and returns a REF CURSOR that is the select * from the temp table (ala
sqlserver
> technique) see http://osi.oracle.com/~tkyte/ResultSets/index.html for
howto
> with ref cursors.
>
>
>
>
>
> >"Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message
> >news:9qctum0439_at_drn.newsguy.com...
> >> 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:95222984
0
> >241
> >>
> >> 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
> >>
> >
>
> --
> 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
>
Received on Mon Oct 15 2001 - 00:54:52 CDT