I need to be able to inser/update a long field with up to 5000 characters. I know that this cannot be done with the usual SQL satement because of the 4000 char limit.

I have seen references to direct calls to the oracle OCI. How would I do this in delphi? Or is there another way? I have also read about using CLOB instead of longs and then using the DBMS_CLOB package to put the data in but I don't want to change the field type if I can help it.

Any help gratefully recieved.