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

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, and so on.

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

PACKAGE TT_DB_VERSION IS
   VERSION CONSTANT PLS_INTEGER := 1121; -- major release number
   RELEASE CONSTANT PLS_INTEGER := 9;  -- 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.9.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

9

Current minor release of the Oracle TimesTen In-Memory Database.

Notes:

  • 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 that package and TT_DB_VERSION for conditional compilation.