Re: Problems with deleting tuples

Hi Stefan,

it works here:

SQL> delete from zsimp_kopf
  2 where zsimp_kopf.rowid in (select ordered_rids.* from ordered_rids);

162 rows deleted.

Can you please post the complete definition of the involved tables and views? Otherwise I must assume that something else is going wrong but the syntax definitely works.

Martin

Stefan Krompass wrote:
>
> Hi!
>
> I've got several tables (zsimp_*) where I want to delete tuples from.
> The tuples that have to be deleted are stored in the tables
> test_zsimp_*. Furthernore, I store the rowIDs of the tuples that have
> to be deleted in a table ordered_rid:
>
> INSERT INTO ordered_rids SELECT zsimp_kopf.rowID FROM zsimp_kopf,
> test_zsimp_kopf WHERE zsimp_kopf.K2=test_zsimp_kopf.K2 AND
> zsimp_kopf.K3=test_zsimp_kopf.K3
> ...
>
> The tuples should be deleted with the following statement:
>
> DELETE FROM zsimp_kopf WHERE zsimp_kopf.rowID IN
> (SELECT ordered_rids.* FROM ordered_rids)
>
> At this point, I get an Oracle-Error (ORA-01410: invalid ROWID). Can
> anybody tell me what I'm doing wrong?
> Thanks
>
> Stefan
Received on Mon Aug 12 2002 - 00:34:58 CDT