Connecting to Oracle Database using IronPython

IronPython is an open-source implementation of Python programming language which is tightly integrated with the .NET Framework. IronPython can use the .NET Framework and Python libraries like wise other.NET languages can use Python script without a hassle.

Firstly, you have to set up environment for IronPython and Oracle Database.

You check my below posts to set up the environment.

Connecting to Oracle Database using Python

Connecting to SQL Server using Python

IronPython Set up

You can download and install IronPython from this link

Get Velammal Ayyappan’s stories in your inbox

Join Medium for free to get updates from this writer.

Remember me for faster sign in

And, make sure you have installed Oracle Developer Tools. Also, create a test database which has a sample table with some data stored.

Sample IronPython script to fetch data from Oracle database

In Visual Studio, Create a new IronPython application and write a below sample script and execute it.

import clr

#Reference path of Oracle Developer Tools — Oracle ManagedDataAccess
clr.AddReferenceToFileAndPath(“C:\Program Files (x86)\Oracle Developer Tools for VS2017\odp.net\managed\common\Oracle.ManagedDataAccess.dll”)

from Oracle.ManagedDataAccess.Client import OracleConnection

#Connection string
conn = OracleConnection(“Data Source=//127.0.0.1:1522/databasename;USER Id=userid;PASSWORD=password;”)
conn.Open()

cmd = conn.CreateCommand()
#Fetching data from local oracle database
cmd.CommandText = ‘select * from customers’
reader = cmd.ExecuteReader()
customers =[]
if reader.HasRows:
while reader.Read():
customer = {
‘id’: reader.GetString(reader.GetOrdinal(“customer_id”)),
‘name’: reader.GetString(reader.GetOrdinal(“customer_name”)),
‘city’:reader.GetString(reader.GetOrdinal(“city”))
}
customers.append(customer)

conn.Close()
print(“ — — — — Id — — — — — Name — — — — — City — — — — “)
for customer in customers:
print(“ %d %s %s “ %(customer.id,customer.name,customer.city))
print(“ — — — — — — — — — — — — — — — — — — — — — — — -”)

Output

To run the application:

1. From Solution Explorer → select the python file you want to execute.
2. Right-click and select Start without Debugging option.

You can see the output in a specified format in command prompt window.