Last updated on JANUARY 18, 2017
Applies to:Oracle Database Gateway for Sybase - Version 11.1.0 to 18.104.22.168
Information in this document applies to any platform.
A previously running PL/SQL containing ROWTYPE declaration and calling the Database Gateway for Sybase (DG4Sybase) is failing with -
Current SQL statement for this session:
SELECT COMMENT_TXT FROM ID_COMMENT@SYB WHERE ENTITY_TYP = 'X' AND COMMENT_TYP = 0 AND ENTITY_NUM = :B1
If the PL/SQL is rewritten to use normal declarations then it does not produce the error and also if the number of selected rows is 0 the error does not reproduce with ROWTYPE.
The RDBMS calling the gateway has been upgraded from 10.2.0.4 to 10.2.0.5.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms