Python interface to Oracle Database now superseded by python-oracledb
cx_Oracle 7.2 is now released. The biggest enhancements for this release are for advanced queuing with the addition of support for RAW queues and bulk enqueue/dequeue. Preview support for bulk insert with SODA was also added.
A number of smaller enhancements and bug fixes were also made. See the full release notes for all of the details.
This release addresses a number of issues. See the release notes for more information.
This release addresses a number of issues. See the release notes for more information.
This release addresses a number of issues. See the release notes for more information.
cx_Oracle 7.1 is now released. The biggest enhancement for this release is for session pools. Specifically, a session callback may now be specified when a pool is created. This allows an application to improve performance by reducing the number of round trips to the database needed in order to set session state.
A number of smaller enhancements and bug fixes were also made. See the full release notes for all of the details.
cx_Oracle 7.0 is now released. The biggest enhancements for this release come with support for Oracle Client 18 libraries. This allows support for new features such as call timeouts and a preview of SODA (Simple Oracle Document Access).
A number of smaller changes were also made to improve the experience of using cx_Oracle. These include re-enabling the pool pinging functionality for Oracle 12.2 and higher to handle classes of connection errors such as resource profile limits; improved error messages when a feature requires a particular version of Oracle Client libraries or Oracle Database; better handling of objects when the connection that created them is closed; better handling of connections when the pool that created them is destroyed; etc.
For those upgrading from cx_Oracle 6, note that variables bound to DML returning statements now return an array when calling getvalue() and that using a connection as a context manager now closes the connection when the block is completed.
See the release notes for more information.
This release addresses a number of issues. See the release notes for more information.
This release adds support for grouping notifications to subscriptions and adds support for getting notifications when AQ messages are available to be dequeued. Support was also added for timed waits when acquiring sessions from a session pool and for setting the values of the timeout and maximum lifetime attributes of a pool when it is created. Cursors can now be used as context managers and a number of other enhancements and bug fixes were made. See the release notes for more information.
This release addresses a number of issues. See the release notes for more information.
This release addresses a number of issues and bug fixes. The changes needed to support DML Returning with cursor.executemany() required a new point release since the attribute dml_ret_array_val in the cx_Oracle.__future__ object needs to be set in order for it to work correctly. Setting it changes the behavior for DML Returning statements with cursor.execute() as well and will become the new behavior in cx_Oracle 7. See the release notes for more information.