什么是cx_oracle_on_ctypes,cx_Oracle re-written in Python, using ctypes to interface with Oracle native code. 100% API-compatible with cx_Oracle.
问题:
当使用oralce10g的客户端时,会抛出异常,DatabaseError: ORA-24315: 非法的属性类型。
定位到出错源,connection.py 第111行:
if hasattr(oci, 'OCI_ATTR_DRIVER_NAME'):
buffer = cxBuffer.new_from_object(DRIVER_NAME, self.environment.encoding)
status = oci.OCIAttrSet(self.session_handle, oci.OCI_HTYPE_SESSION, buffer.ptr, buffer.size, oci.OCI_ATTR_DRIVER_NAME, self.environment.error_handle)
self.environment.check_for_error(status, "Connection_Connect(): set driver name")
经过查找源码,OCI_ATTR_DRIVER_NAME只出现在oci_generated_11.py,oci_generated_12.py中,没有在oci_generated_10.py 中定义,按道理使用oracle10g客户端,不会执行这段代码,为什么在这抛出异常呢?
打开源码oci.py,第一行就是:
try:
from cx_Oracle.oci_generated_12 import *
except ImportError as e:
try:
from cx_Oracle.oci_generated_11 import *
except ImportError as e:
try:
from cx_Oracle.oci_generated_10 import *
except ImportError as e:
raise Exception("Could not import oracle libraries version 12, 11 or 10. Giving up. Don't forget to set your ORACLE_HOME and LD_LIBRARY_PATH.")
问题原因就在这,既然用的是oracle10g的客户端,应该导入的是oci_generated_10,但第二行或第五行已经把OCI_ATTR_DRIVER_NAME导入进来了,所以会执行connection.py中的第111行,从而引发错误。
解决:
1.把第二行的12改成10,第五行的10改成12。会不会出现其他问题?
2.使用oracle10,就保留oci_generated_10.py,删除其他两个,其他版本同理。