Change Parameter Values for a Scheduled Request
I had a requirement that for one of the parameter of a scheduled program should change with each run. So I decided to use a sequence and select the nextval. Nextval correctly works when we submitt the program manually each time but when scheduled for each scheduled run it picks up the same value. Is there a way to get around this situation or innovative way to achieve the requirement of unique parameter.
Thanks & Regards
Mohit
0