Oracle Error in Python

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Oracle Error in Python

amitjain78
Unladen Swallow

Posts: 3

Threads: 2

Joined: Aug 2018

Reputation: 0

Aug-01-2018, 06:48 AM

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,

Find

Messages In This Thread

Oracle Error in Python - by amitjain78 - Aug-01-2018, 06:48 AM

RE: Oracle Error in Python - by buran - Aug-01-2018, 06:55 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Encrypting Oracle Passwords / Python Library for That?	bmccollum	1	2,725	Jun-11-2021, 07:59 PM Last Post: Larz60+
	Calling Oracle REST SQL from Python	johnjacob	2	2,171	Nov-05-2020, 04:19 AM Last Post: johnjacob
	Python to Oracle Conn Issue	chvsnarayana	2	52,853	Sep-06-2020, 04:33 PM Last Post: Larz60+
	Conversion of Oracle PL/SQL(packages, functions, procedures) to python modules.	DivyaKumar	2	6,716	Jul-09-2020, 04:46 PM Last Post: srikanth7482
	Load table from Oracle to MYSQL using python	himupant94	0	1,756	May-12-2020, 04:50 PM Last Post: himupant94
	how to set echo ON in Python call to Oracle SQL	nmrt	4	3,914	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,524	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,603	Oct-25-2018, 02:44 PM Last Post: dinesh1393
	Possible to run Python scripts from oracle?	dglass	8	9,759	Sep-06-2018, 05:14 PM Last Post: dglass
	Unable to connect oracle database using python code	mayuresh	2	17,248	Jan-27-2018, 11:57 AM Last Post: mayuresh

Users browsing this thread: 2 Guest(s)

View a Printable Version

Oracle Error in Python

User Panel Messages

Announcements