The leading edge of scripting languages and Oracle Database brought to you by the Data Access Development team

Python cx_Oracle 6.4 Brings a World Cup of Improvements

Christopher Jones
Senior Principal Product Manager

cx_Oracle logo

cx_Oracle 6.4, the extremely popular Oracle Database interface for Python, is now Production on PyPI.

cx_Oracle is an open source package that covers the Python Database API specification with many additions to support Oracle advanced features.

At a nicely busy time of year, cx_Oracle 6.4 has landed. To keep it brief I'll point you to the release notes since there have been quite a number of improvements. Some of those will significantly help your apps

A few things to note:

  • Improvements to Continuous Query Notification and Advanced Queuing notifications

  • Improvements to session pooling

  • A new encodingErrors setting to choose how to handle decoding corrupt character data queried from the database

  • You can now use a cursor as a context manager:

    with conn.cursor() as c:
        c.execute("SELECT * FROM DUAL")
        result = c.fetchall()

cx_Oracle References

Home page: oracle.github.io/python-cx_Oracle/index.html

Installation instructions: cx-oracle.readthedocs.io/en/latest/installation.html

Documentation: cx-oracle.readthedocs.io/en/latest/index.html

Release Notes: cx-oracle.readthedocs.io/en/latest/releasenotes.html

Source Code Repository: github.com/oracle/python-cx_Oracle

Join the discussion

Comments ( 3 )
  • Prasanna Rajagopal Friday, July 20, 2018
    I was new to the Python cx_Oracle package, but within the hour I was able to get up and running and executing DML and DDL on my OCI DB Service. This is a great tool for every Oracle Database developer.
  • Peter Sorger Saturday, November 17, 2018
    When will it happen, that cx_Oracle becomes a standard library? For automation/innovation purposes does it look like Oracle adopts python more, perl will become obsolete... Does anyone plan changing catcon.pl to a python script? Do you recommend python 3 to be installed additional or you develop on 2.7?
  • Christopher Jones Sunday, November 18, 2018
    Regarding catcon.pl, that is a good question for the DB group. I know you are not the first person to ask about Perl vs Python.

    My thinking is that most DB access is done on a client machine (not the DB server), so you can use whatever language makes most business sense for you.

    If you are just starting Python projects, you should use Python 3.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.