From: Nicolas Couturier Date: 2007-11-16T18:16:13+09:00 Subject: Re: oci adpater and Oracle Thanks for your answer. But, so far no luck. I added that line connection.execute('alter session set current_schema=scott') Got the first error message : ORA-00942: table or view does not exist: select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT * FROM dc_dossier ) raw_sql_ where rownum <= 1) where raw_rnum_ > 0 (ActiveRecord::StatementInvalid) Tried to add the :database parameter to the connection. No luck. Does someone ahve another idea ? -- Posted via http://www.ruby-forum.com/.