User`s guide

Notes:
Remember the following:
■ You can enter the required fields and optional fields in any order
when constructing the open string.
■ All field names are case-insensitive, although their values may or
may not be case-sensitive depending on the system.
■ You may not use the "+" character as part of the actual open string.
Developing an Oracle Database/openUTM Application
openUTM Product Set 8-5
8.4.1.1 Required Fields
The required fields for the open string are:
Item Meaning
Acc Specifies user access information.
P Indicates that explicit user and password information is provided.
user A valid Oracle Database username.
access_info The corresponding current password.
For example, Acc = P/scott/tiger indicates that user and password information is
provided. In this case, the user is
scott and the password is tiger .
For the correct process, ensure that
scott has the SELECT privilege on the DBA_
PENDING_TRANSACTIONS
table.
Item Meaning
SesTm Specifies the maximum amount of time a transaction can be inactive
before it is automatically deleted by the system.
session_time_limit This value should correspond to what you require as a maximum
time from initiation of a global transaction and the completed
commit or rollback of that transaction.
8.4.1.2 Optional Fields
Optional fields for the open string are described in the following table:
Item Meaning
DB Specifies the database name.
db_name Indicates the name used in Oracle Database precompilers to identify
the database.
Application programs that use only the de
fault database for the Oracle
Database precompiler, that is, do not use the AT clause in their SQL
statements, should omit the
DB = db_name clause in the open string.
Note:
This default database is represented in the ORAENV file by ORASID .
Applications that use explicitly–named dat
abases should indicate that
database name in their
DB = db_name field.
For example,
DB = payroll indicates that the database name is payroll
and that the application server program uses that name in AT clauses.