Hello All
I want call Procedure that take more than 300 seconds.
when call it using expression rule the result is (ORA-01013: user requested cancel of current operation) and maximum timeout is 300 second
how can I call this procedure?? Is there a plug-in that increases the maximum timeout?
Discussion posts and replies are publicly visible
Try to optimize the stored procedure by removing unwanted joins and remove unwanted fields from selection, even if that is not working then you can try to increase the time out of store procedure.
You can refer the link for more details.
Thanks