Databases
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.