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 web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/20c1d130-f770-4361-9403-9e4bcd30e3aa%40googlegroups.com.

Reply via email to