Highlighted

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

New Here ,
Jul 01, 2014

Copy link to clipboard

Copied

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?

Views

208

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

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

New Here ,
Jul 01, 2014

Copy link to clipboard

Copied

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?

Views

209

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jul 01, 2014 0
Most Valuable Participant ,
Jul 01, 2014

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 01, 2014 0