Out of memory editing a row having a BLOB with huge data

[omarspa]

I have 1 record in a dataset. In this record there's a blob field having 100 MB size.
I have to substitute value for this field.
If i try to do it i get error when i invoke "Edit" procedure:

Do I really have to use TLobLocator instead of TOracleDataset?
Thank you

 

[Marco Kalter]

A direct update statement with a TLOBLocator will be more efficient, because it omits fetching the (huge) record first. But I would not have expected an "out of memory" error for a 100MB BLOB.