Oracle Database Discussions

Hi

Hi

I have a dg4odbc setup through oracle gateway services which allows a connection to a sybase database.

On our Oracle 10.2.0.5 database this works fine, eg:

2991 23-JAN-12 04-APR-11

on the 11.2.0.2.0 Oracle database i get this:

2991 ¿

The date field doesn't work just comes up with the squares.

when i try and run a query on this database link I get this error:

ORA-28528: Heterogeneous Services datatype conversion error
ORA-02063: preceding line from 8888
28528. 00000 - "Heterogeneous Services datatype conversion error"
*Cause: Either an Oracle datatype could not be converted to a non-Oracle
datatype, or a non-Oracle datatype could not be converted
to an Oracle datatype. The following are possible reasons for
for the conversion failure:
-- overflow problems (in the case of numbers)
-- length limitations (in the case of character strings)
-- invalid values passed into the conversion routines
*Action: Contact customer support of the agent vendor. If the problem is
due to size discrepancies between Oracle and the non-Oracle system,
it may not be possible to convert the value.

The ODBC connection is onthe same windows 2003 server as the Oracle 11.2.0.2.0 database

something that I've just noticed on the table through odbc, through the database link on our 10.2.0.5 database, the database sees the columns in the table as dates:


SQL*Plus: Release 10.2.0.5.0 - Production on Wed Aug 22 09:04:34 2012

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL> desc dba.View_Asset_ServiceStats@promaster
Name Null? Type
----------------------------------------- -------- ----------------------------
Lo_Code NUMBER(10)
Maintenance_Contract_Ref VARCHAR2(10)
Maintenance_Contract VARCHAR2(60)
Last_Service_Date DATE
Previous_Service_Date DATE
Last_Service_Over_12_Months NUMBER(5)

And in the test database which is 11.2.0.2.0 it shows them as varchar:

SQL*Plus: Release 11.2.0.2.0 Production on Wed Aug 22 08:44:46 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

SQL> desc dba.View_Asset_ServiceStats@promaster
Name Null? Type
----------------------------------------- -------- ---------------------------
Lo_Code NUMBER(10)
Maintenance_Contract_Ref VARCHAR2(10)
Maintenance_Contract VARCHAR2(60)
Last_Service_Date VARCHAR2(16)
Previous_Service_Date VARCHAR2(16)
Last_Service_Over_12_Months NUMBER(5)

I've searched for hours on the net and can't find any resolutions so please help

Thanks in advance
Paul