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!

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

Marco, the version is 4.1.1.0. Delphi version is XE5

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!