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.