How to alter a parameter in a scheduled conc. program [message #317979] |
Mon, 05 May 2008 03:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
techno
Messages: 44 Registered: October 2003
|
Member |
|
|
Hi,
I want to schedule a concurrent program to run once in a day with a fixed list of parameters. But out of all parameters one should be unique for each run otherwise the program gets errored out. For this reason I could not schedule it.
I want to attend the value to_char(sysdate,'MMDDYYHHMISS') to that parameter for each run while in scheduling to avoid the unique constarint voilation. The other portion of the parameter is constant always ( for ex. 'ABCD0201081150' or 'ABCD0204081152' .......)
Pl. help me in resolving this.
Thanks and regards
Techno
|
|
|
Re: How to alter a parameter in a scheduled conc. program [message #318042 is a reply to message #317979] |
Mon, 05 May 2008 07:11 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
akil0576
Messages: 4 Registered: February 2008 Location: Jeddah
|
Junior Member |
|
|
Is this a custom concurrent program then there should not be any problem in passing different parameters for each run , because you would already be passing your value during run time. Just schedule this concurrent program from where you run requests, which can be scheduled to run everyday.
|
|
|
|