Re: Help getting an EXECUTABLE to run under DBMS_SCHEDULER

GeoPappas wrote:
> 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.

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.

>
> Thanks for clarifying that...

jg

--
@home.com is bogus.
Happy Birthday, Samuel L. Jackson!  http://www.samuelljackson.com/
Pulp Fiction!