Re: Help getting an EXECUTABLE to run under DBMS_SCHEDULER

Thanks so much for the reply. I tried out your solution and it works (as you reported).

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.

Thanks for clarifying that... Received on Wed Dec 21 2005 - 13:01:17 CST