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 OCTOBER 27, 2010

Applies to:

Oracle Database Gateway for DRDA - Version: 11.2.0.0 to 11.2.0.1 - Release: 11.2 to 11.2
Information in this document applies to any platform.

Symptoms

Calling a stored procedure on DB2 through Database Gateway for DRDA (DG4DRDA) version 11.2  from an Oracle 10.2.0.4 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


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms