Right out of the gate I get a

OCIError: ORA-00932: inconsistent datatypes: expected - got CLOB:
select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT * FROM
comatose_pages WHERE (full_path = '') ) raw_sql_ where rownum <= 1)
where raw_rnum_ > 0

When trying to render the root page.  Monkeying the database to change
full_path to a varchar2(4000) makes this error go away; but I get
other errors down the road.

Just thought I ping the group to see if this rings any bells.

I still had to change the type of full_path to varchar2.

It appears that the problem is with active record; the full_path = ''
section
of the where clause is not valid for Oracle SQL.

I didn't do this via db:migrate; so I had to alter the generated
schema.rb.

Everything worked for me at this point with the exception of the home
page; which
I was able to make function by going directly into the database and
changing
the full_path into something other than ''.

-bdw

On May 5, 6:40 pm, bretweinraub <bretweinr...@gmail.com> wrote:

could it be related to this issue (on mysql this time) :
http://code.google.com/p/comatose-plugin/issues/detail?id=31 ?

-- Thibaut

I don't think it is related to below, because I was able to fix the
problem
by altering the database schema and changing full_text field to a
varchar.

I can  also make the original ActiveRecord generated SQL work by
wrapping
the full_path field  in the Oracle 'TO_CHAR' function.  So from my
perspective
this is some issue with ActiveRecord and Oracle CLOB fields.

Thanks,
Bret

On May 6, 9:37 am, Thibaut Barrère <thibaut.barr...@gmail.com> wrote: