OracleConnection Public Methods

OracleConnection public methods are listed in Table 6-51.

Table 6-51 OracleConnection Public Methods

Public Method Description

BeginRequest

Starts an explicit request boundary when using Application Continuity

Not available in ODP.NET, Unmanaged Driver

BeginTransaction

Begins a local transaction (Overloaded)

ChangeDatabase

Not Supported

Clone

Creates a copy of an OracleConnection object

Close

Closes the database connection

CreateCommand

Creates and returns an OracleCommand object associated with the OracleConnection object

CreateObjRef

Inherited from System.MarshalByRefObject

Commit()

Commits the database transaction

DisableReplay

Disables replay on the connection in Application Continuity

Not available in ODP.NET, Unmanaged Driver

Dispose

Inherited from System.ComponentModel.Component

EndRequest

Indicates an ending explicit request boundary when using Application Continuity

Not available in ODP.NET, Unmanaged Driver

EnlistDistributedTransaction

Enables applications to explicitly enlist in a specified distributed transaction

Not supported in ODP.NET Core

EnlistTransaction

Enables applications to enlist in a specified distributed transaction

Equals

Inherited from System.Object (Overloaded)

FlushCache

Flushes all updates and deletes made through REF objects retrieved using this connection

Not Available in ODP.NET, Managed Driver and ODP.NET Core

GetHashCode

Inherited from System.Object

GetLifetimeService

Inherited from System.MarshalByRefObject

GetSchema

Returns schema information for the data source of the OracleConnection

GetSessionInfo

Returns or refreshes the property values of the OracleGlobalization object that represents the globalization settings of the session (Overloaded)

GetType

Inherited from System.Object

InitializeLifetimeService

Inherited from System.MarshalByRefObject

Open

Opens a database connection with the property settings specified by the ConnectionString

OpenAsync

Returns a Task-based asynchronous version of OracleConnection.Open (Overloaded)

OpenWithNewClientSecret

Opens a new connection using a new Azure AD client secret

Not available in ODP.NET, Unmanaged Driver

OpenWithNewPassword

Opens a new connection with the new password (Overloaded)

OpenWithNewPasswordAsync

A Task-based asynchronous version of OracleConnection.OpenWithNewPassword(), which opens a new connection with the new password. (Overloaded)

OpenWithNewToken

This method can be used to open a new connection by providing the refreshed/updated access token directly to ODP.NET (Overloaded)

PurgeStatementCache

Flushes the Statement Cache by closing all open cursors on the database, when statement caching is enabled

Rollback

Rolls back the local transaction

Save(String)

Creates a savepoint in the database

SetSessionInfo

Alters the session's globalization settings with the property values provided by the OracleGlobalization object

SetShardingKey(OracleShardingKey, OracleShardingKey)

Enables applications to set the sharding key and super sharding key before requesting a connection

ToString

Inherited from System.Object

UseAzureTokenAuthentication

Associates the Azure Active Directory token authentication settings with the OracleConnection object for use upon the next connection open

Not available in ODP.NET, Unmanaged Driver

UseOciTokenAuthentication

Associates the OCI IAM token authentication settings with the OracleConnection object for use upon the next connection open.

Not available in ODP.NET, Unmanaged Driver