OracleConnection Public Methods
OracleConnection public methods are listed in Table 6-53.
Table 53 OracleConnection Public Methods
| Public Method | Description |
|---|---|
| BeginRequest | Starts an explicit request boundary when using Application Continuity Not available in ODP.NET, Unmanaged Driver |
| BeginSessionlessTransaction | Starts a new sessionless transaction and returns its global transaction identifier Not available in ODP.NET, Unmanaged Driver |
| BeginTransaction | Begins a local transaction (Overloaded) |
| ChangeDatabase | Not Supported |
| ClearEndUserSecurityContext | This method removes the Deep Data Security end-user security context from the database session. Not available in ODP.NET, Unmanaged Driver |
| 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 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 Microsoft Entra ID 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 |
| ResumeSessionlessTransaction | Resumes a sessionless transaction using the provided unique transaction identifier Not Available in ODP.NET, Unmanaged Driver |
| Rollback | Rolls back the local transaction |
| Save(String) | Creates a savepoint in the database |
| SetEndUserSecurityContext | Applies the Deep Data Security end-user security context to a database session Not available in ODP.NET, Unmanaged Driver |
| SetP12 | Sets the Not available in ODP.NET, Unmanaged Driver |
| SetPEM | Sets the Available in ODP.NET Core only |
| 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 |
| SetSSO | Sets the Not available in ODP.NET, Unmanaged Driver |
| SuspendSessionlessTransaction | Suspends the active sessionless transaction immediately from the session. Not available in ODP.NET, Unmanaged Driver |
ToString |
Inherited from System.Object |
| UseAzureTokenAuthentication | Associates the Microsoft Entra ID token authentication settings with the Not available in ODP.NET, Unmanaged Driver |
| UseOciTokenAuthentication | Associates the OCI IAM token authentication settings with the Not available in ODP.NET, Unmanaged Driver |