Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Null values from DB2 cause problems

dsmoljanovicMar 30 2010 — edited Mar 30 2010

Hi,
I have another problem with database link to DB2 using IBM iSeries Access for Linux on 64 bit OEL5 with Oracle Database gateway and unixODBC 2.2.14.
DB link works. However, null values from DB2 cause problems. Date columns that are null on db2 return a date '30.11.0002', and character columns that are null return an error ORA-28528: Heterogeneous Services datatype conversion error.
isql returns correct results.

How can i fix this? Perhaps set some parameters for data conversion on the gateway?

Thank you.

This post has been answered by Kgronau-Oracle on Mar 30 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 27 2010

Added on Mar 30 2010

#heterogeneous-connectivity

8 comments

2,540 views