Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Passing Arguments to Scheduler Chains

ora_et_laboraJun 16 2011 — edited Jun 17 2011
Dear fellows of the Oracle,

can I pass arguments to programs within a chain?

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 starts 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.
Looking at the docs it seems as if there's no way to do what I want - which I thought I could take for granted...
Any ideas, anyone?

I'm on 11.2.0.2.
Kind regards,
Uwe
This post has been answered by 56219 on Jun 16 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2011
Added on Jun 16 2011
6 comments
3,657 views