How do I display data from an Oracle clob field in the new version of Oracle?

Question

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?

Carl Von Stetten · Answer

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.

-Carl V.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded