Can you modify the TOracleDataset to include a property which would allow the dataset to automatically populate CLOB / BLOB fields with Empty_Clob() / Empty_Blob() even if the TMemoField / TBlobField value is NULL?

Maybe add an "InitializeLobLocators" entry to the OracleDictionary. Default it to false, which follows the current behavior where empty memos produce NULL CLOB entries, but where the true value causes empty memos to produce EMPTY_CLOB() entries.

I have added your enhancement request to the list. I think it will make it into the 3.4 release as it is a useful, and yet easy to implement feature.

------------------
Marco Kalter
Allround Automations