Does the vendor's application use ODBC? If so, which ODBC driver is being
used and is that different from the driver that was in use whe this was
previously working?
On Thursday, July 15, 2021, 12:35:55 PM EDT, Beckstrom, Jeffrey
<jbeckstrom@xxxxxxxxx> wrote:
We know that. Vendor states they are not coding the rowed. So where is it
coming from?
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>On Behalf Of
ahmed.fikri@xxxxxxxxxxx
Sent: Thursday, July 15, 2021 12:30 PM
To: mwf@xxxxxxxx; Beckstrom, Jeffrey <jbeckstrom@xxxxxxxxx>;
oracle-l@xxxxxxxxxxxxx
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@xxxxxxxx>
An: "jbeckstrom@xxxxxxxxx" <jbeckstrom@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx"
<oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On ;
Behalf Of Beckstrom, Jeffrey
Sent: Thursday, July 15, 2021 12:04 PM
To: oracle-l@xxxxxxxxxxxxx
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
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
