CLOB handling in ActiveRecord 1.14.2


#1

We recently switched to Rails 1.1.2, which includes the latest version
of ActiveRecord.

This version seems to have introduced an error with the handling of
non-binary large objects.

The OCI adapter in 1.13.2 seemed to have treated CLOB and BLOB
identically. The new Oracle adapter distinguishes between the two types
and gives CLOB a type of :text, where as BLOB are :binary

When it comes to insert or updating, only the binary fields are handled
in the way that large objects should be handled (an after save
callback).

It is trying to insert our CLOB as part of a large insert statement and
Oracle is not happy.

We made a temporary base change to fix this, by making CLOBs :binary.

Has anyone else experienced this or know of an upcoming patch?

Much Thanks…

Richard


#2

Richard Adrian wrote:

The OCI adapter in 1.13.2 seemed to have treated CLOB and BLOB
identically. The new Oracle adapter distinguishes between the two types
and gives CLOB a type of :text, where as BLOB are :binary

Has anyone else experienced this or know of an upcoming patch?

I’ve posted a patch, waiting to be accepted:

http://dev.rubyonrails.org/ticket/4748