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.Netbut 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 for a sqlserver based discussion of the options available.

On 3/16/07, Robert Freeman <robertgfreeman_at_yahoo.com> 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
>
>
>

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

--
http://www.freelists.org/webpage/oracle-l