You can. I have done it, but I don't have the code in front of me. Found
it in a Java book. So it is well known. One thing that is dangerous about
this type of thing is that you are giving the user the same priv. as Oracle.
This means they could issue a command to delete or format the disk. Not a
very good thing.
Jim
"John Peterson" <johnp_at_azstarnet.com> wrote in message
news:tsj95r20o6rrcb_at_corp.supernews.com...
> 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 - 12:01:09 CDT
