CF 7 Standard + Oracle JDBC drivers + CLOB fields

[Mustache2]

Hello all,

I?m trying to update/select CLOB fields in an Oracle 8.1.7 database with CF 7
Standard Edition. I?m using the Oracle JDBC drivers available at Oracle
WebSite. I?ve even set the CLOB and BLOB options in the data source
configuration.

When I Insert or Update large strings into the Database I get the error:
"string literal too long" even though the fields are set to CLOB. When I do a
select I get nothing in return.

I did some searching and found that CF 7 Enterprise Edtiion cames with native
Oracle support. But I can?t afford to upgrade to Enterprise.

So how do I work with CF 7 Standard + Oracle JDBC drivers + CLOB fields ?

Thx.

Pretty far off from when you posted, but use <cfqueryparam type="cf_sql_varchar2" value="#myVar#"> and you should be good to go.

[annubachu]

Hi All,

We are upgrading from CF5 to CF7 Enterprise edition in the coming months. I
was doing research into the known issues with the upgrade and came across this
issue with CLOBS.

We use CLOBS and are currently on Oracle 8.1.7.3. I was wondering if we will
have any prblem using CLOBS with MX7. Any insight is much appreciated.

Thanks.