> 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)
This might be a stupid question, but did you configure the datasource to
allow long text support in the CF Administrator?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
