Passing Arguments to Scheduler Chains

From: Uwe Küchler <uwe_at_kuechler.org>
Date: Wed, 15 Jun 2011 19:58:24 +0200 (CEST)
Message-ID: <59246.192.166.104.102.1308160704.squirrel_at_mx1bln1.prossl.de>



Dear oracle-l'ers,

I am stuck in chains here... ;-)

What already works is calling a program from a job, passing an argument to the program. So far, so good.
What I'm *trying* to do is to run a Scheduler Chain, where one of its steps start the said program.
Now, when I create a job to run the chain, I cannot add an argument value anymore with

DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE because this throws an ora-27475.
Any ideas, anyone?

I'm on 11.2.0.2, but this question was asked before for 10g and never answered:
http://www.freelists.org/post/oracle-l/parametrized-programs-in-chains-in-10g,2

Kind regards,
Uwe

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 15 2011 - 12:58:24 CDT

Original text of this message