Compare Failed with error "ORA_01406" on float(126) datatype (14823)

When a compare table is issued with the table HIGH_PRECISION, the following logs are generated in the event_log file at the target machine:

"12/01/05 16:02 Process launched: sp_declt (for o.SOURCE-o.TARGET-136309542) [pid = 26454]
12/01/05 16:02 Notice: Opened DataEquator session log file /usr/app/TARGET/splex/splex_queue/log/TARGET_declt-OWNER.HIGH_PRECISION-10562-01.log [sp_declt(deq)/26454]
12/01/05 16:02 Notice: Oracle env - TARGET:/usr/app/TARGET/oracle/product/10.1.0 [sp_declt(pdb)/26454]
12/01/05 16:04 Error: Oracle Error 1406: ORA-01406: fetched column value was truncated. [sp_declt(deq)/26454]
12/01/05 16:04 Internal error: Error 1 in de_batch_setup see TARGET_OWNER.HIGH_PRECISION-10562-*.log [sp_declt(deq)/26454]
12/01/05 16:04 Process exited sp_declt (for o.SOURCE-o.TARGET-136309542) [pid = 26454] - exit(0)"

Further inspection identified that for compare to work, it has several decimal points (tested with >=6 digits ) then the sum of the exponential value and the number of decimal points must be less than 135 (i.e 9.88888888E-126 has 8 decimal points and an exponential value of 125 - total is 8 + 126 = 134 - it fails with 9.999999999E-126 which has a total of 9+126=135).

update "HIGH_PRECISION" set C3=9.88888888E-126,C_MAT04=9.88888888E-126,C6=9.88888888E-126,C7=9.88888888E-126,C8=9.88888888E-126;

Same Compare now works

ID Tablename Status Since
---------- ---------------------------------------- --------- ------------------
2786.1 "OWNER"."HIGH_PRECISION" In Sync 17-Jan-06 11:57:14

Software bug, related to float(126) datatype. The current buffer allocated for float is 139; however, the float (126) can return up to 165 characters that cause the problem.

WORKAROUND:
None

STATUS:
This bug will be fixed in future release of SharePlex 5.3.