Oracle Database Discussions

First, I am not sure this is the right forum but here is my issues. I have a named program unit setup up to execute an OS(UNIX) shell script. The shell script requires one parameter be sent to it. I set up a parameter in the named program in dbms_scheduler and gave it a default value. I create a job to run this named program and I get a failure due to no parameter being passed to shell script. If I set the job up and put in a value for the parameter in the job parameter screen, thus overriding the default displayed, the job runs as expected. It appears that the program does not pick up the default value and pass it to the executable shell script unless I explicitly address the parameter in the job parameter screen. Unfortunaetly, I need the program unit as part of a long chain and when I set up the chain and job I do not get the option to put a job parameter into the job. I would think that when the program ran as part of a chain that it would use the default value for the program and pass that to the executable on the OS. I would also think that the only reason one would actually value the parameter in the Job would be to change the value and not use the default. Thanks in advance.

Edited by: gdaustin1 on May 7, 2012 1:52 PM