try giving oracle the full path to you shell script.
also within you shell script try to give each command the full path.
Let me know if had any more problems.
Tom
GoPahDoo <gopahdoo_at_my-deja.com> wrote in message
news:87veo4$1rc$1_at_nnrp1.deja.com...
> 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 Thu Feb 10 2000 - 21:37:28 CST
