Error when delete from IOT

[sinys]

Error when delete from IOT.
I'm use DOA 4.1.2.2, Delphi 2010, oracle 9i.

OracleDataSet1_IOT.SQL.Text

select
  t.cip_usl,
  d.name,
  t.c_usl,
  t.rowid
from
  lp.m_usl t, -- IOT
  lp.mm d
where
  t.cipher_usl = d.cipher

OracleDataSet1_IOT.Delete; - exception ORA-01410 Invalid ROWID

 

[Marco Kalter]

We have indeed received some problem reports about rowid's on index organized tables. We do not yet have a solution.

 

[sinys]

May be you add patch for IOT table for delete records on primary key fields?

 

[Marco Kalter]

That would indeed be an option.

 

[sinys]

That would indeed be an option.

Ok and this will be implemented? and when?

 

[Marco Kalter]

I don't have such information yet. It will require some redesign.

 

[ldsandon]

IOT uses logical row ids, which can change. Didn't Oracle introduced Universal Row IDs (UROWID type) to resolve this issue? Can DOA handle UROWIDs?