Forum OpenACS Development: Re: 'ORA-00932: inconsistent datatypes' error on Oracle 8.1.7.0.1

Collapse
3: Re: 'ORA-00932: inconsistent datatypes' error on Oracle 8.1.7.0.1 (response to 1)
Posted by Ola Hansson on 06/02/03 09:58 AM
The type on element/curriculum description is "clob", but the datatype I use in plsql *.new is "varchar" - I borrowed this concept from the forums package in order to extend the description from being limited to 4K (if I would've used varchar) up to 32K. See this thread for a little discussion about it: https://openacs.org/forums/message-view?message_id=51571

The initial data model is on CVS HEAD, btw:
http://cvs.openacs.org/cvs/openacs-4/packages/curriculum/sql/oracle/curriculum-element-create.sql?rev=1.1&content-type=text/x-cvsweb-markup

It shouldn't come to me as a surprise that clob is inconsistent with varchar, I suppose ...

You are correct that ce_enabled_elements is a view.

Suggestions?

Collapse
4: Re: 'ORA-00932: inconsistent datatypes' error on Oracle 8.1.7.0.1 (response to 3)
Posted by Sebastiano Pilla on 06/02/03 10:44 AM
Not sure if I understand the question correctly, but I would try to use the DBMS_LOB package, specifically the DBMS_LOB.GETLENGTH and DBMS_LOB.INSTR functions. Documentation can be found on Oracle OTN.