OraDatabase Object

Description

An OraDatabase interface represents a user session to an Oracle database and provides methods for SQL and PL/SQL execution.

Remarks

An OraDatabase interface in Oracle8i and higher releases adds additional methods for controlling transactions and creating interfaces representing instances of Oracle object types. Attributes of schema objects can be retrieved using the Describe method of the OraDatabase interface.

In previous releases, an OraDatabase object is created by invoking the OpenDatabase method of an OraSession interface. The network alias, user name, and password are passed as arguments to this method. In Oracle8i and higher releases, invocation of this method results in implicit creation of an OraServer object.

As described in the OraServer interface description, an OraDatabase object can also be created using the OpenDatabase method of the OraServer interface.

Transaction control methods are available at the OraDatabase (user session) level. These methods include:

• BeginTrans

• CommitTrans

• Rollback

For example:

MyDatabase.BeginTrans 
MyDatabase.ExecuteSQL("delete from emp where empno = 1234") 
MyDatabase.CommitTrans 

Properties

• AutoCommit Property

• CacheMaximumSize Property

• CacheOptimalSize Property

• Connect Property

• Connection Property

• ConnectionOK Property

• DatabaseName Property

• LastServerErr Property

• LastServerErrPos Property

• LastServerErrText Property

• Options Property

• Server Property

• Parameters Property

• RDMSVersion Property

• Subscriptions Property

Methods

• BeginTrans Method

• Close Method

• CommitTrans Method

• CreateAQ Method

• CreateCustomDynaset Method

• CreateTempBLOB/CLOB Method

• CreateDynaset Method

• CreateOraObject (OraDatabase) Method

• CreateSQL Method

• Describe Method

• ExecuteSQL Method

• FetchOraRef Method

• LastServerErrReset Method

• MonitorForFailover Method

• Open (OraServer) Method

• RemoveFromPool Method

• Rollback Method