similar to: OCIError: ORA-00918: column ambiguously defined

Hi all, I''m using Rails/Mysql as development platform. the production server is under Rails/Oracle. Right now, i''m trying to install my application under the production server, the connection to orcale is fine via Rails, but i have a weird problem. example : here is a extract from my db scheme : Table User :_____________ id_user | first_name |

i''m a rails nuby so i don''t know where to fix this in the activerecord module.... there is no such column in the sys.view.user_constraints. SELECT uc.index_name FROM user_constraints uc WHERE uc.constraint_type = ''P'' this prevents me from doing a rake test:functionals ...as in below.... C:\railsspace>c:\ruby186\ruby\bin\ruby c:\ruby186\ruby\bin\rake

in lib/active_record/connection_adapters/abstract/schema_statements.rb there is a missing quote_table_name in line 286 (def remove_index): execute "DROP INDEX #{quote_column_name(index_name(table_name, options))} ON #{table_name}" so my "keys" table can get an index with "add_index" but can''t remove it (without tweaking) replacing it to execute

The upgrade to Rails 1.1 hurt my ability to run tests because it generated the following MySQL error: Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''key ON config (key)'' at line 1: CREATE UNIQUE INDEX key ON config (key) I have a table called `config` with a column

We''re trying to deploy our system on a separate server and have run into nothing but trouble; specifically I get the error mentioned in the subject. The username/password combo is correct (I verified it via SQL+). Manually running script/server works fine in production or development mode. Heck, running script/console also works fine. It''s just that when it automatically

Hi, I''ve implemented synonym searching in my rails application but have an idea I''d like to implement but can''t figure out how to do. The idea is that I''d like to give the end user the choice on whether to search for the synonym of a word or not. Preferably by extending the query language to parse a construct similar to ''%word1'' and

Hi all, I have some problems inserting data into a legacy table. the key field of this table is a field named CIN which is a varchar(15). when I try insert into this table using a form (generated by the scaffold generator) I get this Error : _____________________________________________________________________ undefined method `CIN_before_type_cast'' for #<Candidat:0x370d8c8> |

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

Hi, When attempting to restore to LINUX RHEL5 - OCFS2 filesystem received the following error during RMAN restore for nearly all of the datafiles attempted to restore with exception of a couple of smaller datafiles which were smaller < 2GB. ORA-19870: error reading backup piece /db/dumps/TR1_1/rmanbackup/TR1_88_1 ORA-19502: write error on file "/db/devices/db1/PR2/pr2_1/pr2.data1",

Hello, folks. I am having a problem to connect the Oracle using an alias in BDE under WINE. I did install the Oracle Client and the BDE under WINE and both working perfectly. However, when I create an Oracle alias in BDE, I cannot to test the connection, obtaining this error: "ORA-01012: not logged on" Any suggestion ??? Thanks, Robson Sampaio.

Anyone have experience using dtrace to analyze ORA-3113 errors? Sorry for the vagueness of this question, just figured i would see if there were any hits on this initial post. thanks -- This message posted from opensolaris.org

We are running 2-node RAC on RedHat Linux-86 (32-bit) the following was done on (4/10/2005) 1. upgrade OS to update 4 (kernel-smp-2.4.21-27.0.2.EL) 2. upgrade OCFS 1.0.12 to ocfs-2.4.21-EL-smp-1.0.14-1 3. upgrade from 9.2.0.5 to 9.2.0.6 (IN 2-Node RAC) 4. change defualt temporary tablespace to regular one (Rac bug fix) 5. Enable aysnc mode by applying patch 3208258_9206 ** Patch 4153303 applied on

Hi: I'm not sure if this is the right place to post. I've just joined some of these lists following OOW 2003. I had a cluster db working sporadically, but now it won't start after upgrading my oracm from 9.2.0.1.0.31 to 9.2.0.2.0.41 on both nodes. node1 RH 7.3 kernel 2.4.20-rc2-orafw oracm 9.2.0.2.0.41 oracle 9.2.0.2.0 OCFS-1.0-up node2 RH 8.0 kernel 2.4.20-rc2-orafw oracm

Hello Ruby please i need your help when i run api i get this error . *ORA-30678: too many open connections* ** * * *ORA-06512: at "SYS.UTL_TCP", line 28* * * *ORA-06512: at "SYS.UTL_TCP", line 257* * * *ORA-06512: at "SYS.UTL_SMTP", line 116* * * *ORA-06512: at "SYS.UTL_SMTP", line 139* * * *ORA-06512: at "APPS.SEND_MAIL", line 12* * *

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 all, Windows XP Oracle 10g client OCI8 0.1.16 Ruby 1.8.5 Rails 1.1.6 I''m hitting weird behavior with the Oracle adapter and a find_by_sql call on a multi-table join. The SQL looks like this: SELECT DISTINCT e1.ip_address, loc.street, loc.city, loc.state FROM schema.net_element ne, schema.equipment e1, schema.equipment e2, schema.building b, schema.cust_loc cl, schema.location

Hi all!! I would like to know if anyone has experienced this behaviour with ROracle package. I'm attaching information to reproduce the issue. Bug maybe? Thank you very much for your attention. Ramon. ################################################################## ################################################################## oraExecStatement BUG : RS-DBI driver: (ORA-02005:

Hi, I have ferret working fine on my Dev machine using a relative index path as follows: USER_INDEX = Index::Index.new(:path => "indexes/user", :key => ''id'', :auto_flush => true) And the indexes/user directory is located directly off the root of my project tree. But when I migrate this same code to my shared TextDrive account, Ferret cannot find the index

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,

Hi I am a new to ROR and learning this framework from various tutorials. I have my new application and had the rails generate scaffold get going but after this when I first ran the rake db:migrate I got this ERROR! ORA-12514: TNS:listener d oes not currently know of service requested in connect descriptor (OCIError) I''m using database which is on a server and have used the tnsnames.ora