All, Hi, there. Have a bit of a tricky one. Before starting, let me say that I know the real solution is to use CLOBs, but I need to make this work in the meantime. I have to put huge amounts of text into tables whose columns are already defined and whose setup may not be changed. Luckily, I have a bunch of VARCHAR2(4000) columns free. My thought was, cut the text into 4000-character chunks, then put 4000 into each field until you've added all the text.
When I tried it, I got this error: [Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG Column. Now, in the past, I have had trouble with the fact that CFQUERYPARAM seems only to want to bind 2000-character-or-less strings to CF_SQL_VARCHAR, and anything over that up to 4000 characters has to be CF_SQL_LONGVARCHAR. I have code in place to handle that. And I have verified many times that the text I am entering is in fact cut into 4000-character chunks. Still, though, I get the above error. If I enter it straight into the same table using a SQL command client, it fits just fine. I have even cut the chunks down to 2000-characters and switched to only CF_SQL_VARCHAR entry. Still no dice. Any thoughts on handling this? Thanks, Matthieu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184411 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
