Ruby Oracle Gem

Become a contributor and improve the site yourself.

Ruby oracle gem.

This article delves into some of ruby s capabilities and how these features can be leveraged with oracle database. Note that they must be same with ones used to compile the ruby. The latest version is available for all oracle versions after oracle 10g including oracle instant client. In case anyone else needs to install a legacy version of ruby oci8 on ruby 1 8 7 on mac osx el capitan i had success installing ruby oci8 2 1 2 using the following method.

Although the ruby on rails web development framework has led to increased interest in ruby throughout the software development world ruby has been around for more than 10 years. Gem activerecord oracle enhanced adapter gem ruby oci8 in config database yml add your oracle environment. Note that ruby 1 8 support was dropped in ruby oci8 2 2 0. If you get a problem in the following steps look at platform specific issues and report installation issue.

Configure your rails app. Oci8 is a ruby wrapper written around native c code which does the actual interaction. Use ruby oci8 2 0 6 for oracle 8 or use ruby oci8 2 1 8 for oracle 9i. I think it will also work on other ruby 1 8 7 versions as well ruby oci8 2 2 0 but i haven t checked other versions.

In gemfile add activerecord oracle enhanced adapter and ruby oci8. Ruby oci8 is a ruby interface for oracle database. To download and install ruby with the gems package installer do the following. The latest version is available for all oracle versions after oracle 10g including oracle instant client.

Gem install rails ruby oci8 activerecord oracle enhanced adapter create your rails app. Use ruby oci8 2 1 8 for ruby 1 8. Use ruby oci8 2 1 8 for ruby 1 8. The ruby programming language with rubygems installation package rails 2 3 2 the latest version of rails and the ruby rails oracle database library.

For example you need oracle solaris studio not gcc for ruby compiled by oracle solaris studio. The ruby oci8 driver provides connectivity to oracle versions 8 through 10 via standard oracle client software. There are two pieces of software you ll need in order to use rails on windows xp. Run the following command.

Note that ruby 1 8 support was dropped in ruby oci8 2 2 0. Use ruby oci8 2 0 6 for oracle 8 or use ruby oci8 2 1 8 for oracle 9i. Rubydbi provides a database independent interface for ruby to talk to databases similar to jdbc or odbc. Use oracle as the database for active record gem activerecord oracle enhanced adapter 1 8 0 gem ruby oci8 only for cruby users rails 5 0 oracle enhanced adapter version 1 7 just supports rails 5 0 and does not support rails 4 2 or lower version of rails.