CX_ORACLE DOCUMENTATION PDF

call and is available as the Variable. type for variables containing Oracle objects. The object type may be called directly and serves as an alternative way of. Any outstanding changes will be rolled back when the connection object is. If None or the same string object is passed in again, the cursor will execute that.

Author: Malaktilar Vudojar
Country: Belize
Language: English (Spanish)
Genre: Science
Published (Last): 11 July 2018
Pages: 22
PDF File Size: 9.17 Mb
ePub File Size: 5.19 Mb
ISBN: 860-7-90752-382-9
Downloads: 33217
Price: Free* [*Free Regsitration Required]
Uploader: Taumuro

No attributes cx_oravle currently supported so all attributes will silently ignore being set and will always appear to have the value None. Return the version of the client library being used as a 5-tuple. The five values are the major version, minor documnetation, update number, patch number and port update number. Constructor for creating a connection to the database. Return a connection object.

All parameters are optional and can be specified as keyword parameters.

Module Interface — cx_Oracle documentation

The dsn data source name is the TNS entry from the Oracle names server or tnsnames. The pool parameter is expected to be a session pool object and the use of this parameter is the equivalent of calling SessionPool. Parameters not acecpted documentatlon that method are ignored. The threaded parameter is expected to be a boolean expression which indicates whether or not Oracle should wrap accesses to connections with a mutex.

The events parameter is expected to be a boolean expression which indicates whether or documentattion to initialize Oracle in events mode. This is required for continuous query notification and high availablity event notifications. The cclass parameter is expected to be a string and defines the connection class for database resident connection pooling DRCP. The newpassword parameter is expected to be a string if specified and sets the password for the logon during the connection process.

The encoding parameter is expected to be a documenattion if specified and sets the encoding to use for regular database strings. The nencoding parameter is expected to be a string if specified and sets the encoding to use for national character set database strings. The edition parameter is expected to be a string if specified and sets the edition to use for documentatikn session. It is only relevant if both the client and the cd_oracle are at least Oracle Database The appcontext parameter is expected to be a list of 3-tuples, if specified, and sets the application context for the connection.

Each entry in the list is expected to contain three strings: The tag parameter, if specified, is expected to be a string and will documentatoon the sessions that can be returned from a session pool cx_oraccle the matchanytag parameter is cx_oarcle to True. In that case sessions with the specified tag will be preferred over others, but if no such sessions are available a session with a different tag may be returned instead.

In any case, untagged sessions will always be returned if no sessions with the specified tag are available. Sessions are tagged when they are released back to the pool. The shardingkey and supershardingkey parameters, if specified, are expected to be a sequence of values which will be used to identify the database shard to connect to. Currently only strings are supported for the key values.

Constructor for creating a cursor. Return a new cursor object using the connection. Construct an object holding a date value from the given ticks value number of seconds since the epoch; see the documentatjon of the standard Python time module for details.

Return a string suitable for use as the dsn parameter for connect. This string is identical to the strings that are defined by the Oracle names server or documentatioj in the tnsnames. Create and return a session pool object. This allows for very fast connections to the database and is of primary use in a server where dlcumentation same connection is being made multiple times in rapid succession a web server, for example.

  APAREAMIENTO DE BASES NITROGENADAS PDF

If the connection type is specified, all calls to acquire will create connection objects of that type, rather than the base type defined at the module level.

Welcome to cx_Oracle’s documentation! — cx_Oracle documentation

The threaded parameter is expected to be a boolean expression which indicates whether Oracle should wrap accesses to connections with a mutex. The encoding parameter is expected to be a string, if specified, and sets the encoding to use for regular database strings. The nencoding parameter is expected to be a string, cocumentation specified, and sets the encoding to use for national character set database strings. The edition parameter is expected to be a string, if specified, and sets the edition to use for the sessions in the pool.

Documehtation is only relevant if both the client and the server are docmentation least Oracle Database The timeout parameter docukentation expected to be an integer, if specified, and sets the length of time in seconds after which idle sessions in the pool are terminated.

Note that termination only occurs when the pool is accessed. The default value of 0 means that no idle sessions are terminated. The waitTimeout parameter is expected to be an integer, if specified, and sets the length of time in milliseconds that the caller should wait for a session to become available in the pool before returning with an error.

The maxLifetimeSession parameter is expected to be an integer, if specified, and sets the maximum length of time in seconds a pooled session may exist. Sessions that are in use will not be closed.

They become candidates for termination only when they are released back to the pool and have existed for longer than maxLifetimeSession seconds. The default value is 0 which means that there is no maximum length of time that a pooled session may exist.

The time only data type is not supported by Oracle. Calling this function will raise a NotSupportedError exception. Construct an object holding a time value from the given ticks value number of seconds since the epoch; see the documentation of the standard Python time module for details.

Construct an object holding a time stamp value from the given ticks value number of seconds since the epoch; see the documentation of the standard Python time module for details.

String constant stating the type of parameter marker formatting expected by the interface.

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 parameter to connect or SessionPool must be true. They are possible values for the deliverymode attribute of the dequeue options object passed as the options parameter to the Connection. They are also possible values for the deliverymode attribute of the message properties object passed as the msgproperties parameter to the Connection.

This is the default value. This constant is used to specify that dequeue operations should dequeue either persistent or buffered messages.

They are possible values for the mode attribute of the dequeue options object. This object is the options parameter for the Connection.

This constant is used to specify that dequeue should read the message without acquiring any lock on the message eqivalent to a select statement.

This constant is used to specify that dequeue should read and obtain a write lock on the message for the duration of the transaction cx_orwcle to a select for update statement. This constant is used to specify that dequeue should read the message and update or delete it. This constant is used to specify that dequeue should confirm receipt of the message but not deliver the actual message content.

  ESPERANZA BY CAROL GAAB PDF

They are possible values for the navigation attribute of the dequeue options object. This constant is used to specify that dequeue should retrieve the first available message that matches the search criteria.

This resets the position to the beginning of the queue. This constant is used to specify that dequeue should retrieve the next available message that matches the search criteria. If the previous message belongs to a message group, AQ retrieves the next available message cx_orcle matches the search criteria and belongs to the message group. This is the default. This constant is used documentatipn specify that dequeue should skip the remainder of the transaction group and retrieve the first message of the next transaction group.

This option can only be used if message grouping is enabled for the current queue. They are possible values for the visibility attribute of the dequeue options object. This constant is used to specify documentatioj dequeue should perform its work as part of an independent transaction. This constant is used to specify that dequeue should be part of the current transaction.

They are possible values for the wait attribute of the dequeue options object. This constant is used to specify that dequeue not wait for messages to be available for dequeuing. This dx_oracle is used to specify that dequeue should wait forever for cx_orace to be available for dequeuing.

They are possible values for the visibility attribute of documenntation enqueue options object. This constant is used to specify that enqueue should perform eocumentation work as part of an independent transaction.

This constant is used to specify that enqueue should be part of the current transaction. They are possible values for the state attribute of the message properties object.

This object is the msgproperties parameter for the Connection. They are special constants used in documentatiob queuing. This constant is a possible xc_oracle for the delay attribute of the message properties object passed as the msgproperties parameter to the Connection. It specifies that no delay should be imposed and the message should be immediately available for dequeuing. This is also the default value. This constant is a possible value for the expiration attribute of the message properties object passed as the msgproperties parameter to the Connection.

Python cx_Oracle 7 Introduces SODA Document Storage

It specifies that the message never expires. They are possible values for the mode parameter of the connect method. This constant is used to specify that preliminary authentication is to be used. This is needed for performing database startup and shutdown. They are possible values for the mode parameter of the Connection. This constant is used to specify that the caller should not wait for current processing to complete or for users to disconnect from the database.

This should only be used in unusual circumstances since database recovery may be necessary upon next startup. This constant is used to specify that the instance can be truly halted. This should only be done after the database has been shutdown with one of the other modes except abort and the database has been closed and dismounted using the appropriate SQL commands.