HPE Community
Operating System - HP-UX
1753354 Members
4994 Online
108792 Solutions
New Discussion юеВ

executing os commands from oracle 8.0

 
Juan Pena_1
Occasional Advisor

тАО01-15-2001 08:35 AM

тАО01-15-2001 08:35 AM

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?
0 Kudos
Reply
2 REPLIES 2
Rita C Workman
Honored Contributor

тАО01-16-2001 07:05 AM

тАО01-16-2001 07:05 AM

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
0 Kudos
Reply
Juan Pena_1
Occasional Advisor

тАО01-16-2001 10:01 AM

тАО01-16-2001 10:01 AM

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.

0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.