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