the university where I work just updated their Oracle test database to a new version and now my clob fields don't display in coldfusion. I have code to add to the query to capture the first 4000 characters, but what do I do about the few records that contain more than 4000 characters? We need to resolve this before we upgrade the production database... Have coldfusion developers addressed this issue with the new Oracle upgrade?
When they changed Oracle versions, did you have to create a new data source in ColdFusion Administrator? If so, there is a setting under "Advanced Settings" to enable CLOB support, and that probably didn't get turned on.