Python cx_Oracle 安装异常处理

Python3.11 Oracle19 

?

1	pip install cx_Oracle

 解决 error: Microsoft Visual C++ 14.0 or greater is required.

error: Microsoft Visual C++ 14.0 or greater is required - 无虑的小猪 - 博客园

下载安装：visual studio 

 安装后重启执行OK

 测试：

import cx_Oracle

print("cx_Oracle.version:", cx_Oracle.version)
conn=cx_Oracle.connect('用户名/密码@:端口/数据库')
c=conn.cursor()                                                
x=c.execute('select sysdate from dual')                         
data=x.fetchone()
print(data)
c.close()                                                      
conn.close()