RE: RE: rowid added to the select cluase of a statement

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

Oracle ODBC 12.2

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of ahmed.fikri_at_t-online.de Sent: Thursday, July 15, 2021 12:42 PM
To: Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org>; mwf_at_rsiz.com; oracle-l_at_freelists.org Subject: AW: RE: rowid added to the select cluase of a statement

how is the vendor code is executed? Directly using Sqlplus? Or there is another layer between the application and Oracle? Some tools wrap the code sent to the database

---

Gesendet mit der Telekom Mail App<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fkommunikationsdienste.t-online.de%2Fredirects%2Femail_app_android_sendmail_footer&data=04%7C01%7Cjbeckstrom%40gcrta.org%7C824564b53da54ec3357808d947afa5cd%7Cebe8e20736ec47f48cb8f5f757605f5d%7C1%7C0%7C637619642014810487%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=mVuAI%2FlLqo7ERGee0tmFcp5qK4H3d79KdEqUwfTjbUM%3D&reserved=0>

• Original-Nachricht --- Von: Beckstrom, Jeffrey Betreff: RE: rowid added to the select cluase of a statement Datum: 15. Juli 2021, 18:35 An: ahmed.fikri_at_t-online.de<mailto:ahmed.fikri_at_t-online.de>, mwf_at_rsiz.com<mailto:mwf_at_rsiz.com>, oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>

We know that. Vendor states they are not coding the rowed. So where is it coming from?

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> On Behalf Of ahmed.fikri_at_t-online.de<mailto:ahmed.fikri_at_t-online.de> Sent: Thursday, July 15, 2021 12:30 PM
To: mwf_at_rsiz.com<mailto:mwf_at_rsiz.com>; Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org<mailto:jbeckstrom_at_gcrta.org>>; oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: AW: rowid added to the select cluase of a statement

Hi,

I guess join is used in the sql and in this case table alias should be used:

select rowid, a.* from table_a a join table_b b using(whatever to join ) --> column ambiguously

select a.rowid rowid_from_a, b.rowid rowid_from_b,a.*,b.* from table_a a join table_b b using(whatever to join) will work

Best regards

Ahmed

-----Original-Nachricht-----

Betreff: RE: rowid added to the select cluase of a statement

Datum: 2021-07-15T18:20:01+0200

Von: "Mark W. Farnham" <mwf_at_rsiz.com<mailto:mwf_at_rsiz.com>>

An: "jbeckstrom_at_gcrta.org<mailto:jbeckstrom_at_gcrta.org>" <jbeckstrom_at_gcrta.org<mailto:jbeckstrom_at_gcrta.org>>, "oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>" <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>

The before and after sql text might be useful as well as what interface submitted the sql.

IF you can grab the sql text and submit it directly at the local command line, that might help discover or rule out where to focus investigation.

Whether the objects referenced in the statement are tables or something complex, such as join views, might also be of interest.

Good luck!

mwf

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Beckstrom, Jeffrey Sent: Thursday, July 15, 2021 12:04 PM
To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: rowid added to the select cluase of a statement

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%7C824564b53da54ec3357808d947afa5cd%7Cebe8e20736ec47f48cb8f5f757605f5d%7C1%7C0%7C637619642014810487%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=WsffCRiEBQ8zm17rWcce51shYQq4%2F%2BymMHPockt0r%2BI%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 Received on Thu Jul 15 2021 - 19:03:46 CEST