Re: Help getting an EXECUTABLE to run under DBMS_SCHEDULER

On 21 Dec 2005 11:16:15 -0800, "Joel Garry" <joel-garry_at_home.com> wrote:

>GeoPappas wrote:
>> The ambiguity is with the Oracle docs. In chapter 93 (yes, you read
>> that correctly!) of the OracleŽ Database PL/SQL Packages and Types
>> Reference 10g Release 2 (10.2) Part Number B14258-01 (which deals with
>> the DBMS_SCHEDULER package), within the CREATE_JOB Procedure it states
>> the following:
>>
>> "For an executable, the action is the name of the external executable,
>> including the full path name and any command-line arguments."
>>
>> This text makes it seem like you can pass in arguments along with the
>> external executable as part of the PROGRAM_ACTION parameter.
>
>Are output redirections arguments?
>
>/home2/oracle$ more xxx
>echo $*
>echo done
>/home2/oracle$ ./xxx abc >> xyz
>/home2/oracle$ more xyz
>abc
>done
>/home2/oracle$
>
>Guess not.

 A valid point, however, it does still appear to be a documentation bug, as attempting to add any arguments to the action parameter results in a "No such file or directory" error (on Linux x86/10.2 anyway - wouldn't be too surprised if there's platform-specific exceptions). This is reasonable from one point of view as you should add them with SET_JOB_ARGUMENT_VALUE, but it contradicts the documentation.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool