1. Created a oracle table in 11g having a BLOB column
CREATE TABLE "HR"."LOB_TABLE" (
"ID" NUMBER NULL,
"DOC" BLOB NULL
)
2. Used the attached file to import in ADSA 13.0 with Transaction=Batch and 1 row is successfully imported
3. Now opened in ADS v14.0.4 and imported the same file with Transaction=Batch and you get below exception
java.lang.ClassCastException: javax.sql.rowset.serial.SerialBlob cannot be cast to oracle.sql.BLOB
at oracle.jdbc.driver.OraclePreparedStatement.setBlob(OraclePreparedStatement.java:6663)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.setBlob(OraclePreparedStatementWrapper.java:128)
at \\...\\ .\\हिñçêČάй語简??한\\.aꉷꐿꎿ⣿ 6 super.setBlob(Unknown Source)
at \\...\\ .\\हिñçêČάй語简??한\\.jꉦ⠶ꐆꄻ.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简??한\\.jꉦ⠶ꐆꄻ.process(Unknown Source)
at \\...\\ .\\हिñçêČάй語简??한\\.jꉦ⠶ꐆꄻ.run(Unknown Source)
|
67 KB
![]() |
16 B
Verified in 14.0.5-1
Issue #10706 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 14.0.5-1 |
No time estimate |
Verified in 14.0.5-1