Oracle Integration Cloud Service DB Adapter Issue

Summary

Oracle Integration Cloud Service DB Adapter Issue

Content

Issue Details –

We are trying to invoke a Stored Procedure using Integration Cloud Service (ICS) DB adapter. This is a simple Stored Proc which would return 1000 records and the count from a table – However it’s causing an issue even the record count is 500 –

The snippet is as below -

SELECT a.*

BULK COLLECT INTO line_stag_rt

FROM line_stg_g1 a

WHERE processed_flag = 'N'

AND ROWNUM <= 500;              

          l_total_count := line_stag_rt.COUNT;

While we are trying to invoke the Query, it’s giving Timed Out exception. We have set timeout as 240 seconds and the adapter is non responsive to provide the response within 240 seconds. However, the procedure returns the result if the count is 400. Below is a matrix based on our observation –