Updating Oracle Clob field

[thomascraig]

I am having some trouble updating an oracle db that has a clob field, this is
the part of the query that is getting the form data:
<cfqueryparam cfsqltype="cf_sql_clob"
value="#trim(form.additional_information_fr)#">

When I dump the form variables it is getting passed over ok, but when I output
the update SQL statement I am getting a '?' next to the field and it inserts a
blank string.

I also tried this: <cfqueryparam cfsqltype="cf_sql_longvarchar"
value="#trim(form.additional_information)#"> which works as long as the data is
less then 4000 charcters, I know there are issues with drivers and have
incorporated the latest driver release from adobe: <a target=_blank
class=ftalternatingbarlinklarge
href="http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=1a3c2ad0">[url]http://w[/url]
ww.adobe.com/cfusion/knowledgebase/index.cfm?id=1a3c2ad0</a>

Still no luck, anyone else encounter issues with Oracle and Clob fields that
could shed some light on the situation for me. I've been searching the web all
day and tried a few different solutions without any success.

[paross1]

Just curious, do you have <b>Enable long text retrieval (CLOB)</b> enabled in your datasource's advanced settings in CF admin?

Phil

[Matrix16]

Which DBMS are you using?

[Matrix16]

This is a codesnippet from and update action where we enter data into a clob
field in Oracle.

<cfif IsDefined("Form.NEWS_STORY") AND #Form.NEWS_STORY# NEQ "">
<cfqueryparam cfsqltype="cf_sql_longvarchar" value="#Form.NEWS_STORY#">
<cfelse>
NULL
</cfif>

Looking at it the query param is the same as yours so i guess this isnt much
help for you.

[thomascraig]

Matrix16,

Yes this method works up to 4000 characters as soon as I go 4001 I get an error.