From 242cd0604e6a4fec691004beb950cf4261ba7f3c Mon Sep 17 00:00:00 2001 From: Marcel Molina Date: Wed, 26 Apr 2006 20:43:29 +0000 Subject: Add Oracle support for CLOB inserts. Closes #4748. [schoenm@earthlink.net sandra.metz@duke.edu] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4280 5ecf4fe2-1ee6-0310-87b1-e25e094e27de --- .../lib/active_record/connection_adapters/oracle_adapter.rb | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'activerecord/lib/active_record/connection_adapters') diff --git a/activerecord/lib/active_record/connection_adapters/oracle_adapter.rb b/activerecord/lib/active_record/connection_adapters/oracle_adapter.rb index f12b02fca3..4165809648 100644 --- a/activerecord/lib/active_record/connection_adapters/oracle_adapter.rb +++ b/activerecord/lib/active_record/connection_adapters/oracle_adapter.rb @@ -58,11 +58,11 @@ begin after_save :write_lobs def write_lobs() #:nodoc: if connection.is_a?(ConnectionAdapters::OracleAdapter) - self.class.columns.select { |c| c.type == :binary }.each { |c| + self.class.columns.select { |c| c.sql_type =~ /LOB$/i }.each { |c| value = self[c.name] next if value.nil? || (value == '') lob = connection.select_one( - "SELECT #{ c.name} FROM #{ self.class.table_name } WHERE #{ self.class.primary_key} = #{quote(id)}", + "SELECT #{c.name} FROM #{self.class.table_name} WHERE #{self.class.primary_key} = #{quote(id)}", 'Writable Large Object')[c.name] lob.write value } @@ -210,7 +210,7 @@ begin end def quote(value, column = nil) #:nodoc: - if column && column.type == :binary + if column && column.sql_type =~ /LOB$/i %Q{empty_#{ column.sql_type rescue 'blob' }()} else case value -- cgit v1.2.3