Re: A RowId in Oracle 8i

In article <95eilr$j87$1_at_pheidippides.axion.bt.co.uk>,   bynia.doyle_at_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_at_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_at_rii.com
              Usual disclaimers


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