Python Forum

Full Version: Oracle Error in Python
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi,
I am writing an oracle query in python(pycharm editor) and in that I am joining 2 tables with a single table.One via inner join and other using full join. When I run the code, I am getting error the following error :cx_Oracle.DatabaseError: ORA-00942: table or view does not exist.

The same code is working in fine in Oracle editor.

If I run a single join then I am not getting any error.
Any help would be appreciated.

Thanks,
As we don't have crystal ball yet, would you share your code - in python tags as well as full traceback in error tags?
Also it would help if you print (and post here) your SQL statement just before execute it.