8 TT_DB_VERSION

The TT_DB_VERSION package indicates the TimesTen version numbers.

This chapter contains the following topics

• Using TT_DB_VERSION

  • Overview

  • Constants

  • Examples

---

Using TT_DB_VERSION

• Overview

• Constants

• Examples

---

Overview

The TT_DB_VERSION package indicates the TimesTen major release (VERSION) and minor release (RELEASE) version numbers. For any TimesTen 11.2.1.x release, the VERSION value is 1121. Depending on the minor release, the RELEASE value would be 0, 1, 2, etc.

The package for Oracle TimesTen In-Memory Database Release 11.2.1.4.0 is as follows:

PACKAGE TT_DB_VERSION IS
   VERSION CONSTANT PLS_INTEGER := 1121; -- major release number
   RELEASE CONSTANT PLS_INTEGER := 4;  -- minor release number
END TT_DB_VERSION;

---

Constants

The TT_DB_VERSION package contains different constant values for different TimesTen releases. The Oracle TimesTen In-Memory Database Release 11.2.1.4.0 version of the TT_DB_VERSION package has the values shown in Table 8-1.

Table 8-1 TT_DB_VERSION constants

Name	Type	Value	Description
VERSION	BINARY_INTEGER	1121	Current major release of the Oracle TimesTen In-Memory Database.
RELEASE	BINARY_INTEGER	4	Current minor release of the Oracle TimesTen In-Memory Database.

Note:

Notes on data types:

• The PLS_INTEGER and BINARY_INTEGER data types are identical. This document uses "BINARY_INTEGER" to indicate data types in reference information (such as for table types, record types, subprogram parameters, or subprogram return values), but may use either in discussion and examples.

• The INTEGER and NUMBER(38) data types are also identical. This document uses "INTEGER" throughout.

---

Examples

See "Examples" in the UTL_IDENT chapter for an example that uses both packages for conditional compilation.