similar to: RoR + oracle + bind vars

I have a table with "expires_on" a DATE field. "Show" and "Destroy" work, but "Edit" errors: /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:150:in `select_hour'' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:149:in `select_hour'' It only happens when

I''m seeing a behavior in Rails that I find very strange. Having worked quite a bit with Oracle with other languages I would always dutifully do ALTER SESSION SET NLS_DATE_FORMAT = <my_date_format> and ensure I use that date format in my application. With Rails I still have not figured out how to execute an ALTER SESSION statement after connecting to the database (I''m using

Hi, My setup is: Ruby 1.8.6 Rails 2.3.5 activerecord-oracle-adapter (1.0.0.9250) I upgraded Rails and the adapter recently and I just went through hell trying to find a problem while inserting a record in a table. Rails was giving me this error: OCIError (ORA-02289: sequence does not exist): stmt.c:539:in oci8lib.so c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:753:in `exec''

Hello, I got the following issue and I do not know how to resolve it: #1. created parent class (AccountExtended) for some my models (lib/classes_lib.rb): class AccountExtended < ActiveRecord::Base def self.findByAccount end end #2. created model Country: require ''lib/classes_lib'' class Country < AccountExtended end #3. and added a test controller what shows

How can I pass the following Oracle 10g variables to my apache? ORACLE_BASE=/u01/oracle ORACLE_HOME=/u01/oracle/10g ORACLE_SID=king LD_LIBRARY_PATH=$ORACLE_HOME/lib LD_LIBRARY_PATH_32=$ORACLE_HOME/lib32 PATH=$PATH:$ORACLE_HOME/bin NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256; export NLS_LANG NLS_DATE_FORMAT=dd-mm-yyyy ; export NLS_DATE_FORMAT export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH

The revised patch submitted on #4748 broke the build, I''m looking to sort out why. Also note that this auto-test email didn''t make it to rails-core because it was too big (every test failed, so the resulting email was huge). I''ll patch my auto-testing script to truncate the email to no larger than a few kb. Michael Schoen wrote: > "marcel" made

the error is : wrong number of arguments (1 for 0) where : active_record/connection_adapters/oracle_adapter.rb:53:in `attributes_with_quotes_pre_oracle'' this method is new, it was an alias in the previous version : alias :attributes_with_quotes_pre_oci :attributes_with_quotes #:nodoc: I replaced the method by the alias of the previous version, and it is working fine. This is

Hi all, Ruby 1.8.4 Rails 1.1 OCI8 0.1.14 I think I''m hitting an issue with ActiveRecord::Base#save and the Oracle adapter. Line 158 in the schedules_controller.rb file is simply: 158: if @schedule.save 159: flash[:notice] = ''Schedule was successfully created.'' 160: redirect_to :action => ''list'' 161: else 162: render :action =>

All, While attempting to use ActiveRecord against a large database, approx. 1700 tables and 4 million rows, I discovered an inefficiency in oci_adapter.rb. The problem seems to be the SQL being generated to lazy-load the columns metadata. "def columns(table_name, name = nil)" method generates the following SQL: select column_name, data_type, data_default, nullable,

EVerything runs ok on my local machine but when i copy my app to our solaris server everything is fine until i try updating/inserting something into the DB. This is the error message : wrong number of arguments (1 for 0) RAILS_ROOT: config/.. Application Trace | Framework Trace | Full Trace

So my automated script caught this issue, though I think my email headers were bad, so rails-core has put the automated email on hold pending "moderation". I''ll fix that issue, and look at the one below as well. -------- Original Message -------- Subject: Rails AR/Oracle Unit Test: [4185] failed Date: Thu, 6 Apr 2006 08:32:04 -0700 From: Michael Schoen

Has anyone encountered this error or know how to correct it? I couldn''t find any Rails-specific info about this on google. Here are the circumstances: /usr/local/bin/ruby --version ruby 1.8.4 (2005-12-24) [i686-linux] /usr/local/bin/rails --version Rails 1.1.6 ## Create mcd app rails mcd -d oracle cd mcd ## Create oracle tablespace & user sqlplus ''/ as

Hi all. Does anybody use Rspec with Oracle? I have RoR app + Oracle DB. I use Rspec 0.9.4. I have installed Rspec plugin and generated spec for model Country. If I use "@countries = Country.new" in my spec I get "ArgumentError in ''Country should be valid'' block not supplied /vendor/plugins/rspec_on_rails/lib/spec/rails/extensions/kernel.rb: 12:in

Long afternoon, but finally got it. Hope this spares you some pain: Installation instructions mainly based on: http://ruby.about.com/od/enterprise/ss/ruby_oracle.htm Install Oracle Instant Client: mkdir C:\oracle cd c:\oracle Get the following files from here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html and unzip them into the c:\oracle\ unzip

Hi everyone, I''m working on a new rails project and have to build it on top of a legacy oracle database. I''m trying to figure out how to get the number value from a NUMBER(1) datatype. So far I''m only getting a "true" value for 1 and "false" for any other number. From the console I can print out my object values and can see that there are number

Hello everyone, I am trying to convince my colleagues to convert to Ruby on Rails, however I am up against the following problem: Ruby on rails seems to be primarily designed a single database doing a small number of queries. While trying to process a webpage that does thousands of sql queries on Oracle, I get the message that I have used up too many cursors. In Java, I can use stmt.close()

Hi People, I had success to do my asterisk to record CDR in a databese MYSQL... Now, I need to do it to record CDR in Oracle... Does Anybody knows how to do this?? Every hints are welcome.... Thank`s all Everton Goularth Uberlandia - MG - Brazil _______________________________________________________ Yahoo! Mail - Sempre a melhor op??o para voc?! Experimente j? e veja as

Hello, i am heaving issue with some program in wine. When i start it Wine System tray window is shown in screen corner and stay there without icon [Image: http://img15.imageshack.us/img15/6674/screenshotas.png ] (http://img15.imageshack.us/i/screenshotas.png/) Software is working fine i am just heaving issue with tray icon. Is there a way to disable Wine System Tray ? Best regards n24

I am trying to use Rails and an Oracle 7 database. I have the following error message: (eval):3:in `__send__'': ORA-12663: Services required by client not available on the server (OCIError) from (eval):3:in `describe'' and the line oracle_adapter,rb:361: (owner, table_name) = @connection.describe(table_name) Do I need this describe line? Can I replace with something else just

Hi, Does anyone know why gem can''t find activerecord-oracle-adapter? C:\>rails --version Rails 2.0.1 C:\>gem install activerecord-oracle-adapter ERROR: While executing gem ... (Gem::GemNotFoundException) Could not find activerecord-oracle-adapter (> 0) in any repository It all started when I tried to run Mongrel on a Win32 box: C:\web\FDS_Server>mongrel_rails start