228 UTL_IDENT

The UTL_IDENT package specifies which Database or client PL/SQL is running.

This chapter contains the following topics:


Using UTL_IDENT

This section contains topics which relate to using the UTL_IDENT package.


Overview

The UTL_IDENT package is intended for use for conditional compilation of PL/SQL packages that are supported by Oracle, TimesTen Database, and clients such as Oracle Forms.


Security Model

The UTL_IDENT package runs as the package owner SYS. The public synonym UTL_IDENT, and EXECUTE permission on this package is granted to PUBLIC.


Constants

The UTL_IDENT package uses the constants shown in Table 228-1, "UTL_IDENT Constants".

Table 228-1 UTL_IDENT Constants

Constant Type Value Description

IS_ORACLE_SERVER

BOOLEAN

TRUE/FALSE

Stipulates if Oracle Server or not

IS_ORACLE_CLIENT

BOOLEAN

TRUE/FALSE

Stipulates if Oracle Client or not

IS_TIMESTEN

BOOLEAN

TRUE/FALSE

Stipulates if TimesTen or not

IS_ORACLE_FORMS

BOOLEAN

TRUE/FALSE

Stipulates if Oracle Forms or not