cx_oracle kurulumu;
1 – pip kurulumu yapılır:
sudo apt-get install python3-pip python3-dev build-essential
sudo pip install –upgrade pip
sudo pip install –upgrade virtualenv
2 – pip install cx_Oracle
Sonrasında test (oracle.py);
#!/usr/bin/env python
#-*- coding: utf-8 -*-
import cx_Oracle
conn_str = “PROXXX/PROXXX@192.168.XXX.XXX:1521/VX8”
conn = cx_Oracle.connect(conn_str)
c = conn.cursor()
c.execute(“SELECT PG.ADI, PG.SOYADI, PG.VERILENODANO, PG.GELISTARIHI, PG.AYRILISTARIHI FROM PRO_XXX PG ORDER BY PG.VERILENODANO”)
for row in c:
print (row[0], ‘-‘, row[1], ‘-‘, row[2], ‘-‘, row[3], ‘-‘, row[4])
conn.close()