> Please note -- this is an open source project. We try and
> address what we can in a timely fashion but on the whole our
> clients have first dibs on our time.
I know it takes a lot to keep an open source project like this growing,
so I know I'm not alone in my appreciation of your hard work. FarCry is
a great product.
> Well you could tell Oracle to increase the size of the field.
>
> If someone could confirm that it's simply the size allocated
> during the running of the creation scripts then we can easily
> fix the problem by just modding the creation scripts.
Our Oracle DBA is out this week so I'm trying to hack through this issue
with the little Oracle experience I have. However, the more I
investigate this problem the more I'm thinking it is a driver issue.
Here is what I have so far...
I am using Oracle 9i, CFMX 6.1 Standard, and the Oracle Thin Driver from
the Oracle website (version 9.2.0.3). In all of the following queries
#clobstring# is a string longer than 4000 characters (4001 characters
for these tests).
The following query throws this error, ORA-01704: string literal too
long.
<cfquery name="updateClob" datasource="farcry_fbhc">
UPDATE
FARCRY_FBHC.DMHTML
SET
BODY = '#clobstring#'
WHERE
OBJECTID = 'B096EC8D-E0B8-16B3-5AB4A96D921C7031'
</cfquery>
The following query generates this error, ORA-17070 Data size bigger
than max size for this type: 4002
<cfquery name="updateClob" datasource="farcry_fbhc">
UPDATE
FARCRY_FBHC.DMHTML
SET
BODY = <cfqueryparam value="#clobstring#"
cfsqltype="CF_SQL_LONGVARCHAR"/>
WHERE
OBJECTID = <cfqueryparam
value="B096EC8D-E0B8-16B3-5AB4A96D921C7031" cfsqltype="CF_SQL_VARCHAR"/>
</cfquery>
The following query does not throw an error, but it does not insert the
#clobstring# and seems to clear the column value if it contains
anything.
<cfquery name="updateClob" datasource="farcry_fbhc">
UPDATE
FARCRY_FBHC.DMHTML
SET
BODY = <cfqueryparam value="#clobstring#"
cfsqltype="CF_SQL_CLOB"/>
WHERE
OBJECTID = <cfqueryparam
value="B096EC8D-E0B8-16B3-5AB4A96D921C7031" cfsqltype="CF_SQL_VARCHAR"/>
</cfquery>
I'll keep everyone posted as I find out more.
---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
