comatose and oracle

[bretweinraub]

Anyone out there have success with this lineup?

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.

[bretweinraub]

I got a *mostly* working oracle config w/ Rails 2.0.2.

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

[Thibaut Barrère]

Hi bdw,

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

-- Thibaut

[bretweinraub]

I posted one reply but it never appeared. Trying again.

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