OraDatabase interface represents a user session to an Oracle database and provides methods for SQL and PL/SQL execution.
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
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
As described in the
OraServer interface description, an
OraDatabase object can also be created using the
OpenDatabase method of the
Transaction control methods are available at the
OraDatabase (user session) level. These methods include:
MyDatabase.BeginTrans MyDatabase.ExecuteSQL("delete from emp where empno = 1234") MyDatabase.CommitTrans
AutoCommitproperty is set to
True, transactions are committed automatically, and you do not need to use the transaction control methods.