Hi,
you cannot search in Long fields in Oracle. The way is to get the long fiel=
d
and to process it in WO.
If you familiar with PL/SQL
solution 1 is:
- use a stored procedure to get a 32k String as a result (limited by PL/SQL=
,
a varchar2 or long type in PL/SQL has a max. size of 32k). It is more then
2000/4000 Bytes.
solution 2 may be:
- create a stored procedure with an OUT parameter of type REFCURSOR
- create an cursor which make a simple SELECT of the Long database column
- call the stored procedure explicitly at adaptor level
- get the OUT parameter of the stored procedure as the result (string)
- process the result
Sure, it's difficult to handle thousends of rows of a table with a Long (an=
d
I mean long) database column in WO. Therefore I would use this solution onl=
y
to get a long database field to display it on a page.
> 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 :)
>
>
--------------------------------------------------------------------
webit! Gesellschaft f=FCr neue Medien mbH WWW: www.webit.de
Dipl.-Wirtsch.-Inf. Hagen Malessa (GF) eMail: [EMAIL PROTECTED]
Schnorrstra=DFe 76 Tel.: +49 351 4952064
D-01069 Dresden Fax.: +49 351 4952065
