Error when delete from IOT - Allround Automations forums

Register Log In

Forums Products Direct Oracle Access Error when delete from IOT

Print Thread

Error when delete from IOT #42146 09/12/11 08:16 AM
Joined: Aug 2009 Posts: 67 S sinys OP Member
OP sinys Member S Joined: Aug 2009 Posts: 67	Error when delete from IOT. I'm use DOA 4.1.2.2, Delphi 2010, oracle 9i. OracleDataSet1_IOT.SQL.Text SQL Query 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

Re: Error when delete from IOT sinys #42147 09/12/11 09:51 AM
Joined: Aug 1999 Posts: 22,220 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,220	We have indeed received some problem reports about rowid's on index organized tables. We do not yet have a solution. Marco Kalter Allround Automations

Re: Error when delete from IOT Marco Kalter #42157 09/12/11 11:18 AM
Joined: Aug 2009 Posts: 67 S sinys OP Member
OP sinys Member S Joined: Aug 2009 Posts: 67	May be you add patch for IOT table for delete records on primary key fields?

Re: Error when delete from IOT sinys #42163 09/13/11 09:35 AM
Joined: Aug 1999 Posts: 22,220 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,220	That would indeed be an option. Marco Kalter Allround Automations

Re: Error when delete from IOT Marco Kalter #42299 09/23/11 05:15 AM
Joined: Aug 2009 Posts: 67 S sinys OP Member
OP sinys Member S Joined: Aug 2009 Posts: 67	[quote=Marco Kalter]That would indeed be an option.[/quote] Ok and this will be implemented? and when?

Re: Error when delete from IOT sinys #42301 09/23/11 09:38 AM
Joined: Aug 1999 Posts: 22,220 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,220	I don't have such information yet. It will require some redesign. Marco Kalter Allround Automations

Re: Error when delete from IOT Marco Kalter #42457 10/12/11 04:17 PM
Joined: Jul 2003 Posts: 112 Fino Mornasco, Como, Italy L ldsandon Member
ldsandon Member L Joined: Jul 2003 Posts: 112 Fino Mornasco, Como, Italy	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? LDS

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.033s Queries: 15 (0.010s) Memory: 2.5218 MB (Peak: 3.0405 MB) Data Comp: Off Server Time: 2024-05-16 10:31:41 UTC
Valid HTML 5 and Valid CSS