I have a clustered table(Index cluster) which contains a LONG column. But this column is not part of cluster key. Problem is when I do select on this particular LONMG column it is returning null rows. But in the creation of cluster and insertion there are no errors.

Length of the LONG column is also very less.

Also in the same sql session if I update the LONG column, I'm seeing junk data on select to this column.

Environment : AIX43 and Oracle 8.1.7

If anyone knows workarround for this, please share your tips here.

SQL Sample:-
------------
create cluster image_clu (store# number, image# number);
create index image_clu_i on cluster image_clu;

create table image(image# number,
image long,
description varchar2(2000),
store# number)
cluster image_clu(store#, image#);

create table image2(image# number,
name char(50),
store# number)
cluster image_clu(store#, image#);

insert into image values(1,5,9,3);
insert into image values(1,6,9,1);
insert into image values(2,7,9,1);
insert into image values(2,8,9,0);

insert into image2 values(1,9,0);
insert into image2 values(1,9,1);
insert into image2 values(1,9,3);
insert into image2 values(2,9,3);