Re: Execute command in stored proc?

Thanks all for the info.

Executing the command on the server is what I am looking for.

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:YcednVmSk64XWv_d4p2dnA_at_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_P 8_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 Tue Mar 30 2004 - 20:31:20 CST