Yes. Oracle CLOBs can be problematic using Delphi and ADO. I've had success
when inserting data by specifying the datatype as 'ftMemo', but retrieveing
is a different issue and the 'datatype' returned by Oracle doesn't seem to
map to a datatype in ADO.
You might want to consider switching to NCOCI8 (free) for this application.
You can find it here: http://www.yqcomputer.com/