Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

executing os commands from oracle 8.0

Juan Pena_1
Occasional Advisor

executing os commands from oracle 8.0

I need to execute an os command con my HP-UX system from an oracle 8 stored procedure.
But I don't want to use DBMS_PIPE command.

Can anybody help me?
2 REPLIES
Rita C Workman
Honored Contributor

Re: executing os commands from oracle 8.0

If memory serves me right....I believe you can escape to the operating system by doing something like this:

SQL> HOST
$ (enter any O/S command you want)
$exit
SQL>

And, the HOST command can include the operating system command.
SQL> HOST dir

/rcw
Juan Pena_1
Occasional Advisor

Re: executing os commands from oracle 8.0

I can use HOST on SQL*Plus but not I can not use this command in a stored procedure.