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> 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
>
>
>
> 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