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? ______________________________________________________________________ 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=coldfusiona 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
