If I remember correctly, there are still some BLOB/CLOB issues with CF, but
he'll reach the 4k SQL literal text insert before he has something large
enough to want to use one of those.
At 03:10 PM 1/17/01 -0800, you wrote:
>I may be revealing my ignorance of Oracle here, but doesn't the BLOB (as
>opposed to CLOB) field type solve this problem?
>
>---mark
>
>
>--------------------------------------------------------------
>Mark Warrick
>Phone: (714) 547-5386
>Fax: (714) 972-2181
>Personal Email: [EMAIL PROTECTED]
>Personal URL: http://www.warrick.net
>Business Email: [EMAIL PROTECTED]
>Business URL: http://www.fusioneers.com
>ICQ: 346566
>--------------------------------------------------------------
>
>
> > -----Original Message-----
> > From: Mike Amburn [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, January 17, 2001 9:53 AM
> > To: CF-Talk
> > Subject: Oracle doesn't store large data.... HELP !?!?!
> >
> >
> > we recently migrated our application from SQL7 to Oracle. personally,
> > i'd go back to SQL7 in a heart-beat, but that's not my decision. the
> > biggest problem we have is regarding size of data. we have a simple
> > table that stores variables as name/value pairs.... name=Homer,
> > city=Atlanta, etc. easy enough. however, some have large values. for
> > example, one variable is a comma-delimited list that can reach 1400
> > characters. that's a big list. however, SQL7 had no problem at all
> > storing and retrieving. Oracle seems to be different. for whatever
> > reason, we can update/insert the large value, but we can not select the
> > large value. it gives some weird Oracle error about having too small a
> > buffer. we have tried to set it as varchar2(4000), long, and CLOB, with
> > not success. trying CLOB had a whole set of other errors.
> >
> > then there's the issue that some variables are stored as serialized WDDX
> > structures, which can be really big. Oracle didn't even try to accept
> > that.
> >
> > does anyone have a clue what's going on or how to get oracle to play
> > fair with large values?
> > me + oracle = Sum(desperate + frustrated)
> >
> > -Mike
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
