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,616 Jun-11-2021, 07:59 PM
Last Post: Larz60+
  Calling Oracle REST SQL from Python johnjacob 2 2,065 Nov-05-2020, 04:19 AM
Last Post: johnjacob
  Python to Oracle Conn Issue chvsnarayana 2 41,778 Sep-06-2020, 04:33 PM
Last Post: Larz60+
  Conversion of Oracle PL/SQL(packages, functions, procedures) to python modules. DivyaKumar 2 6,545 Jul-09-2020, 04:46 PM
Last Post: srikanth7482
  Load table from Oracle to MYSQL using python himupant94 0 1,671 May-12-2020, 04:50 PM
Last Post: himupant94
  how to set echo ON in Python call to Oracle SQL nmrt 4 3,781 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,286 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,538 Oct-25-2018, 02:44 PM
Last Post: dinesh1393
  Possible to run Python scripts from oracle? dglass 8 9,472 Sep-06-2018, 05:14 PM
Last Post: dglass
  Unable to connect oracle database using python code mayuresh 2 17,129 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