Query That Return Multiple Rows using 11.2 DG4DRDA Returns The First Row Value For All Rows For a Variable Length Column (Doc ID 1443783.1)

Last updated on APRIL 03, 2012

Applies to:

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

Symptoms

A query that returns multiple rows using Database Gateway for DRDA (DG4DRDA) 11.2.0.2 returns the first row value for the variable length field for all the rows returned.
If selecting only one row by specifying a WHERE clause it shows the correct result, but when using 'select * from table_name' then the problem happens.

When specifying the WHERE clause, the MSGDVDATA column is showing the correct result, see below:

SQL> set long 1000000
SQL> select * from OWNER.OFACMSGD@DG4DRDA_112 where MSGDSEQNO=5595;
MSGDSEQNO MSGDDTLNO MSGDRTYPE
---------- ---------- ------------
MSGDVDATA
-----------------------------------------------------------------------------
5595 1555 F5
THE KEY TO ANY RECURSIVE PROCESS, WHETHER IT IS A RECURSIVE P
ROGRAMMING ALGORITHM OR QUERYING RECURSIVE DATA, IS THAT T


When querying all the table, the MSGDVDATA column is showing the same value in all rows, see below:


SQL> set long 1000000
SQL> select * from OWNER.OFACMSGD@DG4DRDA_112;
MSGDSEQNO MSGDDTLNO MSGDRTYPE
---------- ---------- ------------
MSGDVDATA
-----------------------------------------------------------------------------
5588 1551 F2
THIS RECURSIVE QUERY IS WRITTEN IN TWO PARTS. THE FIRST PART OF THE COM
MON TABLE EXPRESSION IS CALLED THE INTIALIZATION FULLSELECT. IT SELECTS
5591 1553 F4
THIS RECURSIVE QUERY IS WRITTEN IN TWO PARTS. THE FIRST PART OF THE COM
MON TABLE EXPRESSION IS CALLED THE INTIALIZATION FULLSELECT. IT SELECTS
5595 1555 F5
THIS RECURSIVE QUERY IS WRITTEN IN TWO PARTS. THE FIRST PART OF THE COM
MON TABLE EXPRESSION IS CALLED THE INTIALIZATION FULLSELECT. IT SELECTS

The same data is returned for the MSGDVDATA column for all the rows returned.


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