Thanks for posting your solution. I ran into the same problem and probably
wouldn't have figured it out without your post.
- Tom
On Monday, April 15, 2019 at 5:20:36 AM UTC-6, 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/20c1d130-f770-4361-9403-9e4bcd30e3aa%40googlegroups.com.
