一.問題描述
最近在自學python慨菱，然后用到Oracle數(shù)據(jù)庫施逾，于是開始學習cx_Oracle模塊碧磅。
代碼:
import cx_Oracle
dbConnect_host= cx_Oracle.makedsn('mylocalhost','myportnumber',sid='orcl')
conn = cx_Oracle.connect('system', 'mypassword',dbConnect_host)
print(conn)
c = conn.cursor()
print(e)
報錯信息:
E:\python\learn_python1\venv\Scripts\python.exe E:/python/learn_python1/cx_Oracle_test1.py
Traceback (most recent call last):
File "E:/python/learn_python1/cx_Oracle_test1.py", line 1, in <module>
import cx_Oracle as cx
File "E:\python\learn_python1\venv\lib\site-packages\cx_Oracle\__init__.py", line 10, in <module>
from custom_exceptions import Warning, Error, InterfaceError, DatabaseError, DataError, OperationalError, IntegrityError, InternalError, ProgrammingError, NotSupportedError
ModuleNotFoundError: No module named 'custom_exceptions'
Process finished with exit code 1
通過cmd命令行旗闽，運行OK
C:\Users\Administrator>python
Python 3.6.3 (v3.6.3:2c5fed8, Oct 3 2017, 18:11:49) [MSC v.1900 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>>
>>> import cx_Oracle
>>>
嘗試了百度，CSDN論壇提問的方式蜡塌，都沒有找到解決的方案碉纳。
百度上看到一個人和我同樣的報錯，但是沒有獲得解答:
https://stackoverflow.com/questions/61569759/modulenotfounderror-no-module-named-custom-exceptions-python3
二.解決方案
我梳理了一下我安裝cx_Oracle模塊的過程:
因為最開始在pycharm上查找cx_Oracle模塊的時候沒有找到馏艾，就隨便安裝了一個cx_oracle_on_ctypes模塊村象，發(fā)現(xiàn)不能用。
后面了解到pycharm上cx_Oracle模塊的名字是cx-Oracle攒至，然后重新安裝，就報了提問的那個錯誤躁劣。
剛剛測試了一下迫吐，把該項目下的cx_oracle_on_ctypes這個模塊刪除了，然后import cx_Oracle就正常了账忘。
image.png
重新測試志膀，成功
E:\python\learn_python1\venv\Scripts\python.exe E:/python/learn_python1/cx_Oracle_test1.py
123
Process finished with exit code 0
