227 UTL_IDENT

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

This chapter contains the following topics:

Using UTL_IDENT
- Overview
- Security Model
- Constants

Using UTL_IDENT

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

Overview
Security Model
Constants

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 227-1, "UTL_IDENT Constants".

Table 227-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