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

Hi Robert,

That seams to me normal frontend trick when application retrieves dataset with intent to update some rows. I would think that this is done by application rather than ODBC driver. ROWID is used as a reference to the original row while updating.

Regards
Mindaugas Navickas

• Original Message ---- From: Robert Freeman <robertgfreeman_at_yahoo.com> To: Oracle-L_at_freelists.org Sent: Thursday, March 15, 2007 8:26:00 PM Subject: Anyone seen ROWID's added to the SELECT clause of a statement?

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 Received on Fri Mar 16 2007 - 08:37:02 CDT