Hi Guys
We are facing the following error in our UAT env while calling this proc of the package.
It is a big proc and at the end we are just opening a cursor to return to the application.
The error application is getting is : No More data to read from socket(intermittently)
I could replicate this while calling this via sqlplus where the error comes (always) as :
ORA-25401: can not continue fetches
variable insdata refcursor
declare
res varchar2(4000);
insdata sys_refcursor;
begin
pkg.read_all_details(
i_operation_id => 'local_vc' ,
i_executing_usr_id => 'vc',
i_json => <a json data> ,
o_json_response => response,
o_ig_cursor => :insdata
);
end;
/
print insdata;
If the returned data from cursor is less than 10 records then we dont get the error. The returned data is json clob.
One more point is that if I execute this without using variable and print and use fetch inside the block to print, I dont get any error, but the java application is still getting error.
Could you please shed some light why application is getting this error. Let me know if you need any further details.
Regards