Passing Arguments to Scheduler Chains

  • From: Uwe Küchler <uwe@xxxxxxxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 15 Jun 2011 19:58:24 +0200 (CEST)

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:
//www.freelists.org/post/oracle-l/parametrized-programs-in-chains-in-10g,2


Kind regards,
Uwe


--
//www.freelists.org/webpage/oracle-l


Other related posts: