Hy I try to connect with my oracle database but I have error. I'm a beginner in python i try find answer in documentation but It to hard for me.
Python version :
Python 3.8.5 (tags/v3.8.5:580fbb0, Jul 20 2020, 15:57:54) [MSC v.1924 64 bit (AMD64)] on win32
Oracle version :
11.2.0.1.0
My cod is simple :
from sqlalchemy import create_engine
import cx_Oracle
engine = create_engine('oracle://user:password@ho.st.name:port/SID')
result = engine.execute('select * FROM TABLE')
In result I get an error :
Exception has occurred: DatabaseError
(cx_Oracle.DatabaseError) DPI-1047: Cannot locate a 64-bit Oracle Client library: "The specified module could not be found".