RE: rowid added to the select cluase of a statement

We are not seeing any errors in the application which is really strange.

From: Chris Taylor <christopherdtaylor1994_at_gmail.com> Sent: Thursday, July 15, 2021 1:09 PM
To: Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org> Cc: oracle-l_at_freelists.org
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_at_gcrta.org<mailto:jbeckstrom_at_gcrta.org>> 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

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