troubleshooting Question

Oracle equivalent to Sybase's xp_cmdshell?

Avatar of Nuno
Nuno asked on
DatabasesOracle DatabaseSybase DatabaseShell Scripting
2 Comments1 Solution23 ViewsLast Modified:
Hello, all!

I'm eager to learn if Oracle has an equivalent to Sybase'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!  :-)

ASKER CERTIFIED SOLUTION
Andrei Fomitchev
Sr. DBA

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros