Oracle Database Connection in Python
Hello geek! In this article, we will learn how to set up a connection between the Oracle database and our Python program in a simple way.
First of all, we need to have the Oracle database of versions greater than or equal to 11.x preinstalled in your system.
Python program to set up Oracle Database connection
Installing cx_Oracle module
Now, install the cx_Oracle module by typing the following command in cmd.
pip install cx_Oracle
Establishing a connection
We can establish a connection between the Oracle database and our python program with the help of connect( ) method. Here, co is a connection object.
co = cx_Oracle.connect(user = 'database_username', password = 'database_password')
We can also simply write – connect( ‘database_username/database_password’ )
Closing a connection
It is necessary to close the connections as soon as our work is done. We will use close( ) method to close the database connection. We can include this in finally block.
Sometimes, we may encounter many exceptions while dealing with databases. For eg. giving a wrong username or password raises DatabaseError exception. So, to handle these exceptions we will include our code in try & except block.
import cx_Oracle try: co=cx_Oracle.connect('Username/Password') print("Connected") except Exception as e: print("Error: ",str(e)) finally: if co: co.close()
Instead of always closing our connection using close( ) method, we can use with statement which simplifies our code.
import cx_Oracle try: with cx_Oracle.connect('Username/Password') as co: print("Connected") except Exception as e: print("Error: ",str(e))
If you get the output as above, Bingo! you have been successfully connected.
Else if you are facing any difficulties, feel free to post them below.
That’s all for now. Hope you found this helpful!