Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)

Part Number E25788-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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

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