SQL 2005 Replication to Oracle 11g

Question

I am setting replication between a SQL 2005 server as a publisher and Oracle 11g as a subscriber. Connectivity to the Oracle server works fine. When the subscriber is initialized, table MSREPL7 is created in the Oracle Server. I get the following error: ORA-00932: inconsistent datatypes: expected NUMBER got BINARY (Source: MSSQL_REPL_ORACLE, Error number: 932). My guess is that the problem is when SQL tries to insert data in the MSREPL7 table. By reading some posts in Microsoft, they suggest to execute the following stored procedures: sp_MSrepl_DropDatatypeMappings and sp_MSrepl_CreateDatatypeMappings. I did that, but it didn't work. Other posts state that SQL 2005 doesn't work with Oracle 11g. Is there somebody out there with the same problem, and who knows what to do to fix? Thanks all for your help.

Answer 1

Hi,

This is a known issue. The following KB article describes the issue and provides us the resolution:
http://support.microsoft.com/kb/2000383

If there are any more questions, please let me know.
Thanks.

---

***Xiao Min Tan***Microsoft Online Community***