Geek Answers Handbook

Retreving long text (CLOB) using CFQuery

I use CFQueryto extract CLOB fields from an Oracle database. If the CLOB file contains data less than ~ 8000, then I can see the received value (o / p), however, if the value in the size of the CLOB field is more than 8000 characters, then it does not receive the value. in <cfdump>I see a query received as an "empty string", although this value exists in Oracle DB.

I am using the Oracle driver in the CFadim console enabled "Enable long text search (CLOB)". and “Enable binary large object search (BLOB).” set the values ​​of “Long Text Buffer (chr)” and “Blob Buffer (bytes)” to 6400000

any suggestions for getting the full text?

+5
source share
2 answers

Have you enabled CLOB fields in your data source configuration? If you do not,

  • Contact your coldfusion administrator.
  • select data sources
  • edit your data source
  • click on advanced options
  • check "enable clob"
  • save data source

You do not need to restart CF for this.

+9
source

I don’t know if you find a solution to the problem, but for me it is a problem with the driver: then you need to update the jdbc driver. Look at this Technot Updated JDBC DataDirect Drivers (version 3.4)

0
source

More articles:


All Articles