RE: Anyone seen ROWID's added to the SELECT clause of a statement ?

I'm pretty sure that this is an ADO thing.  I saw it when I was working with 
ADO clients and the developers confirmed it.
 

Paul Baumgartel 
CREDIT SUISSE 
Information Technology 
DBA & Admin - NY, KIGA 1 
One Madison Avenue 
New York, NY 10010 
USA 
Phone 212.538.1143 
paul.baumgartel@xxxxxxxxxxxxxxxxx 
www.credit-suisse.com 

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Niall Litchfield
Sent: Friday, March 16, 2007 12:44 PM
To: robertgfreeman@xxxxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
Subject: Re: Anyone seen ROWID's added to the SELECT clause of a statement?


It's commonly used for 'scrollable' cursors with ADO (I think also ADO.Net but 
can't recall). It may be an artifact of the MS Oracle ODBC driver from memory. 
 
see http://www.sqlteam.com/item.asp?ItemID=11842 
<http://www.sqlteam.com/item.asp?ItemID=11842>  for a sqlserver based 
discussion of the options available. 
 
On 3/16/07, Robert Freeman <robertgfreeman@xxxxxxxxx 
<mailto:robertgfreeman@xxxxxxxxx> > wrote: 

I have an application that everyone swears no changes
have occured on, that is adding a ROWID clause to the 
end of the select clause of each SQL statement.

The application code does not appear to be doing this.
It runs through ODBC. The database does not appear to
be doing this.

Has anyone seen anything like this before? 

Robert


Robert G. Freeman
Author:
Portable DBA: Oracle  (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Features (Oracle Press) 
Oracle Replication (Rampant Tech Press)
Mastering Oracle8i (Sybex)
Oracle8 to 8i Upgrade Exam Cram (Coriolis <RIP>)
Oracle 7.3 to 8 Upgrade Exam Cram (Coriolis <RIP>)
--
http://www.freelists.org/webpage/oracle-l 
<http://www.freelists.org/webpage/oracle-l> 







-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info <http://www.orawin.info>  

==============================================================================
Please access the attached hyperlink for an important electronic communications 
disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

Other related posts: