Problems with deleting tuples

From: Stefan Krompass <krompass_at_fmi.uni-passau.de>
Date: 8 Aug 2002 10:08:31 -0700
Message-ID: <6f58eb57.0208080908.36f85c5c@posting.google.com>

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 Thu Aug 08 2002 - 12:08:31 CDT