Post reply

Strange error in replication to Oracle

  • July 6, 2004 at 4:06 pm

    #83300

    We have a transactional replication between SQL Server 2000 and Oracle 8i which has been working fine for over 2 years. Suddenly we get an error message back from Oracle "ORA-01401: Inserted value too large for column"

    This is caused by a rowguid column suddenly having curly brackets wrapped around the value, causing the varchar 36 column on the Oracle side to be too narrow - it is now expecting varchar 38.

    Any ideas how this may have happened and is there a cure? Linked server uses OLE DB.

     

  • July 6, 2004 at 5:42 pm

    #513536

    Am I missing something here? Correct me if I'm wrong but to solve this, wouldn't you just have to increase the VARCHAR(36) Column to VARCHAR(38) or perhaps VARCHAR(40) to be sure to be sure?

    Kindest Regards,

  • July 7, 2004 at 1:50 pm

    #513727

    Yes - changing the column width is the immediate answer, although there are other knock-ons. It was the cause of this change that worried me after a couple years of stability - it's still unexplained

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply