How to Pass Concurrent Request id from the 1st program to the next in Request Set
HI
I have a concurrent request set defined in 11i.
1st Program - Loads data through SQL Loader
2nd Program - Processes the data loaded from the 1st program
I want to pass the concurrent request from the first program to the second program so that if multiple users run this request set, the 2nd program will only pick up the request_id from the 1st program and processes it so that there is no mess up else the 2nd program can pick up any 1st program run by other request sets.
Please advise.
Thanks
Ram