Exception while reading large Blob field

[Steven Wu]

HI, we have some blob field which normally is below 1MB. Recently we found the TOracleQuery will throw an exception when the the field size is too big, 80MB in our example. The exception is:

ORA-24817: Unable to allocate the given chunk for current lob operation

Is there any settings to fix this?

Thanks!

 

[Marco Kalter]

Can you let me know your exact Direct Oracle Access version?

 

[Steven Wu]

Marco, the version is 4.1.1.0. Delphi version is XE5

 

[Steven Wu]

Sorry, Marco, the Field type is CLOB, not BLOB. We're using it for storing XML. Also there is no exception with ADO connection.

Thanks!