I was aware that the long datatype is no longer supported but wasn't sure if the odbc driver i'm using supports clobs whereas it does support longs.
There seems to be a huge performance difference between a varchar2(4000 chars ?) and a long (2 gig storage ?) and I can only imagine that this will increase if I manage to get the code working with a clob.
I'm surprised that I have to jump from a 4000 character-length data type to a clob with no inbetween data type available.