Re: run an external OS script in Oracle 10g

From: Ronald Rood <devnull_at_ronr.nl>
Date: Tue, 25 Apr 2006 16:50:16 +0200
Message-ID: <0001HW.C07403C800EA0FA8F0284530@news.individual.net>

On Mon, 24 Apr 2006 19:53:51 +0200, Michele Campagni wrote (in article <444d10b0$0$29096$5fc30a8_at_news.tiscali.it>):

> "Mladen Gogala" <gogala_at_sbcglobal.net> ha scritto nel messaggio
> news:pan.2006.04.22.21.46.32.914184_at_sbcglobal.net...
>

>> executed by Oracle scheduler should be owned by the user "nobody", not
>> user "oracle".

>
> ok, now script run but oracle reports:
> ORA-27369: job of type EXECUTABLE failed with exit code: Unknown error
> ORA-06512: at "SYS.DBMS_ISCHED", line 150
> ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
> ORA-06512: at line 1
>
> I repeat: script run and works, but I still have this warning...
>
>

Could it be that the script just returns an exit code (or none at all) ? The oracle scheduler has funny reactions on them. Try with explicit exit 0.

--
With kind regards / met vriendelijke groeten,
Ronald

http://ciber.nl
http://homepage.mac.com/ik_zelf/oracle

Received on Tue Apr 25 2006 - 09:50:16 CDT