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
