Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Anyone seen ROWID's added to the SELECT clause of a statement?

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

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Fri, 16 Mar 2007 08:15:46 -0600
Message-ID: <KEEDIPJOJLCHPPAIDPDOCEBJDMAA.robertgfreeman@yahoo.com>


This is exactly what it was.... No one had ever noticed it doing this before so at first we thought that was the problem.

Turns out that someone had set cursor_sharing to similar earlier that day, which caused all sorts of problems when using group by statements (for some reason the SQL with the added bind variables was not getting the ROWID columns put in the group by clause). Setting cursor_sharing back to exact solved the problem.

Thanks to everyone for their replies!!

RF

  -----Original Message-----
  From: Mindaugas Navickas [mailto:mnavickas_at_yahoo.com]   Sent: Friday, March 16, 2007 7:37 AM
  To: robertgfreeman_at_yahoo.com; Oracle-L_at_freelists.org   Subject: 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

  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 - 09:15:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US