Re: rowid added to the select cluase of a statement

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 18 Jul 2021 12:12:18 -0400
Message-ID: <a2c290e9-f6a7-7f7a-2718-47db276958a7_at_gmail.com>

Hi Jeff!

Try setting a trap: ALTER SYSTEM SET EVENTS='918 trace name errorstack forever, level 16';

That will produce a trace file containing the current SQL statement when the error happens. You can analyze it and see what the problem is.

Regards

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. 6^th Street

Cleveland, Ohio 44113

 

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

-- http://www.freelists.org/webpage/oracle-l Received on Sun Jul 18 2021 - 18:12:18 CEST