rowid added to the select cluase of a statement

From: Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org>
Date: Thu, 15 Jul 2021 16:03:45 +0000
Message-ID: <DM6PR09MB467756B6DEF4AE449327F3F1DF129_at_DM6PR09MB4677.namprd09.prod.outlook.com>

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

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

Received on Thu Jul 15 2021 - 18:03:45 CEST