From: djberg96@... (Daniel Berger)
Date: 2002-03-20T00:00:03+09:00
Subject: Oracle, DBI problems

Hi all,

Ruby 1.6.6, DBI .12, Oracle .2.11

When running scripts as myself, I am able to connect and run queries
fine.  However, when I run them as cron I get this error:

/usr/local/lib/ruby/site_ruby/1.6/DBD/Oracle/Oracle.rb:84:in
`connect': uninitialized constant Object::ORAconn (NameError)
from /usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:507:in `connect'
from /usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:328:in `connect'
from /export/home/djberge/Programming/Ruby/dbiTest.rb:24

Line 84 of Oracle.rb looks like this:

handle = ::ORAconn.logon(user, auth, dbname

So, ORAconn is an external constant, right?  Unfortunately, while I
can find references to ORAconn in other files, I'm having trouble
determining exactly *where* this constant is initialized normally, and
why it's failing to initialize under cron.

Does anyone have any ideas?  BTW, I've already tried setting
environment variables programmatically - that doesn't solve it.  Many
thanks in advance for any help.

Sincerely,

Daniel Berger