From: Brian Candler <B.Candler@...>
Date: 2003-02-15T01:11:40+09:00
Subject: Oracle, ruby-oci8 and gcc

Just FYI - I remember someone was asking about using Ruby with Oracle 9i
recently (although I've been unable to find the post). Well, I have just had
to do this myself :-)

The driver in RAA is "ruby-oci8" but I had some trouble compiling this with
gcc. It turned out that it was trying to use a load of Solaris cc-specific
flags, but you can work around it like this:

--- ruby-oci8-0.1.1.orig/src/oraconf.rb Sat Feb  1 13:57:15 2003
+++ ruby-oci8-0.1.1/src/oraconf.rb      Fri Feb 14 15:15:32 2003
@@ -185,7 +185,7 @@
          print("Running make for $ORACLE_HOME/rdbms/demo/demo_rdbms.mk ...")
          STDOUT.flush
 
-         command = "|make -f #{@oracle_home}/rdbms/demo/demo_rdbms.mk build\
+         command = "|make KPIC_OPTION= NOKPIC_CCFLAGS= -f #{@oracle_home}/rdbms/demo/demo_rdbms.mk build\
  CC='echo MARKER' EXE=/dev/null ECHODO=echo ECHO=echo\
  GENCLNTSH='echo genclntsh'"
          marker = /^\s*MARKER/                  

It now compiles fine, and passes all tests but one (and that seems to be
just the difference between a 4 second and 5 second timeout)

I also got the 'experimental' DBD to work, just need to copy it into the
right place (assuming you have ruby-dbi already installed of course)

# mkdir -p /usr/local/lib/ruby/site_ruby/1.6/DBD/OCI8
# cp src/lib/DBD/OCI8/OCI8.rb /usr/local/lib/ruby/site_ruby/1.6/DBD/OCI8/

Regards,

Brian.