DODS Oracle Support?

["Luis Azevedo" <lazevedo@xxxxxxxxxxxx>]

Hi to all.

I am migrating a project from PostgreSQL to Oracle 10g ant I need to have
CLOB and BLOB data types in order to substitute the PostgreSQL TEXT and
BYTEA attributes for large data support.

Whilst changing OracleConf.xml values to support doml types such as
LONGVARCHAR (CLOB), LONGVARBINARY(BLOB) does not produces any type of error
generating the data layer, in runtime I get the following error: 

Caused by: com.lutris.dods.builder.generator.query.DataObjectException:
Unknown SQLException:
<SqlQueryExecute><SqlQueryException>(<Replicated>:ORA-00932: inconsistent
datatypes: expected - got BLOB )

Does anyone know how to resolve it?


For what I understand this means that the Oracle Queries produced by the
code generated from DODS is doing some type mismatch with Oracle BLOB. For
instance, in SQLPLUS:

SQL> select * from exampletable where devinf='somestring'
                                      *
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected - got CLOB

This is the same type of error but with CLOB. 

The workaround for SQLPLUS can be something like:

SQL> select * from exampletablewhere
DBMS_LOB.compare(devinf,'somestring',DBMS_LOB.getlength(devinf),1,1) = 0;

Best Regards,

Luis Azevedo