Deprecations¶

The following tables contains all of the deprecations in the cx_Oracle API, when they were first deprecated and a comment on what should be used instead, if applicable. The most recent deprecations are listed first.

Table 2 Deprecated in 8.2¶
Name	Comments
encoding parameter to `cx_Oracle.connect()`	No longer needed as the use of encodings other than UTF-8 is deprecated. Encoding is handled internally between cx_Oracle and Oracle Database.
nencoding parameter to `cx_Oracle.connect()`	No longer needed as the use of encodings other than UTF-8 is deprecated.
encoding parameter to `cx_Oracle.SessionPool()`	No longer needed as the use of encodings other than UTF-8 is deprecated.
nencoding parameter to `cx_Oracle.SessionPool()`	No longer needed as the use of encodings other than UTF-8 is deprecated.
Connection.maxBytesPerCharacter	No longer needed as the use of encodings other than UTF-8 is deprecated. The constant value 4 can be used instead.
Positional parameters to `cx_Oracle.connect()`	Replace with keyword parameters in order to comply with the Python database API.
Positional parameters to `cx_Oracle.SessionPool()`	Replace with keyword parameters in order to comply with the Python database API.
threaded parameter to `cx_Oracle.SessionPool()`	The value of this parameter is ignored. Threading is now always used.
waitTimeout parameter to `cx_Oracle.SessionPool()`	Replace with parameter name wait_timeout
maxLifetimeSession parameter to `cx_Oracle.SessionPool()`	Replace with parameter name max_lifetime_session
sessionCallback parameter to `cx_Oracle.SessionPool()`	Replace with parameter name session_callback
maxSessionsPerShard parameter to `cx_Oracle.SessionPool()`	Replace with parameter name max_sessions_per_shard
SessionPool.tnsentry	Replace with `SessionPool.dsn`
payloadType parameter to `Connection.queue()`	Replace with parameter name payload_type if using keyword parameters.
ipAddress parameter to `Connection.subscribe()`	Replace with parameter name ip_address
groupingClass parameter to `Connection.subscribe()`	Replace with parameter name grouping_class
groupingValue parameter to `Connection.subscribe()`	Replace with parameter name grouping_value
groupingType parameter to `Connection.subscribe()`	Replace with parameter name grouping_type
clientInitiated parameter to `Connection.subscribe()`	Replace with parameter name client_initiated
Connection.callTimeout	Replace with `Connection.call_timeout`
Connection.tnsentry	Replace with `Connection.dsn`
keywordParameters parameter to `Cursor.callfunc()`	Replace with parameter name keyword_parameters
keywordParameters parameter to `Cursor.callproc()`	Replace with parameter name keyword_parameters
encodingErrors parameter to `Cursor.var()`	Replace with parameter name encoding_errors
Cursor.fetchraw()	Replace with `Cursor.fetchmany()`
newSize parameter to `LOB.trim()`	Replace with parameter name new_size
Queue.deqMany	Replace with `Queue.deqmany()`
Queue.deqOne	Replace with `Queue.deqone()`
Queue.enqMany	Replace with `Queue.enqmany()`
Queue.enqOne	Replace with `Queue.enqone()`
Queue.deqOptions	Replace with `Queue.deqoptions`
Queue.enqOptions	Replace with `Queue.enqoptions()`
Queue.payloadType	Replace with `Queue.payload_type()`
Subscription.ipAddress	Replace with `Subscription.ip_address`
Message.consumerName	Replace with `Message.consumer_name`
Message.queueName	Replace with `Message.queue_name`
Variable.actualElements	Replace with `Variable.actual_elements`
Variable.bufferSize	Replace with `Variable.buffer_size`
Variable.numElements	Replace with `Variable.num_elements`

Table 3 Deprecated in 8.0¶
Name	Comments
cx_Oracle.BFILE	Replace with `cx_Oracle.DB_TYPE_BFILE`
cx_Oracle.BLOB	Replace with `cx_Oracle.DB_TYPE_BLOB`
cx_Oracle.BOOLEAN	Replace with `cx_Oracle.DB_TYPE_BOOLEAN`
cx_Oracle.CLOB	Replace with `cx_Oracle.DB_TYPE_CLOB`
cx_Oracle.CURSOR	Replace with `cx_Oracle.DB_TYPE_CURSOR`
cx_Oracle.FIXED_CHAR	Replace with `cx_Oracle.DB_TYPE_CHAR`
cx_Oracle.FIXED_NCHAR	Replace with `cx_Oracle.DB_TYPE_NCHAR`
cx_Oracle.INTERVAL	Replace with `cx_Oracle.DB_TYPE_INTERVAL_DS`
cx_Oracle.LONG_BINARY	Replace with `cx_Oracle.DB_TYPE_LONG_RAW`
cx_Oracle.LONG_STRING	Replace with `cx_Oracle.DB_TYPE_LONG`
cx_Oracle.NATIVE_FLOAT	Replace with `cx_Oracle.DB_TYPE_BINARY_DOUBLE`
cx_Oracle.NATIVE_INT	Replace with `cx_Oracle.DB_TYPE_BINARY_INTEGER`
cx_Oracle.NCHAR	Replace with `cx_Oracle.DB_TYPE_NVARCHAR`
cx_Oracle.NCLOB	Replace with `cx_Oracle.DB_TYPE_NCLOB`
cx_Oracle.OBJECT	Replace with `cx_Oracle.DB_TYPE_OBJECT`
cx_Oracle.TIMESTAMP	Replace with `cx_Oracle.DB_TYPE_TIMESTAMP`

Table 4 Deprecated in 7.2¶
Name	Comments
Connection.deq()	Replace with `Queue.deqone()` or `Queue.deqmany()`.
Connection.deqoptions()	Replace with attribute `Queue.deqoptions`.
Connection.enq()	Replace with `Queue.enqone()` or `Queue.enqmany()`.
Connection.enqoptions()	Replace with attribute `Queue.enqoptions`.

Table 5 Deprecated in 6.4¶
Name	Comments
Cursor.executemanyprepared()	Replace with `executemany()` with None for the statement argument and an integer for the parameters argument.