We are not seeing any errors in the application which is really strange.
From: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
Sent: Thursday, July 15, 2021 1:09 PM
To: Beckstrom, Jeffrey <jbeckstrom@xxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: rowid added to the select cluase of a statement
Yeah I was going to say if you're using an ODBC driver then usually you will
see that SQL with the [ROWID] in the select and then another SQL without it.
Usually the driver will send the query twice - one with ROWID and one without.
Are you getting errors in the application , or only in some database logs?
Chris
On Thu, Jul 15, 2021 at 12:03 PM Beckstrom, Jeffrey
<jbeckstrom@xxxxxxxxx<mailto:jbeckstrom@xxxxxxxxx>> wrote:
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<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.freelists.org%2Fpost%2Foracle-l%2FAnyone-seen-ROWIDs-added-to-the-SELECT-clause-of-a-statement%2C1&data=04%7C01%7Cjbeckstrom%40gcrta.org%7Ced3c5f05edb24b623a2708d947b34cd5%7Cebe8e20736ec47f48cb8f5f757605f5d%7C1%7C0%7C637619657720999180%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=Ap5%2F00DArb4zonSmJoeJaNjX7sZgBtI789XJmvJ2zro%3D&reserved=0>
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
