WPHIT
asked on
Oracle Gateway connection to Sybase not working after 11g Database upgrade
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
I've searched for hours on the net and can't find any resolutions so please help
Cheers
Paul
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
I've searched for hours on the net and can't find any resolutions so please help
Cheers
Paul
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sorted on other forum
ASKER
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_ServiceStat
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_Month
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_ServiceStat
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_Month