Async Stored Procedure Call from OIC through Oracle ATP Adapter
Summary:
Currently, we are having timeout issue (exceeding 240 seconds) when executing a Stored Procedure through ATP Adapter. I don't think there's any problem on the DB SP side (it may finish around 5-10minutes and it has been optimized already).
Any inputs/ideas as to how to handle this properly, given the forced timeout limitation for OIC Adapters - specific for Oracle ATP Adapter? We are unable to do a major overhaul on the integration (pretty complex & development time is also a concern), so we can adjust it through scope level at this point. We are thinking of handling this Async way - but I'd appreciate any inputs for that matter.
0