From: "F. Senault" <fred@...>
Date: 2007-11-16T18:55:09+09:00
Subject: Re: oci adpater and Oracle

Le 16 novembre � 10:16, Nicolas Couturier a �crit :

> 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 ?

Well, at first, try to connect to the DB with a query tool (using the
same password and user than rails, of course), and execute the query as
given in the logs.  Then, if it doesn't work, try to "decapsulate" it
step by step :

select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT * FROM 
dc_dossier ) raw_sql_ where rownum <= 1) where raw_rnum_ > 0

select raw_sql_.*, rownum raw_rnum_ from (SELECT * FROM dc_dossier)

SELECT * FROM dc_dossier

It may give you a hint of what's wrong (especially the precise Oracle
error).

Fred
-- 
Sleep: what you were doing just before you woke up with keyboard marks
on your face.                                   (James Riden in the SDM)