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.