November 4, 2009 at 2:10 pm
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.
November 4, 2009 at 7:43 pm
Please don't cross post. it just wastes people's replies and fragments replies.
no replies to this thread please. Replies to: http://www.sqlservercentral.com/Forums/Topic813865-291-1.aspx%5B/url%5D
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply