similar to: using Oracle bind vars in Rails

I have created two new files /export/home/bin/test_temp.delete_me and /export/home/webmstr/nflmg/scripts/regional/misc_loaders/test_temp.delete_me on the rsync server and am using the following exclude file. + bin/ + nflmg/scripts/regional/misc_loaders/ - core - *.bz2 - *.orig - *.BAK - *.bak - *.old - *.csv - *.tmp - *.4chart - *.xls - *.difftrx - *.difftra - *.rawbad - *.trx.all - *.tar.* -

I had previously gotten Maik Schmidt''s patch for Oracle working, but now am trying the official Oracle adapter with the latest Rails. I''ve been trying to get the OCI8 connector to install under OS X, but get the following error. Has anyone gotten it working? ---- [waterdog:~/Desktop/ruby-oci8-0.1.9] stmpjmpr% ruby setup.rb config ---> lib ---> lib/DBD ---> lib/DBD/OCI8

I am attempting to build php with oracle oci8 support. I've installed the oracle installclient basic and devel rpms. When kicking off the srpm buid I am using the following... rpmbuild --with oci8 --rebuild php-4.3.9-3.8.src.rpm While on an FC 4 box this works and I end up with a php-oci8 pkg that is fully functional. However on CentOS 4.1 the build isn't actually building with oci8

I''m trying to get ActiveRecord working with an Oracle DB over the instant client. On a 32bit machine, I can require ''oci8'': Linux xxx.xxx.xxx.xxx 2.6.9-78.0.17.ELsmp #1 SMP Thu Mar 5 04:52:17 EST 2009 i686 i686 i386 GNU/Linux irb(main):001:0> require ''oci8'' => true However, on a 64bit machine: Linux xxx.xxx.xxx.xxx 2.6.18-128.1.6.el5 #1 SMP Tue

All of a sudden, on three different systems, the "server_ip_address/sid_name" syntax in database.yml has stopped working for me. I can''t even do a OCI8.new(blah blah blah) statement from an IRB shell. I get "ORA-12541: TNS:no listener", or some variant, depending on how I phrase it. On systems where I have a real deal client installed, and OCI can find the tnsnames

Hi, Environment: Solaris 10, Orale 10g, Apache 2.2, Ruby 1.8.4, Rails 1.2.3, Ruby OCI8 1.0.0-rc2 As soon as I compiled and installed the Ruby/OCI8 interface, I got the following error from my application: ========================= [notice] mod_fcgid: call /export/home/invido/invido/portal2/public/ dispatch.fcgi with wrapper /usr/local/bin/ruby /export/home/invido/

Here''s a solution to the OCI8 problem shown below (change /usr/local/oracle to your site''s oracle): If this happens when you are running scripts at the shell prompt: export LD_LIBRARY_PATH=/usr/local/oracle/lib If this happens in your apache error_log, add to httpd.conf: SetEnv LD_LIBRARY_PATH /usr/local/oracle/lib Kevin Kleinfelter If it''s not documented,

I feel stupid having to ask this, but I haven''t found an answer. I installed ruby-oci8 in order to load data from an oracle db into postgres (part of a jsp to rails conversion). In order to run my ruby script I know I need to set ORACLE_HOME and LD_LIBRARY_PATH environment variables to get it to work (and it does work). I''ve tried setting ENV[''ORACLE_HOME'']

Hi, I am having a terrible time installing Instant Client to connect my Mac and an Oracle db. I am using the following instructions: http://www.foliosus.com/2007/11/19/connecting-ruby-on-rails-to-oracle-on-an-intel-mac-in-leopard-mac-osx-105/?css=Banksia All goes seemingly well until the Compile the ruby-oci8 library section. ruby setup.rb config returns the following error message:

My company''s System-admin installed Ruby and Gems (using Sun Coolstack package) and I have sudo access to ruby, gem etc. Now I need to get my app to talk to oracle db (through network). From what I understand, it requires three steps: Step 1: Install oracle instant client ( I installed it in my ~/oracle/ instantclient_11_1) Step2: Install OCI8 libraries (this is where I am stuck). Here is

I am attempting to connect to ORACLE11g however i am getting the following error: "OCI Library Initialization Error" IT always errors on OCIENV.init(). I cant see anything wrong on the ENV configurations. Has anyone had this problem, or any suggestions on where i should look for anwers? I am using the following gems: ruby-oci8 (1.0.4) activerecord-oracle-adapter (1.0.0.9250)

hi I have the latest rails version and would like to connect to an Oracle 9 database: this is my code: ========= ActiveRecord::Base.establish_connection( :adapter => "oci", :host => "host", :username => "user", :port => 1888, :password => "passwd", :database => "tmp1" ) class

Hi folks, Does anyone know how to install the OCI8 ruby interface on Debian64 without having to install Oracle? My understanding, from experience with Debian i386, is that you need Oracle (specifically the SQLPlus) installed to be able to compile OCI8. Since my new dev machine is AMD64 running Debian, I''m stuck. My rails applications need to connect to a remote Oracle 10g, but cannot

With Mongrel 0.3.18, I have not seen a single one of the hangs that I have been grousing about for the past N weeks. Thanks MenTaLguY and Zed! Q: Mongrel loads fastthread, Mongrel loads Rails, Rails loads OCI8, OCI8 requires ''thread''. That means OCI8 is using fastthread too, right? Steve

Hello, I''m trying to run rails on a Solaris 10 box with Ruby/OCI8, but I''m getting the following errors when trying to start up. # script/server => Booting WEBrick... /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/commands/servers/ webrick.rb:49:in `[]='': failed to allocate memory (NoMemoryError) from /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/

I''m trying to build the ruby-oci8 with the Oracle Instant Client on OS X. The Instant Client works, and the make seems to be ok with it up until OCIInitialize(). Anybody got this to work? [relevant output] /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/bin/ruby / Users/dmholmes/Desktop/ruby-oci8-1.0.0-rc2/ext/oci8/extconf.rb checking for load library path...

Hi, I''m having problems running my rails application in the following setup Unix/Apache/FastCgi/Oracle10g. I had my app running quite happy until I installed the OCI8 driver. When I try to load the app I get in the apache logs the famous "undefined method ''define_a_column'' for class OCI8:Cursor (NameError)" I think the problem is with the fastcgi set up

Hello folks. I''m new in Ruby also ROR. I installed oracle intant client and test it it works fine. Now I wanna connect to oracle db. But its got some error. like this *custom_require.rb:36:in `require'': cannot load such file -- oci8 (LoadError)* my code is here. require ''oci8'' oci =

Can anyone help me with the uninitialized class variable @@env in OCI8 error raised in my app\views\xxxx index.html.erb file Thanks in advance Below is the code and the result of bundle show. I am using Windows 7 <h1>Listing comics</h1> <table> <tr> <th>Title</th> <th>Issue</th> <th>Publisher</th>

Hi, After a few days of struggling, I was able to run this command successfully. ruby -r oci8 -e "OCI8.new(''xxx_dba'', ''xxx'', ''//xxxx:1521/ xxxxx.xxx.org'').exec(''SELECT 1 from dual'') {|r| puts r.join}" I got "1.0" as output and I got my prompt back. So, I went back to the RoR app that I am working on,