Oracle “enhanced” ActiveRecord adapter contains useful additional methods for working with new and legacy Oracle databases
from Rails which are extracted from current real projects’ monkey patches of original Oracle adapter.

Installation

sudo gem install activerecord-oracle_enhanced-adapter

Prerequisites

• Works (has been tested) with ActiveRecord version 2.0, 2.1, 2.2 and 2.3 (these are the same as Rails versions)
• Works with Oracle 9i, 10g and 11g. Oracle 8i is not fully supported as some ActiveRecord generated ANSI SQL statements will not work on pre-9i versions.
• Can be used on the following Ruby platforms:

• MRI 1.8.6/1.8.7- requires ruby-oci8 1.x or 2.0 gem (2.0.3 or later recommended) to connect to Oracle
• Ruby/YARV 1.9.1 – requires ruby-oci8 2.0 library to connect to Oracle
  unicode_utils gem is recommended for Unicode aware string upcase and downcase
• JRuby – uses JDBC driver ojdbc14.jar to connect to Oracle (should be in JRUBY_HOME/lib or in PATH)

• Requires ruby-plsql gem to support custom create, update and delete methods (but can be used without ruby-plsql if this functionality is not needed)

Usage description and examples

Troubleshooting

Other links

For questions and feature discussion please use http://groups.google.com/group/oracle-enhanced

Blog posts about oracle-enahnced can be found at http://blog.rayapps.com/category/oracle-enhanced

Bugs and enhancement requests can be reported at http://github.com/rsim/oracle-enhanced/issues