From: David Fitzjarrell <oratune@aol.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: A RowId in Oracle 8i
Date: Fri, 02 Feb 2001 18:02:41 GMT
Organization: Deja.com
Lines: 39
Message-ID: <95esnq$b2l$1@nnrp1.deja.com>
References: <95eilr$j87$1@pheidippides.axion.bt.co.uk>
NNTP-Posting-Host: 64.19.63.136
X-Article-Creation-Date: Fri Feb 02 18:02:41 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
X-Http-Proxy: 1.0 WEBPROXY, 1.0 x69.deja.com:80 (Squid/1.1.22) for client 64.19.63.136
X-MyDeja-Info: XMYDJUIDddf_dba


In our last gripping episode 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 **
>

Try using the ROWIDTOCHAR function to convert the internal ROWID to a
character string.  I've tried it with dbms_sql in 8.1.6 and it works
nicely.

--
David Fitzjarrell
Oracle Certified DBA


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