ORA-00932: inconsistent datatypes: expected - got BLOB

Problem Description

When replicating lobs, following error appears:

Information for conflict 9987010048446 (current conflict):
    Table: DW_STG.TAG_IMAGES at transaction 0008.00b.00163a98 at SCN 202061879403
    SQL text (with replaced bind values): update "DW_STG"."TAG_IMAGES"
    set "SCANNED_IMAGE" = ''
    where (1=1)
    and "SCANNED_IMAGE" = ''
    and "TAG" = 6934626
    and "CT006_ID" = 'TUL'
    Error: ORA-00932: inconsistent datatypes: expected - got BLOB

Solution

LOB column in this case is SCANNED_IMAGE column. The problem in this case is, that Dbvisit Replicate with Limited edition(LTD), does not replicate LOBs and MINE process leaves the column empty. The apply then incorrectly handles this record.

To solve this problem, please upgrade to Extended (XTD) or better edition: http://www.dbvisit.com/products/dbvisit-replicate-editions

But its also recommended to go through the user guide and see if Datatypes are supported or Unsupported for the particular version.

Version 2.7

https://dbvisit.atlassian.net/wiki/display/ugd7/Supported+Datatypes

Version 2.8

https://dbvisit.atlassian.net/wiki/display/ugd8/Supported+Datatypes