Hello peeps

We're doing a migration from XE3sp2 to XE12.3 and I've stumble on an issue with saving blobs to an Oracle database.

I've tried with and without direct mode but both resulted in a Invalid Typecast exception.

Our previous implementation in c++ was using the LoadFromStream method with the DataType as ftOraBlob and in Delphi was using the AsBlobRef, also with ftOraBlob datatype.

I managed to get it to work by using the AsBlobRef approach but with ftBlob as a DataType.

I went through the changelog for UniDac and found the following entries that might have something to do with blobs since the version we were using(7.1.4) until the last one available:

8.4.1 - LOB read/write performance is improved

8.4.3 - Bug with assigning a BLOB parameter when the source data is loaded via the TParam.LoadFromStream method is fixed

8.4.4 - Bug with CLOB when UnicodeEnvironment=True is fixed 

9.0.1 - Fixed bug with using a BLOB field in the IndexFieldNames property of the DataSet component

9.4.0 - Fixed bug with LOBs reading in the Direct mode 

10.0.0 - Fixed bug with inserting BLOBs using TVirtualQuery

10.1.0 - Fixed bug with CLOB reading when UseUnicode=True in OCI mode 

10.3.2 - Fixed a bug that caused the last LF to be incorrectly converted to a CRLF line break in CLOB values

10.4.1 - Resolved an issue with reading LOBs in threads

Is this the intended way moving forward or did I stumble on a bug?

PS: In Delphi, AsBlobRef with ftOraBlob still works as expected