rowid added to the select cluase of a statement

  • From: "Beckstrom, Jeffrey" <jbeckstrom@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 15 Jul 2021 16:03:45 +0000

In Oracle 12.2, we are seeing parse warning messages. The sql shown includes 
rowid in the select which causes the sql to be invalid - column ambiguously 
defined. Google found the below entry from 2007.

https://www.freelists.org/post/oracle-l/Anyone-seen-ROWIDs-added-to-the-SELECT-clause-of-a-statement,1

Does this sound familiar to anyone and if so what is the fix?

Jeffrey Beckstrom
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113

Other related posts: