Using DG4ODBC and Connx 64-bit ODBC Driver to Adabas Causes a Core Dump When a Variable is Used in a Select Statement (Doc ID 1414473.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms


You have the following setup on Solaris -

- RDBMS 10.2.0.5
- DG4ODBC 11.2.0.2
- Connx 64-bit 11.00.11202 ODBC driver
- Adabas 9.0

The following SQL is run -

SQL> variable fnum number;
SQL> exec :fnum := 55113758 ;

PL/SQL procedure successfully completed.

SQL> SELECT COL1 FROM PERSON@CONNX64 WHERE COL2 = :fnum ;

no rows selected


- gives no rows returned but when exit from SQLPLUS a core dump is created.
When run with an actual value then data is returned without a core dump -

SQL> SELECT COL1 FROM PERSON@CONNX64 WHERE COL2 = 55113758 ;



Using the same code with 10.2 HSODBC and a Connx 32-bit driver returns results using a variable.

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