Re: ORA-00932 inconsistent datatypes with CLOB

2006-07-31 Thread Armin Waibel
Hi Steve, [EMAIL PROTECTED] wrote: ... As an aside, it sure would be nice to be able to add new Platform implementations without having to put them into org.apache.ojb.broker.platforms. A simple solution would be something like this (in PlatformFactory): I agree with you. A more

Re: ORA-00932 inconsistent datatypes with CLOB

2006-07-28 Thread Dennis Bekkering
Hello Steve, What does your criteria code look like? I have the same problem when applying like operation on a CLOB. I therefore changed the fieldtype to varchar2(4000). Cheers, Dennis

Re: ORA-00932 inconsistent datatypes with CLOB

2006-07-28 Thread Armin Waibel
:327) regards, Armin [EMAIL PROTECTED] wrote: I am using OJB 1.0.4, Persistence Broker, Oracle 10g, Oracle Text. I have a query which is using the Oracle Text contains() function to search in a CLOB. It is throwing ORA-00932: inconsistent datatypes: expected - got CLOB. If I replace the ?'s

Re: ORA-00932 inconsistent datatypes with CLOB

2006-07-28 Thread Steve_Clark
@db.apache.org To OJB Users List ojb-user@db.apache.org cc Subject Re: ORA-00932 inconsistent datatypes with CLOB Hi Steve, do you use a modified version of JdbcAccessImpl? The stack trace show line 327 in method 'executeQuery' as causer but this doesn't match with 1.0.4 version of this class

ORA-00932 inconsistent datatypes with CLOB

2006-07-27 Thread Steve_Clark
I am using OJB 1.0.4, Persistence Broker, Oracle 10g, Oracle Text. I have a query which is using the Oracle Text contains() function to search in a CLOB. It is throwing ORA-00932: inconsistent datatypes: expected - got CLOB. If I replace the ?'s with appropriate values and do