From: Mike Krolewski <mkrolewski@rii.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: A RowId in Oracle 8i
Date: Fri, 02 Feb 2001 17:49:24 GMT
Organization: Deja.com
Lines: 44
Message-ID: <95erv0$adk$1@nnrp1.deja.com>
References: <95eilr$j87$1@pheidippides.axion.bt.co.uk>
NNTP-Posting-Host: 63.75.139.178
X-Article-Creation-Date: Fri Feb 02 17:49:24 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.1 x56.deja.com:80 (Squid/1.1.22) for client 63.75.139.178
X-MyDeja-Info: XMYDJUIDmikkrolewski


In article <95eilr$j87$1@pheidippides.axion.bt.co.uk>,
  bynia.doyle@bt.com (Bynia Doyle) wrote:
> Hi,
> In 7.3.4 I I used Rowids in a statement that was passed to dbms_sql
 as as
>  follows:
> Delete from Table where Rowid in (Rowid1, Rowid2,..., Rowidn).
>
> The (Rowid1, Rowid2,..., Rowidn) was stored in a variable of type
 VARCHAR2
> and was construted in a loop.
>
> When I'm attempting to do use the same approach in Oracle 8.1.6 I get
> ORA-01410: invalid ROWID
>
> I gather that the data type of RowId is not the same as it was in
 7.3.4 - any
> ideas on the changes to the statement to get it to work?
>
> Thanks,
> Bynia.
>
> Bynia.
>
> bynia.doyle@bt.com
>
> ** All possible disclaimers apply **
>

Yes the rowid has changes. Read the 8i Concepts manual, chapter 12 on
rowid. There are 2 rowid type ( extended rowid is 18 characters,
restricted rowid is 16). There is a package DBMS_ROWID for converting
back and forth.


--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski@rii.com
              Usual disclaimers


Sent via Deja.com
http://www.deja.com/