ORA-00904 EMPTY_NCLOB error on creation of entry

[Eli Bildirici]

Hi Raymonds-
Thanks for replying back at the Oracle forum. I posed the question to
Kubo Takehiro, who suggested this fix:
--
It may be fixed by changing line 493 in oracle_enhanced_adapter.rb as
follows:
from: %Q{empty_#{ column.sql_type.downcase rescue 'blob' }()}
to: %Q{empty_#{ column.sql_type.downcase[-4,4] rescue 'blob' }()}
--
This fix allows editing of entries, and creation of entries as long as
nothing is entered in the field that is an NCLOB, but not creation of
a new entry with something in the NCLOB field, which still fails with
the 904 error. I know you said this would be fixed in the next version
of the adapter, but if you can give some similar quick-and-dirty fix
in the interim, that would be super (unless this new adapter is coming
out within the next few days).

-eli

--
You received this message because you are subscribed to the Google Groups "Oracle enhanced adapter for ActiveRecord" group.
To post to this group, send email to oracle-...@googlegroups.com.
To unsubscribe from this group, send email to oracle-enhanc...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/oracle-enhanced?hl=en.