Skip to main content
N
novie68
Participant
November 4, 2010
Question

Upgrade from 10g to 11g - can't querry clob data type

  • November 4, 2010
  • 1 reply
  • 796 views

We have Coldfusion 8. We

have upgraded our development environment to Oracle 11g.

Now we are receiving through our application. We searched to see if we need to update the driver, can't find driver for 11g.

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][Oracle JDBC Driver]No more data available to read.

The error occurred in E:\Collab\iweb\webapps\admin\Test\drivertest.cfm: line 1

1 : <cfquery name="getTXT" datasource="prod">

2 :     select

3 :            a.*

SQL

   select a.* from pubtext a where a.pubtext_program ='1ART' and a.pubtext_seqno = ( select max(z.pubtext_seqno) from pubtext z where z.pubtext_program = a.pubtext_program and z.pubtext_term_code_eff <= '201110' )

DATASOURCE

  prod

Resources:

    This topic has been closed for replies.

    1 reply

    J
    JR__Bob__Dobbs
    Inspiring
    November 5, 2010

    I suspect that you will need to do two things.

    1. Get a JDBC driver for 11g and configure it as a data source option in CF.

    2. Enable CLOB

    http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=datasources_ADV_MJS_15.html#1277913

    Disclaimer: I am not an Oracle expert.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices