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

Report · Nov 04, 2010

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:

Report · Nov 05, 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

Disclaimer: I am not an Oracle expert.