- You create a table that has a varchar (max) data type column in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2.
- You try to replicate the table to an Oracle server subscriber, and you select Transactional publication as the publication type.
Note The initial synchronization is successful.
- You insert or update a long value record in the varchar (max) column of the table.
For example, the value is more than 8200 characters long.
In this scenario, the Distribution Agent does not synchronize the new record to the Oracle server subscriber. Additionally, you receive the following error message:
ErrorCode = '1722'
ErrorText = 'ORA-01722: invalid number'