Description
The Oracle O84 database interface has been enhanced to provide support for new functionality in Oracle8i, in addition to the support it already provides for Oracle 8.0.x.
Usage
Transaction server support The enhanced O84 database interface now supports database transactions for PowerBuilder custom class user objects deployed as EAServer or MTS components. The revised O84 Database Profile Setup dialog box includes a EAServer/MTS tab that you can use to set the relevant connection options. These are the new transactional DBParms:
|
DBParm
|
Relevant when a component is deployed to
|
|
UseContextObject
|
EAServer or MTS
|
|
CacheName
|
EAServer only
|
|
GetConnectionOption
|
EAServer only
|
|
ReleaseConnectionOption
|
EAServer only
|
|
OraMTSConFlgs
|
MTS only
|
Transactional support in MTS A component deployed to MTS can only participate in a database transaction when connecting to an Oracle8i database server and when Oracle Services for Microsoft Transaction Server are installed and configured.
Failover support The enhanced O84 database interface now supports failover when connecting to an Oracle8i database server. Four new DBParms allow you to customize failover behavior. These DBParms are set via the Network tab. These are the new failover DBParms:
|
DBParm
|
Description
|
|
SvrFailover
|
Select to enable failover
|
|
FoDialog
|
Select to display runtime dialog when failing over
|
|
FoRetryCount
|
Default is 10
|
|
FoDelay
|
Default is 10
|
Support for asynchronous operations The enhanced O84 database interface also supports asynchronous DataWindow retrieval when connecting to an Oracle8i database server. Asynchronous operation is set using two DBParms (Async and DBGetTime) on the Transaction tab.
General enhancements The enhanced O84 database interface, as well as the O73 database interface, now supports several new DBParms that customize and enhance database connections:
|
DBParm
|
Description
|
|
NumbersInternal
|
Retrieves numbers from the database using Oracle's internal 21-byte binary NUMBER data type instead of using OCI strings (Supported by the O84 interface only)
Set via the Syntax tab
|
|
PackageProcs
|
Appends package stored procedures and functions to the lists of standalone stored procedures and functions displayed in the DataWindow and Database painters
Set via the System tab
|
|
PWDialog
|
Controls whether a Password Expired dialog box displays in a PowerBuilder application at execution time
Set via the Connection tab
|
|
QualifyPublic
|
Retains the PUBLIC qualifier in the SQL Select table list, securing the association with PowerBuilder's extended attributes
Set via the System tab
|
For more information
See the DBParm description in the online Help for:
Async
CacheName
DBGetTime
FoDelay
FoDialog
FoRetryCount
GetConnectionOption
NumbersInternal
OraMTSConFlgs
PackageProcs
PWDialog
QualifyPublic
ReleaseConnectionOption
SvrFailover
UseContextObject
For information about new DBParms, select the What's New button on the Help window and select New DBParms.
|
