Re: Problems with deleting tuples

Is the datatype for rid in your ordered_rids identified as ROWID ?

krompass_at_fmi.uni-passau.de (Stefan Krompass) wrote:

>Martin Doherty <martin.doherty_at_oracle.com> wrote in message news:<3D52F550.BDDCD035_at_oracle.com>...
>> Have you tried this variation yet:
>>
>> delete from zsimp_kopf where zsimp_kopf.rowid in
>> (select ordered_rids.rid from ordered_rids)
>
>Yes, I did:
>
>SQL> delete from zsimp_kopf where zsimp_kopf.rowid in
> (select ordered_rids.rid from ordered_rids) 2 ;
>delete from zsimp_kopf where zsimp_kopf.rowid in
> *
>ERROR at line 1:
>ORA-01410: invalid ROWID
>
>Stefan

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Aug 09 2002 - 08:50:41 CDT