Problem of using LONG datatype in SQL
Date: 1997/07/14
Message-ID: <33C9D43C.6DD0_at_iil.intel.com>#1/1
Hi there,
I'm facing a problem of using LONG datatype in general, in particular
through Developer 2000.
[Quoted] 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 CEST