Skip Headers

Oracle® Objects for OLE Developer's Guide
Release 9.2.0.4

Part Number B10952-01
Go To Table Of Contents
Contents

OraDatabase Object

See Also
Properties
Methods

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 the 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 the 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

Note: If the AutoCommit property is set to True, transactions are committed automatically and you do not need to use the transactions control methods.


 
Oracle
Copyright © 1994, 2003 Oracle Corporation.

All Rights Reserved.
Go To Table Of Contents
Contents