search for: ocierror

Hi all, when I execute the command "rake db:schema:dump" i get this error in the db/schema.rb file. ____________________________________________________ # Could not dump table "region" because of following ActiveRecord::StatementInvalid # OCIError: ORA-00918: column ambiguously defined: SELECT lower(i.index_name) as index_name, i.uniqueness, lowe r(c.column_name) as column_name FROM user_indexes i, user_ind_columns c WHERE i.table_name = ''REGION'' AND c.index_name = i.index_name...

...86 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 x86_64 GNU/Linux I have this problem: irb(main):001:0> require ''oci8'' OCIError: OCI Library Initialization Error from env.c:90:in oci8lib.so from /home/iono/lib/ruby/rubygems/custom_require.rb:31:in `require'' from /home/iono/packages/gems/gems/ruby-oci8-2.0.1/lib/oci8.rb:25 from /home/iono/lib/ruby/rubygems/custom_require.rb:36:in `gem_original_require'...

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

...ol, :text t.column :bst, :text t.column :mw, :float t.column :formula, :string t.column :internal_ref, :text t.column :comments, :text end ... ## Create tables rake db:migrate ... fails ... rake aborted! OCIError: ORA-03106: fatal two-task communication protocol error: select lower(table_name) from user_tables ... # Try roll-back to version 0 rake db:migrate VERSION=0 ... fails ... rake aborted! OCIError: ORA-03106: fatal two-task communication protocol error: select lower(table_name) from user_tabl...

Hi all, I wonder how can I solve in RoR the problem of accessing a simple table because the URL http://localhost:3000/customers/show/2.0 is raising an Oracle error OCIError: ORA-01722: invalid number. The reason of this error is because the SELECT statement generated by ActiveRecord tries to invoke the id column as a VARCHAR : "... FROM customers WHERE customers.id = ''2.0'' " How this can be solved? Thank you in advance for your help. G...

...ffset, :limit => items_per_page ) However if I try and add an order... @componentlogs = Componentlog.find(:all, :conditions => [ "cl_compname like ?", @criteria ], :offset => offset, :limit => items_per_page, :order => "cl_spr DESC" ) It goes totally doolally. OCIError: ORA-00907: missing right parenthesis: select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT * FROM componentlog WHERE (cl_compname like ''CAPODIR'') ORDER BY cl_spr DESC ) raw_sql_ where rownum <= 25) where raw_rnum_ > 0 I don''t have much control over...

...eager loading of associations with Oracle. In 2.1 ActiveRecord loads the included table with a big ''IN'' query: ''where association.id in (1, 2, 3, 4...)''. The problem is that Oracle has a hard limit of 1000 values in an IN clause. I get this error: ''OCIError: ORA-01795: maximum number of expressions in a list is 1000 Of course getting 1000 records in one shot is probably too many; you''d want to paginate. But still sometimes you underestimate the size your db will grow too, and a really slow query is better than one that blows up. Has anyone...

...things to insert a data in an Oracle Table, but the Rails compiler never Works! I create this Oracle table: CREATE TABLE "FOO" ( "id" int NOT NULL primary key, "acolumn" VARCHAR(10) NULL ) and when i tried to insert a new row the Rails compiler tell me : OCIError: ORA-00904: invalid column name: INSERT INTO AGO.FOO (acolumn, id) VALUES(''pippolo'', :id) While with MySQL I''ve no problem using the same table!. I tell to Oracle also : CREATE SEQUENCE FOO_SEQ INCREMENT BY 1 START WITH 100 or : CREATE SEQUENCE FOO_sequence START...

...ions => [ "cl_compname like ?", @criteria ], :offset => offset, :limit => items_per_page, :order => "cl_spr DESC" ) in a find_by_sql statement. I cannot use the build in because the adaptor isn''t quite right (OCI8) When I use it I get the following error OCIError: ORA-00907: missing right parenthesis: select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT * FROM componentlog WHERE (cl_compname like ''CAPODIR'') ORDER BY cl_spr DESC ) raw_sql_ where rownum <= 25) where raw_rnum_ > 0 I am not sure how to convert this into a fi...

...t_primary_key "customerno" set_table_name ="TMP.CUSTOMERS" end c = Customer.find(10027566) ============== TMP is the schema name this is the error message: /usr/local/lib/ruby/site_ruby/1.8/oci8.rb:161:in `attach'': ORA-12154: TNS:could not resolve service name (OCIError) from /usr/local/lib/ruby/site_ruby/1.8/oci8.rb:161:in `initialize'' from /usr/local/lib/ruby/site_ruby/1.8/oci8.rb:161:in `do_ocicall'' from /usr/local/lib/ruby/site_ruby/1.8/oci8.rb:161:in `initialize'' from /usr/local/lib/ruby/gems/1.8/gems...

Hi All! Is anyone working with Oracle on Rails? What about testing? I will be very happy if you can help me: 1) When I run rake test:unit it removes all my sequences in test enviroment. And I get an error like "OCIError: ORA-02289: sequence does not exist" But when I run rake db:test:clone_structure I can see all sequences again. Where is a problem? 2) How I can take proper account of triggers? Now I just can''t run some test because this action suppose to drop a data (and I have a trigger on DEL...

...ke your typical run-of-the-mill fixture but it''s that way because I''m trying to work around another issue with the Oracle Ruby driver. It won''t load fixtures without ids and it won''t increment the sequence: admin: name: Admin I get this error: rake aborted! OCIError: ORA-01400: cannot insert NULL into ("XXX_DEV"."GROUPS"."ID"): INSERT INTO groups (name) VALUES (''Research Nurse'') admin: id: 10000 name: Admin When I try to add another record after that fixture I get errors about non-unique keys: >> Gr...

...9. I downloaded the instant client stuff from oracle and copied oci.dll and oraociei10.dll to my windows/system folder (windows XP) I get the error. C:\rb-play>ar_connect_ss.rb env.c:257:in oci8lib.so: ORA-12514: TNS:listener does not currently know of serv ice requested in connect descriptor (OCIError) from c:/ruby/lib/ruby/site_ruby/1.8/oci8.rb:228:in `initialize'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_recor d/connection_adapters/oracle_adapter.rb:585:in `new'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ acti...

...ople. This join is represented using a "contacts" table. I am using a legacy schema so i am forced into using non-standard rails primary keys. I am using the new through relationship in rails 1.1. p=Person.find(1) b=p.company_branches # gives this error: ActiveRecord::StatementInvalid: OCIError: ORA-00904: "CONTACTS"."COMPANY_BRANCH_ ID": invalid identifier: SELECT company_branches.* FROM contacts, company_branch es WHERE (company_branches.branch_id = contacts.company_branch_id AND contacts.p erson_person_id = 1) Notice that "contacts.company_branch_id" d...

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 to get the query to work? Thanks -- Posted via http://www.ruby-forum.com/.

...through_association.rb U activerecord/lib/active_record/associations.rb U activerecord/CHANGELOG Updated to revision 5310. 1) Error: test_load_schema(AAACreateTablesTest): ActiveRecord::StatementInvalid: ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:128:in `log'': OCIError: ORA-00972: identifier is too long: CREATE TABLE lock_with_custom_column_without_defaults (id NUMBER(38) NOT NULL PRIMARY KEY, custom_lock_version NUMBER(38)) ./test/aaa_create_tables_test.rb:18:in `test_load_schema'' ./test/../lib/active_record/connection_adapters/oracle_adapter.r...

Hi, I am trying the following in Ruby using InstantRails 1.7 on WindowsXP Publication.find(:all, :include => [:doc_type, :release_state] ) but I get the error: OCIError: ORA-00904: "DOC_TYPES"."PUBLICATION_ID": invalid identifier: SELECT publications.id AS t0_r0, publications.docid AS t0_r1, publications.doc_type_id AS t0_r2, publications.title AS t0_r3, publications.lang AS t0_r4, publications.keywords AS t0_r5, publications.cvsdir AS t0_r6, p...

...so close, but now when I do: RAILS_ENV=production rake db:migrate --trace I get: AddOpenIdAuthenticationTables: migrating ================================ -- create_table(:open_id_authentication_associations, {:force=>true}) rake aborted! An error has occurred, all later migrations canceled: OCIError: ORA-00972: identifier is too long: CREATE TABLE "OPEN_ID_AUTHENTICATION_ASSOCIATIONS" ("ID" NUMBER NOT NULL PRIMARY KEY, "ISSUED" NUMBER, "LIFETIME" NUMBER, "HANDLE" VARCHAR2, "ASSOC_TYPE" VARCHAR2, "SERVER_URL" BLOB, "SECR...

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 |

...for 10.242.2.10 at 2010-02-24 15:29:08) [GET] Parameters: {"review"=>{"irb_id"=>["35540"]}, "action"=>"create_association", "id"=>"1", "controller"=>"reviews"} ActiveRecord::StatementInvalid (OCIError: ORA-02289: sequence does not exist: SELECT reviews_seq.NEXTVAL id FROM dual): C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.2.3/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:1359:in `log'' C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-oracle_enh...