Yeah, having to do an insert followed by an update is no biggie, but I've hit a snag -- the CLOB update works when the amount of data is comparatively small. When there's a large amount of data (haven't found the exact boundary, but 112Kb failed), the update (interestingly) doesn't throw an error, but there's no data in the CLOB field. Which kindof defeats the purpose of using a CLOB. Poops.
sounds like it might be silly driver code - there is another package besides dbms_lob which can handle LOBs up to 32K - by any chance is it at 32K that problems occur (can't remember the name of the other package btw, it's been a few years since I've use Oracle directly, ie. not via ODBC).
Seeing as MM are saying that the Oracle JDBC drivers are not going to work, why don't you give some updated ODBC drivers from Oracle a lash on the off-chance they'll work - you'd never know. If that still doesn't work and you've got somebody in there who knows their way around Oracle PL/SQL or JDBC programming, you could either write some stored procedures or even maybe some Java CFXs to handle your CLOB data. Having said that, it might actually work out cheaper to source decent JDBC drivers.
> There is a dbms_lob package for PL/SQL which can be used to handle LOBs, > but I've never seen it used with a reference id like that returned by your > drivers - there are functions which accept the column name as arguments.
Well, the other developer here has very kindly just written a function that takes chunks of data and writes them to an in-memory table, and then converts those chunks back into a CLOB that's stored in the reports table. He's currently writing a function to do the reverse, which I'll concatenate back into a string in CF.
It's a crazy plan, but...
Oh God, I'm getting horrifying flashbacks with all this talk of CLOB problems ;), y'know, one time I got so fed up with all this rubbish I just used flat text files where I needed to store large blocks of character data. That site is still running and the client is still happy with it :)
Mark
-- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
