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
