OraSession Object

Description

An OraSession object manages collections of OraDatabase, OraConnection, and OraDynaset objects used within an application.

Remarks

Typically, a single OraSession object is created for each application, but you can create named OraSession objects for shared use within and between applications.

The OraSession object is the highest level object for an application. OraSession and OraServer objects are the only objects created by the CreateObject Visual Basic or Visual Basic for Applications APIs and not by an Oracle Objects for OLE method.

Properties

• Client Property

• Connections Property

• LastServerErr Property

• LastServerErrText Property

• Name Property

• OIPVersionNumber Property

• DbPoolCurrentSize Property

• DbPoolInitialSize Property

• DbPoolMaxSize Property

Methods

• BeginTrans Method

• ChangePassword (OraSession) Method

• CommitTrans Method

• ConnectSession Method

• CreateDatabasePool Method

• CreateNamedSession Method

• CreateOraIntervalDS Method

• CreateOraIntervalYM Method

• CreateOraNumber Method

• CreateOraTimeStamp Method

• CreateOraTimeStampTZ Method

• DestroyDatabasePool Method

• GetDatabaseFromPool Method

• OpenDatabase Method

• LastServerErrReset Method

• ResetTrans Method

• Rollback Method

Examples

The following code fragments show how to create an OraSession object:

Dim oo4oSession as Object
Set oo4oSession = CreateObject("OracleInProcServer.XOraSession")
 

or

Dim oo4oSession as New OraSessionClass 

or

Dim oo4oSession as OraSession 
Set oo4oSession = New OraSessionClass