1.1 Constants

apilevel
String constant stating the supported DB API level. Currently '2.0'.

buildtime
String constant stating the time when the binary was built.

NOTE: This attribute is an extension to the DB API definition.

BINARY
This type object is used to describe columns in a database that are binary (in Oracle this is RAW columns).

BLOB
This type object is used to describe columns in a database that are BLOBs.

NOTE: This attribute is an extension to the DB API definition.

CLOB
This type object is used to describe columns in a database that are CLOBs.

NOTE: This attribute is an extension to the DB API definition.

CURSOR
This type object is used to describe columns in a database that are cursors (in PL/SQL these are known as ref cursors).

NOTE: This attribute is an extension to the DB API definition.

DATETIME
This type object is used to describe columns in a database that are dates.

FIXED_CHAR
This type object is used to describe columns in a database that are fixed length strings (in Oracle this is CHAR columns); these behave differently in Oracle than varchar2 so they are differentiated here even though the DB API does not differentiate them.

NOTE: This attribute is an extension to the DB API definition.

FNCODE_BINDBYNAME
This constant is used to register callbacks on the OCIBindByName() function of the OCI.

NOTE: This attribute is an extension to the DB API definition.

FNCODE_BINDBYPOS
This constant is used to register callbacks on the OCIBindByPos() function of the OCI.

NOTE: This attribute is an extension to the DB API definition.

FNCODE_DEFINEBYPOS
This constant is used to register callbacks on the OCIDefineByPos() function of the OCI.

NOTE: This attribute is an extension to the DB API definition.

FNCODE_STMTEXECUTE
This constant is used to register callbacks on the OCIStmtExecute() function of the OCI.

NOTE: This attribute is an extension to the DB API definition.

FNCODE_STMTFETCH
This constant is used to register callbacks on the OCIStmtFetch() function of the OCI.

NOTE: This attribute is an extension to the DB API definition.

FNCODE_STMTPREPARE
This constant is used to register callbacks on the OCIStmtPrepare() function of the OCI.

NOTE: This attribute is an extension to the DB API definition.

LOB
This type object is the Python type of BLOB and CLOB data that is returned from cursors.

NOTE: This attribute is an extension to the DB API definition.

LONG_BINARY
This type object is used to describe columns in a database that are long binary (in Oracle these are LONG RAW columns).

NOTE: This attribute is an extension to the DB API definition.

LONG_STRING
This type object is used to describe columns in a database that are long strings (in Oracle these are LONG columns).

NOTE: This attribute is an extension to the DB API definition.

NUMBER
This type object is used to describe columns in a database that are numbers.

OPT_NumbersAsStrings
This attribute is not present in a default installation of cx_Oracle and must be added externally. Its presence indicates that queries executed which return numbers should return them as strings, and not as integers or floating point numbers. This is useful to get around the fact that Oracle floating point numbers have considerably greater precision than C floating point numbers and not require a change to the SQL being executed.

NOTE: This attribute is an extension to the DB API definition.

paramstyle
String constant stating the type of parameter marker formatting expected by the interface. Currently 'named' as in 'where name = :name'.

ROWID
This type object is used to describe the pseudo column "rowid".

STRING
This type object is used to describe columns in a database that are strings (in Oracle this is VARCHAR2 columns).

SYSDBA
Value to be passed to the connect() method which indicates that SYSDBA access is to be acquired. See the Oracle documentation for more details.

NOTE: This attribute is an extension to the DB API definition.

SYSOPER
Value to be passed to the connect() method which indicates that SYSOPER access is to be acquired. See the Oracle documentation for more details.

NOTE: This attribute is an extension to the DB API definition.

threadsafety
Integer constant stating the level of thread safety that the interface supports. Currently 2, which means that threads may share the module and connections, but not cursors. Sharing means that a thread may use a resource without wrapping it using a mutex semaphore to implement resource locking.

Note that in order to make use of multiple threads in a program which intends to connect and disconnect in different threads, the threaded argument to the Connection constructor must be a true value. See the comments on the Connection constructor for more information (1).

TIMESTAMP
This type object is used to describe columns in a database that are timestamps.

NOTE: This attribute is an extension to the DB API definition and is only available in Oracle 9i.

UCBTYPE_ENTRY
This constant is used to register callbacks on entry to the function of the OCI. In other words, the callback will be called prior to the execution of the OCI function.

NOTE: This attribute is an extension to the DB API definition.

UCBTYPE_EXIT
This constant is used to register callbacks on exit from the function of the OCI. In other words, the callback will be called after the execution of the OCI function.

NOTE: This attribute is an extension to the DB API definition.

UCBTYPE_REPLACE
This constant is used to register callbacks that completely replace the call to the OCI function.

NOTE: This attribute is an extension to the DB API definition.

version
String constant stating the version of the module. Currently '4.1'.

NOTE: This attribute is an extension to the DB API definition.