Damn Oracle! Can you find some documentation that says that quoting of
table names is not supported and we will change? Want to make sure there
not some other configuration quirk before removing a useful feature.
On Monday, 15 April 2019 04:20:36 UTC-7, gliporace wrote:
>
> I think I found the problem:
> the query is sent with the table name double-quoted:
>
> select "ana_paz"."COGNOME", "ana_paz"."NOME" from "ana_paz" where
> "ana_paz"."COGNOME"='ROSSI' <--- doesn't not work ("table or view does
> not exists")
>
> select ana_paz."COGNOME", ana_paz."NOME" from "ana_paz" where
> ana_paz."COGNOME"='ROSSI' <---- works
>
> Setting
> entity_quoting = False
>
> in the database connection solved the problem.
>
>
>
> Il giorno venerdì 12 aprile 2019 17:00:14 UTC+2, gliporace ha scritto:
>>
>> Hi,
>> I just updated my web2py installation from 2.11 to 2.18.5, but the apps
>> who make use of cx_Oracle for connecting to a Oracle database show this
>> error
>> when ther try to query a table/view:
>>
>> Exception ORA-00942: table or view does not exist
>>
>> The old web2py installation run without problems on a Ubuntu server 14.04
>> and cx_Oracle 5.3, the new installation is on Ubuntu server 16.04 with the
>> same version of cx_Oracle.
>>
>> Is there any means to check what is the query before is sent to the
>> server?
>>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
