kaj,
i believe that oracle does not allow you to query columns of datatype long.
when designing an application in oracle 7.3, that needs to search a column
that contains a large amount of data, i normally use varcha2(2000). if 2000
characters is not enough, oracle8 supports 4000 characters for varchar2, or
you can structure your app with a many varchar2(2000) to one parent entity.
hope the above helps you.
guy r. lipof
--------------------------------------------
o_o [EMAIL PROTECTED]
( ) [EMAIL PROTECTED]
( | | ) -----------------------------------
' " " ` http://www.smartdna.com
--------------------------------------------
----------
>From: Kaj Hejer <[EMAIL PROTECTED]>
>To: Multiple recipients of list <[EMAIL PROTECTED]>
>Subject: Searching in a LONG -> ORA-00932: inconsistent datatypes
>Date: Mon, Mar 15, 1999, 8:49 AM
>
>Hi!
>
>I have a database where one of the tables has an attribute of type LONG.
>
>When I try to search this attribute with a search-component generated by
>the wizard in WOBuilder I get an EOGeneralAdaptorException saying:
>
>ORA-00932: inconsistent datatypes
>
>The attribute is mapped to type String in EOmodeler.
>
>
>Any ideas? Thanks in advance!
>
>
>
>-Kaj :)
