What is cx_Oracle?
cx_Oracle is a Python extension module that enables access to Oracle
Database for Python 3.x and 2.x and conforms to the Python database API 2.0
specifications with a number of enhancements.
Where do I get it?
The easiest method to install/upgrade cx_Oracle is via pip as in
python -m pip install cx_Oracle --upgrade
This release eliminates the error "DPI-1054: connection cannot be closed
when open statements or LOBs exist". It also adds support for creating
temporary LOBs and binding LOBs directly to a cursor. You can now also use
a connection as a context manager to close the connection at the end of the
block by using the new cx_Oracle.__future__ object (
This will become the default and only behaviour of using a connection as a
context manager unless I hear otherwise! The code was reorganised and
simplified in order to streamline further maintenance and a number of bugs
were fixed. The full release notes can be read here:
Please provide any feedback via GitHub issues (
Support the Python Software Foundation: