Query a LONG column ?? possible ??

[ggnanaraj]

A table has a column of datatype LONG. We are unable to query the table with this column in the WHERE clause.

Any way to do this ? Is this possible.

Thanks & Regards.

[ggnanaraj]

If it is not possible to query a table based on a LONG (datatype) column, can we change it to VARCHAR and load it with data from this LONG column ??

Thanks.

[ggnanaraj]

Found the solution !!

It is not possible to change a long to a varchar using the ALTER TABLE command. Instead add a new column as varchar, and select the long into a PL/SQL variable, then insert into the varchar column.

create or replace procedure covet is
cursor c1 is
select rowid,
from ;
begin
for c2 in c1 loop
update
set =
where rowid = c1.rowid;
end loop;
end;

Cheers.