X

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

python

Python and cx_Oracle RPMs are available from yum.oracle.com

This is worth cross posting: Getting Started with Python Development on Oracle Linux Our Oracle Linux group has made Python and cx_Oracle RPMs available for a while. They recently launched a new landing page with nice, clear instructions on how to install various versions of Python, and how to install the cx_Oracle interface for Oracle Database. Check the link above.

Wednesday, May 30, 2018 | python | Read More

Efficient and Scalable Batch Statement Execution in Python cx_Oracle

    Today's guest post is by Oracle's Anthony Tuininga, creator and lead maintainer of cx_Oracle, the extremely popular Oracle Database interface for Python.       Introduction This article shows how batch statement execution in the Python cx_Oracle interface for Oracle Database can significantly improve performance and make working with large data sets easy. In many cx_Oracle applications, executing SQL and PL/SQL statements using the method cursor.execute() is perfect. But if you...

Friday, April 27, 2018 | python | Read More

Python cx_Oracle 6.3 Supports DML RETURNING for Batch Statement Execution

cx_Oracle 6.3, 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. Top Feature: Cursor.executemany() support for OUT bind variables in DML RETURNING statements.   This release contains a number of bug fixes and useful improvements. For the full list, see the Release Notes, but I wanted to highlight a few...

Friday, April 27, 2018 | python | Read More

Python cx_Oracle 6.2 is out on PyPI

cx_Oracle 6.2, 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. This release: Adds support for creating temporary CLOBs, BLOBs or NCLOBs via a new method Connection.createlob(). Adds support for binding a LOB value directly to a cursor. Adds support for closing the connection when reaching the end of a...

Tuesday, March 6, 2018 | python | Read More

cx_Oracle 6.1 with Oracle Database Sharding Support is now Production on PyPI

cx_Oracle 6.1, 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. In the words of the creator and maintainer, Anthony Tuininga: The cx_Oracle 6.1 release has a number of enhancements building upon the release of 6.0 made a few months ago. Topping the list is support for accessing sharded databases via...

Tuesday, December 12, 2017 | python | Read More

Python cx_Oracle 6 Production Release: Hitting A Six

cx_Oracle 6.0, 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. It was begun by Anthony Tuininga in 1998 in the era of Oracle Database 8i and Python 1.5. Since then there have been over 30 releases covering up to Oracle Database 12c and Python 3. Anthony joined Oracle relatively recently. In his time...

Monday, August 14, 2017 | python | Read More