Home Forums SQL Server 2008 Working with Oracle ORA-00932: inconsistent datatypes: expected FILE got BINARY when Initializing SQL 2k8R2 Publication to Oracle 12c Sub RE: ORA-00932: inconsistent datatypes: expected FILE got BINARY when Initializing SQL 2k8R2 Publication to Oracle 12c Sub

  • July 7, 2016 at 7:32 am

    #1888911

    Hello,

    I am running SQL Server 2008 (SP4) - 10.0.6000.29 (X64). I am experiencing a problem attempting to create a replication article with Oracle 12c as Publisher. The workaround solution mentioned in this thread requires 2 stored procedures below.

    1. sys.sp_MSrepl_ORAdatatypes

    2. sys.sp_MSrepl_ORA_MSSQL_datatypemappings

    I receive the following errors when I execute these procedures. Where are these procedures?

    Msg 2812, Level 16, State 62, Line 1

    Could not find stored procedure 'sys.sp_MSrepl_ORAdatatypes'.

    Msg 2812, Level 16, State 62, Line 1

    Could not find stored procedure 'sys.sp_MSrepl_MSSQL_ORA_datatypemappings'.