dbms_scheduler: external program under unix 1

[SimonSellick]

Hi,

Has anyone made this work? I'm struggling to get the external program to run. If I specify the entire pathname it manages to find the command, but if it tries to do anything useful it falls over with insufficient unix permissions to write anything anywhere (apparently). The only command that I have succeeded in making run is

/usr/bin/ls

- which loses its stdout somewhere. If I try to catch stdout in a file

/usr/bin/ls >/tmp/x

it complains 'No such file or directory'. What I am trying to achieve is to run a ksh script which will create various files.

Any suggestions welcomed.

 

[SimonSellick]

In case it's of any interest, the problem was the unix environment: the user session started by Oracle to run the executable has been configured on my site to land at / with no path or other environment set, so everything has to be spelt out in the script.

 

[KenCunningham]

Simon, thanks for the update. I must admit I looked at this the other day and thought it might be related to environment variables (which is also a problem with unix cron jobs). Then I forgot to check back when I had more time!

A star for being kind enough to complete the picture.

I don't mind people who aren't what they seem. I just wish they'd make their mind up.

 

[SimonSellick]

Ken,

That's the first time I've been given a star for my own question! Thanks

Simon

 

[KenCunningham]

But you answered it and thus added to the forum knowledge-base, so that's what it's for. Too many times we see threads which are left hanging without a resolution, or not one which the poster sees fit to pass on.

I don't mind people who aren't what they seem. I just wish they'd make their mind up.