Re: External Procedure

From: Paul Cluiss <paul_cluiss_at_intervoice.com>
Date: Fri, 11 Feb 2000 11:29:18 -0600
Message-ID: <D707290995CCE839.F16BD49F36C77CA1.76F0EC5656C85DF4@lp.airnews.net>

Are you calling 'system()' from a procedure in ProC? If so, then Oracle has nothing to do with it, and the problem then is reduced to C programming. Let us know.

Paul Cluiss
Richardson, Texas

GoPahDoo wrote:

> running
> Unix Solaris
> Oracle 8i (8.1.5)
> ====================
> I want to execute a Unix shell script from within Oracle Procedure. Is
> this possible? I can not get it to work.
>
> Let's say I have a Unix shell script call "test.sh". Within "test.sh" is
> an "echo Hello" statement. I've been trying to run this script from
> Oracle using an external call to C 'system("test.sh");' but can't get it
> to work.
>
> C's system errored out by returning a number 256 instead of 0 (zero) -
> zero if command ran successfully.
>
> Please let me know. Thanks.
>
> --
> Shawn Huynh
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Feb 11 2000 - 11:29:18 CST