SQL server 2012 - Oracle Replication

SQL replication from Oracle database in SQL 2012 64 bit server gives errors  - ora 04086 - Trigger description too long
ORA 25006  - Cannot specify this column in update of caluse errors
The same tables had been replicated without issues in sql 2005 - 32 bit version
Anybody experienced this and any workarounds, please share.
HumanScaleDevAsked:
Who is Participating?
 
HumanScaleDevAuthor Commented:
Modified the package in oracle to remove uodate on clause in trigger
0
 
AnandCommented:
not experienced the exact situation . but couple of ideas to share.

create a simple table and try to replicate. works well means, problem is with specific column or data type. could be some bug and u may get some patch for that.
0
 
HumanScaleDevAuthor Commented:
Proved to be working
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.