Problem of using LONG datatype in SQL

Hi there,

I'm facing a problem of using LONG datatype in general, in particular through Developer 2000.
I want to run queries based on a LONG field in the where clause, but since this datatype could not be used in the where statement, I cannot run such a query:

        SELECT * FROM table_name WHERE description LIKE '%string%'; where description is a LONG datatype.

Other problem is when I'm trying to run such a statement:

        INSERT INTO tmp_table SELECT * FROM table_name; Once again, when one of table_name fields is a LONG datatype, I got the following error message:

        ORA-00997: illegal use of LONG datatype

I guess I'm not the first one to fase this problem, so if you know of a solution, or at least a workaround, please let me know. I cannot replace this field to a VARCHAR2 type, since it should hold a large amount of charachters, but any other idea will be great.

TIA,
Maoz Received on Mon Jul 14 1997 - 00:00:00 CDT