Path: news.easynews.com!easynews!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: Sybrand Bakker <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: Problems with deleting tuples
Date: Thu, 08 Aug 2002 20:04:07 +0200
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <ghc5lu0ashq2l9fq32v5qsaiu7q3o9ftjm@4ax.com>
Reply-To: postbus@sybrandb.demon-verwijderdit.nl
References: <6f58eb57.0208080908.36f85c5c@posting.google.com>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: newsabuse@supernews.com
Lines: 39
Xref: easynews comp.databases.oracle.server:157291
X-Received-Date: Thu, 08 Aug 2002 11:01:06 MST (news.easynews.com)

On 8 Aug 2002 10:08:31 -0700, krompass@fmi.uni-passau.de (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
>

- using the asterix (*) instead of <table_name>.rowid.
- using trics that are going to be a real pain in the head, instead of
ordinary sql.
I for myself *never* needed to store the rowid.
Quite likely your application is on the way to hell.

Regards


>Stefan

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address