Re: Problems with deleting tuples

On 8 Aug 2002 10:08:31 -0700, krompass_at_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 Received on Thu Aug 08 2002 - 13:04:07 CDT