My Oracle Support Banner

DG4DRDA 11.2 ORA-28500 "Cursor identified in Fetch statement is not open" With Greater Than 5 Result Sets. (Doc ID 1233604.1)

Last updated on FEBRUARY 05, 2019

Applies to:

Oracle Database Gateway for DRDA - Version to [Release 11.2]
Information in this document applies to any platform.


Calling a stored procedure on DB2 through Database Gateway for DRDA (DG4DRDA) version 11.2  from an Oracle Database.  When using PL/SQL code on Oracle to return result sets from the stored procedure, the first five (5) result sets are returned without issue, anything above five produces the following error:

SQL> set serveroutput on size 1000000
SQL> @db2_oracle.sql
Cursor Value1=:*-*2067*-*02-FEB-10
Cursor Value3=:*-*248*-*02-FEB-10
Cursor Value4=:*-*1448*-*01-FEB-10
Cursor Value4=:*-*2915*-*02-FEB-10
Cursor Value5=:*-*3146*-*01-FEB-10
Cursor Value5=:*-*4865*-*02-FEB-10
Error Message Sqlerrm 6= ****
ORA-28500: connection from ORACLE to a
non-Oracle system returned this message:
[Oracle][ODBC DB2 Wire Protocol driver]Cursor
identified in Fetch statement is not open. It could have been closed by a
previous commit or rollback. {HY000,NativeErr = 8301}
ORA-2063: preceding 2
lines from DB2T-Sqlcode= -28500
From DB2 Message = -Code= 0


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.