Hi,
This is my first time post the question in this community. Apologize if this is not the right place to start and lease let me know where to post this instead.
I have a database link connect through the odbc to Ingres. Everything works as expected except when I try to select from ODBC (HS) where the column is NULL, it returns the error:
select * from mynull@ingres;
ORA-28562: Heterogeneous Services data truncation error
ORA-02063: preceding line from INGRES
Here is the trace that matters:
hgoftch2, line 139: Printing hoada @ 0xe55288
MAX:1, ACTUAL:1, BRC:1, WHT=5 (SELECT_LIST)
hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
12 VARCHAR Y 1 1 0/ 0 0 0 200 col1
SQLFetch: row: 1, column 1, bflsz: 2, bflar: -1
SQLFetch: row: 1, column 1, bflsz: 2, bflar: SQL_NULL_DATA
1 rows fetched
here is the hsinit:
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = rd-cdsuat02
HS_FDS_TRACE_LEVEL = DEBUG
HS_FDS_TRACE_LEVEL0=255
#HS_FDS_FETCH_ROWS=1
HS_FDS_SHAREABLE_NAME = /opt/Ingres/IngresII/ingres/lib/libiiodbcdriver.1.so
HS_LANGUAGE=american_america.we8iso8859P1
#HS_KEEP_REMOTE_COLUMN_SIZE=REMOTE
#
# ODBC specific environment variables
#
set ODBCINI=/opt/Ingres/IngresII/ingres/files/odbc.ini
The values in the mynull table at the Ingres side is added like this:
create table mynull(col1 char(1) with null);
insert into mynull values(NULL);
The idea is to use database link to convert the Ingres data over to Oracle. I have the tables all created and copied 90% of the data but stuck with any data that has NULL values in it. Can someone tell me what I did not do right?
Thanks,
HY