Hi All,
I have a plsql procedure which takes around 50 minutes to complete.
The input to the procedure is sent from the application.
The users are OK with procedure taking that much of time(the logic is complex ). But, the application cant wait for more than 5 min and if it crosses the limit thread hungs will come.
So, we are thinking of passing the input parameters to oracle and store it temporarily somewhere and exit from there. Then, some automatic job or something that can run its own time in oracle.
Can you suggest any way other/ better way of doing this or Is using scheduler the only way?
Kindly help