You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Oracle Integration Cloud Service DB Adapter Issue

Received Response
edited Oct 3, 2017 7:00AM in Integration 8 comments


Oracle Integration Cloud Service DB Adapter Issue


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 -


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 –

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!