Re: rowid added to the select cluase of a statement

Most likely this is result of the client using SQLSpecialColumns with SQL_BEST_ROWID attribute as explained in the docs: https://docs.oracle.com/database/121/ADFNS/adfns_odbc.htm#ADFNS1212 Errors in the app could be swallowed either by the custom code or by ODBC driver itself. This is just my guess though.

On Mon, Jul 19, 2021 at 3:45 PM Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org> wrote:

> We are not seeing any errors in the application which is really strange.
>
>
>
> *From:* Chris Taylor <christopherdtaylor1994_at_gmail.com>
> *Sent:* Thursday, July 15, 2021 1:09 PM
> *To:* Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org>
> *Cc:* oracle-l_at_freelists.org
> *Subject:* 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
> <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%7Ced3c5f05edb24b623a2708d947b34cd5%7Cebe8e20736ec47f48cb8f5f757605f5d%7C1%7C0%7C637619657720999180%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=Ap5%2F00DArb4zonSmJoeJaNjX7sZgBtI789XJmvJ2zro%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
>
>
>
>

-- 
Regards
Timur Akhmadeev

--
http://www.freelists.org/webpage/oracle-l