6.4.6 OracleConnection Public Methods

OracleConnection public methods are listed in Table 6-34.

Table 6-34 OracleConnection Public Methods

Public Method Description

BeginTransaction

Begins a local transaction (Overloaded)

Not supported in a .NET stored procedure for context connection

ChangeDatabase

Not Supported

Clone

Creates a copy of an OracleConnection object

Not supported in a .NET stored procedure

Close

Closes the database connection

CreateCommand

Creates and returns an OracleCommand object associated with the OracleConnection object

CreateObjRef

Inherited from System.MarshalByRefObject

Dispose

Inherited from System.ComponentModel.Component

EnlistDistributedTransaction

Enables applications to explicitly enlist in a specified distributed transaction

Not supported in a .NET stored procedure

EnlistTransaction

Enables applications to enlist in a specified distributed transaction

Not supported in a .NET stored procedure

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

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

OpenWithNewPassword

Opens a new connection with the new password

Not supported in a .NET stored procedure for context connection

PurgeStatementCache

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

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

Not available in ODP.NET, Managed Driver

ToString

Inherited from System.Object