Hello, all.
I experience following problem with ColdFusion MX 7.0: IBM DB2 7.2 FixPack 10
(for Windows) does not accept character data for <CFPROCPARAM> tag with length
more than 8175 bytes (database is in UTF-8). It could be OK (according to
[url]http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0601poon2/[/url]),
but... If I use CF_CLOB as data type for parameter of procedure -- the same
thing occurs.
Here is the code:

<CFSET szTestValue = "">
<CFLOOP FROM="1" TO="8176" index="c1">
<CFSET szTestValue = szTestValue&"!">
</CFLOOP>

<CFTRY>
<CFSTOREDPROC procedure="sp_test_21" datasource="DB_USER" username="admin"
password="admin">
<CFPROCPARAM type="In" cfsqltype="CF_SQL_LONGVARCHAR" maxlength="32000"
value="#szTestValue#" dbvarname="param1">
</CFSTOREDPROC>
<CFDUMP var="ok">
<CFCATCH>
<CFDUMP var="#cfcatch#">
</CFCATCH>
</CFTRY>
Error is: CLI0143E Invalid precision value. SQLSTATE=HY104.

If I set length of szTestValue to 8175, then I have error: SQL1109N The
specified DLL "sp_test_21" could not be loaded (it is ok, because I do not have
this procedure, this is just a test).

So the question is: how to get rid of this problem? Can I use CLOB for
transfer of data to stored procedure? For ColdFusion 5.0 we have no problem
with this issue. Please, give any suggestions.
Database is registered as ODBC socket data source. I set corresponding
parameters in data source profile in CF MX Administrator, but error this exists.