Back to files

Open Source Python/Oracle Utility - cx_Oracle

cx_Oracle is a Python extension module that allows access to Oracle and conforms to the Python database API 2.0 specifications with a few exceptions.

See http://www.python.org/topics/database/DatabaseAPI-2.0.html for more information on the Python database API specification.

For comments, contact Anthony Tuininga at anthony@computronix.com or use the mailing list at http://lists.sourceforge.net/lists/listinfo/cx-oracle-users

BINARY INSTALL:
Place the file cx_Oracle.pyd or cx_Oracle.so anywhere on your Python path.

SOURCE INSTALL:
This module has been built with Oracle 8.1.7, 9.2.0 and 10.1.0 on Linux, Solaris, HP/UX, Tru64 Unix and Windows. It will likely build on other platforms and other Oracle versions but I haven't tried them. Use the provided setup.py to build and install the module which makes use of the distutils module. Note that on Windows, I have used mingw32 (http://www.mingw.org) and the module will not build with MSVC without modification.

USAGE EXAMPLE:

import cx_Oracle

# connect via SQL*Net string or by each segment in a separate argument #connection = cx_Oracle.connect("user/password@TNS") connection = cx_Oracle.connect("user", "password", "TNS")

cursor = connection.cursor()
cursor.arraysize = 50
cursor.execute("""

        select Col1, Col2, Col3
        from SomeTable
        where Col4 = :arg_1
          and Col5 between :arg_2 and :arg_3""",
        arg_1 = "VALUE",
        arg_2 = 5,
        arg_3 = 15)

for column_1, column_2, column_3 in cursor.fetchall():

print "Values:", column_1, column_2, column_3

EXCEPTIONS

A couple of exceptions to the API specification as these reference features that I have never used or represent difficulties with the API specification:

1. The cursor method nextset() Not supported by Oracle.
2. The constructor Binary() Not implemented. Simply pass a string where a binary value is required and use setinputsizes(value = cx_Oracle.BINARY) or setinputsizes(value = cx_Oracle.LONG_BINARY) to indicate that a binary value is being passed.

Please see the included documentation for additional information.