search for: oci8

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 <--- lib/DBD/OCI8 <--- lib/DBD <--- lib ---> ext ---> ext/oci8 /usr/...

...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 the error message: ***********ERROR MESSAGE*************** bash-3.00$ sudo gem install ruby-oci8 Building native extensions. This could take a while... ERROR: Error installing ruby-oci8: ERROR: Failed to build gem native extension. /opt/cool...

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 = OCI8.new(''user'',''pass'',''ip:port/sid'') oci.exec(''select * from table'') do |record| puts record.join('','') end Pls help me. What''...

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...

Hello. Tired of searching and finding nothing useful. Moving application to laptop for trip. Installed: - Ruby (1.8.6, patchlevel 111) - Rails (2.2.2) - Oracle adapter (1.0.0.9250) - ruby-oci8 (2.0.1) - Oracle 10g Express Edition database.yml: development: adapter: oracle etc... When I start Mongrel (ruby script/server) I get the error above. I''ve looked everywhere I can think of. Any ideas what might be happening? Thanks a lot. Pepe --~--~---------~--~----~------------~-...

Is rails + oci8 + mac os x intel a winning combination? It appears that oci8 might be a issue.

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/...

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 file, I can still connect using the sid name by itself. Did something c...

...grel listening at 0.0.0.0:8000 ** Changing group to xxxxx. ** Changing user to xxxxx. ** Starting Rails with production environment... /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection _adapters/oracle_adapter.rb:536: undefined method `define_a_column'' for class `OCI8::Cursor'' (NameError) from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'' from /usr/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/active_support/dependenc ies.rb:495:in `require'' from /usr/lib/ruby/gems/1.8/gems/activesup...

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 CentO...

Hello, I am wondering what do people use to connect to an oracle DB ? I've been looking for something like php-oci8 RPM package, but no luck so far. I hate to have to rebuilding PHP on my own just to be able to connect to an Oracle database. Thanks for any help RDB

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 Mar 24 12:05:57 EDT 2009 x86_64 x86_64 x...

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/ invido/portal2/pu...

Howdy folks, Has anyone had any luck getting Oracle''s XMLType to play nicely with Rails? According to the docs, it''s just a wrapper around CLOB. However the ruby-oci8 driver throws an exception about user defined types if you try to query a table with an XMLType column. Any pointers would be appreciated. Thanks, -wilig

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...

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/extc...

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''...

Has anyone experienced "hangs" with the WEBrick/OCI8 combination? The sequence of actions I perform to consistently get WEBrick to hang is: 1. start WEBrick 2. list a table form my Oracle 10g DB 3. startup sqlplus and update a few records in the table 4. go back to my browser and reload the table Here none of the chances I made directly to the t...

http://rubyforge.org/tracker/?func=detail&atid=1051&aid=3960&group_id=256 I posted this bug yesterday. Seems to be confirmed, since someone else has the same problem on a different platform (Fedora 4 and Max OS X). So, if you are using Oracle, don''t be in a rush to upgrade to Rails 1.1 unless you have the time to figure this problem out for yourself. -- Lori Olson

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 since I''ve been able to test the connection by running ruby scripts fro...