[EMAIL PROTECTED] wrote in [EMAIL PROTECTED]:">news:[EMAIL PROTECTED]: Try using CFINSERT OR CFUPDATE Other wise have your DBA create a stored procedure to divide the strings into 4k segements and update each segment seperately.
Won PS CFUPDATE AND CFINSERT is slow > 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
