Last updated on JANUARY 18, 2017
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.2]
Information in this document applies to any platform.
You have the following setup on Solaris -
- RDBMS 10.2.0.5
- DG4ODBC 184.108.40.206
- Connx 64-bit 11.00.11202 ODBC driver
- Adabas 9.0
The following SQL is run -
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 -
Using the same code with 10.2 HSODBC and a Connx 32-bit driver returns results using a variable.
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