Re: Execute command in stored proc?

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 25 Mar 2004 06:50:01 -0500
Message-ID: <YcednVmSk64XWv_d4p2dnA@comcast.com>

"Douglas Hawthorne" <douglashawthorne_at_yahoo.com.au> wrote in message

news:T8v8c.123781$Wa.67244_at_news-server.bigpond.net.au...

| "Chin Yeow Tan" <chin.yeow.tan_at_intel.com> wrote in message
| news:c3tsu6$jnb$1_at_news01.intel.com...
| > Hi,
| >
| > Is it possible to execute DOS command using stored procedure in Oracle?
| >
| > Thanks.
| >
| >
| Yes, see "Java procedure for host calls on Unix environment" at
|

http://asktom.oracle.com/pls/ask/f?p=4950:8:6660632305715668107::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:952229840241,
|
| The same principle applies in a DOS environment as it does in a UNIX
| environment - you are using Java to execute the command. If you scroll
down
| the page, you will see DOS in action.
|
| Douglas Hawthorne
|
|

be aware, though, that the command is executed on the database server, not on the client machine that executes the stored procedure

if you need to execute a dos command on the client, that would need to be done via the tool you are running

what exactly is your environment (client os, server os, db version, UI tool)?

;-{ mcs Received on Thu Mar 25 2004 - 05:50:01 CST