Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Oracle Error in Python
#1
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,
Reply
#2
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.
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Encrypting Oracle Passwords / Python Library for That? bmccollum 1 2,573 Jun-11-2021, 07:59 PM
Last Post: Larz60+
  Calling Oracle REST SQL from Python johnjacob 2 2,031 Nov-05-2020, 04:19 AM
Last Post: johnjacob
  Python to Oracle Conn Issue chvsnarayana 2 38,007 Sep-06-2020, 04:33 PM
Last Post: Larz60+
  Conversion of Oracle PL/SQL(packages, functions, procedures) to python modules. DivyaKumar 2 6,489 Jul-09-2020, 04:46 PM
Last Post: srikanth7482
  Load table from Oracle to MYSQL using python himupant94 0 1,637 May-12-2020, 04:50 PM
Last Post: himupant94
  how to set echo ON in Python call to Oracle SQL nmrt 4 3,733 Sep-21-2019, 05:40 AM
Last Post: nmrt
  Long command with characters not working in Python on Oracle Linux 7 iaas_infra 10 6,233 Jul-19-2019, 04:53 PM
Last Post: ichabod801
  Getting an error while connecting oracle DB from Python : cx_Oracle.DatabaseError: OR dinesh1393 0 3,524 Oct-25-2018, 02:44 PM
Last Post: dinesh1393
  Possible to run Python scripts from oracle? dglass 8 9,349 Sep-06-2018, 05:14 PM
Last Post: dglass
  Unable to connect oracle database using python code mayuresh 2 17,076 Jan-27-2018, 11:57 AM
Last Post: mayuresh

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020