Make sure "Enable retrieval of long text" is checked for your datasource. You have to use native drivers (CLOBs don't work with ODBC). You have to use <cfqueryparam cfsqltype="CF_SQL_LONGVARCHAR" value="more than 4 k"> in your regular inserts.
Should work, I've done it multiple times. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: dinsdag 19 februari 2002 16:37 To: CF-Talk Subject: Oracle CLOBS OK, I'm posting this for a co-worker... He's trying to convert an existing Access DB to an Oracle/CF solution. He's having trouble inserting large amounts of data into Oracle. Here's his complaint: I need to use the CLOB because it can hold 4gb of data and the next largest one is a varchar which holds 4K. My data is sometimes over 100K. I can get the code to work as long as I don't have data > 4k after that it fails. I have tried a regular insert, I have tried an insert via stored procedure, I have tried an insert via stored procedure with cfstoredproc tag. Nothing works. Our production box is Win2K/CF4.5 Pro. We've tried/developed this on the single license version of CF that comes with studio 5. I've searched through the archives for some help from the list, and we've tried the following things: 1. We tried using "CF_SQL_CLOB" with the CFPROCPARAM tag, and get the "CF_SQL_CLOB" is not a known CFSQLTYPE error. When we use any other sqltype, we get some other error. 2. We've tried ODBC drivers, Native Drivers, we've enabled long text. Still nothing. Any ideas out there? ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
