RE: rowid added to the select cluase of a statement
Date: Thu, 15 Jul 2021 12:14:17 -0400
Message-ID: <80ba01d77994$76a51510$63ef3f30$_at_rsiz.com>
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]
On Behalf Of Beckstrom, Jeffrey
Sent: Thursday, July 15, 2021 12:04 PM
To: 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-SELE CT-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-lReceived on Thu Jul 15 2021 - 18:14:17 CEST