From: bynia.doyle@bt.com (Bynia Doyle)
Newsgroups: comp.databases.oracle.server
Subject: A RowId in Oracle 8i
Date: Fri, 02 Feb 2001 15:08:43 GMT
Organization: BT
Lines: 22
Message-ID: <95eilr$j87$1@pheidippides.axion.bt.co.uk>
NNTP-Posting-Host: 147.150.202.138
X-Trace: pheidippides.axion.bt.co.uk 981126651 19719 147.150.202.138 (2 Feb 2001 15:10:51 GMT)
X-Complaints-To: postmaster@axion.bt.co.uk
NNTP-Posting-Date: 2 Feb 2001 15:10:51 GMT
X-Newsreader:  News Xpress 2.01


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 **