Path: news.easynews.com!easynews!feedwest.aleron.net!aleron.net!sfo2-feed1.news.algx.net!allegiance!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: krompass@fmi.uni-passau.de (Stefan Krompass)
Newsgroups: comp.databases.oracle.server
Subject: Problems with deleting tuples
Date: 8 Aug 2002 10:08:31 -0700
Organization: http://groups.google.com/
Lines: 22
Message-ID: <6f58eb57.0208080908.36f85c5c@posting.google.com>
NNTP-Posting-Host: 132.231.54.1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1028826511 6513 127.0.0.1 (8 Aug 2002 17:08:31 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2002 17:08:31 GMT
Xref: easynews comp.databases.oracle.server:157286
X-Received-Date: Thu, 08 Aug 2002 10:05:36 MST (news.easynews.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