Re: Execute command in stored proc?

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Thu, 25 Mar 2004 06:39:47 GMT
Message-ID: <T8v8c.123781$Wa.67244@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 Received on Thu Mar 25 2004 - 00:39:47 CST