• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

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

New Here ,
Jul 01, 2014 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

257

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
community guidelines
Guide ,
Jul 01, 2014 Jul 01, 2014

Copy link to clipboard

Copied

LATEST

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.

Votes

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
community guidelines
Resources
Documentation