Forum OpenACS Development: Re: 'ORA-00932: inconsistent datatypes' error on Oracle 8.1.7.0.1

I suppose there's at least one cee.description > 4000 bytes (the limit for
varchar2), so Oracle cannot silently convert anymore. That's why you have to
go for LOB functions.

We should consistently use CLOBs in Oracle in fields where we want to allow
for column values > 4000 bytes (that's less characters with multibyte
characters btw). Oracle stores CLOBs pretty efficiently, i. e. the first 4000
bytes go into the datablock of the corresponding row, the overflow bytes go
into a lob segment. On a quick glance, it's how forums does it...so let's do
it like forums. (Err, the second paragraph might be a little off-topic)