-
Type:
Bug
-
Status: Resolved
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 4.1.0
-
Fix Version/s: 4.2.0
-
Component/s: None
-
Labels:None
-
Environment:
Oracle
When upgrading from 4.0.0 to 4.1.0 the upgrade fails when the DB contains CLOBS of zero length with the following error
ERROR:
ORA-22994: source offset is beyond the end of the source LOB
ORA-06512: at "SYS.DBMS_LOB", line 978
The reason for this is that DBMS_LOB.CONVERTTOBLOB does not handle zero length CLOBs correctly.
The fix is to explicitly check for the lob.length and skip those when doing the conversion