Hi, developers!
I've noticed I can't use in-place data editor with index-organized tables.
Test case:
When updating I get a Warning messagebox saying "Record 1 has been deleted".
When deleting it just silently does nothing, thus writing in the status bar that "1 record deleted".
Support info:
I've noticed I can't use in-place data editor with index-organized tables.
Test case:
Code:
create table test_table (
a number(10) not null,
b number(10) not null,
constraint tt_PK primary key (a,b)
) organization index; -- non-IOTs work fine!
insert into test_table values (1,2);
-- editing this result works fine:
select rowid,t.* from test_table t where a=1
for update;
-- editing this result fails:
select t.* from test_table t --where a=1
for update
When updating I get a Warning messagebox saying "Record 1 has been deleted".
When deleting it just silently does nothing, thus writing in the status bar that "1 record deleted".
Support info:
PL/SQL Developer
Version 8.0.4.1514
Windows XP Professional 5.1 Build 2600 (Service Pack 2)
Physical memory : 2
Version 8.0.4.1514
Windows XP Professional 5.1 Build 2600 (Service Pack 2)
Physical memory : 2