The UTL_IDENT package specifies which Database or client PL/SQL is running.
This chapter contains the following topics:
Overview
Security Model
Constants
This section contains topics which relate to using the UTL_IDENT package.
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.
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.
The UTL_IDENT package uses the constants shown in Table 255-1, "UTL_IDENT Constants".
Table 255-1 UTL_IDENT Constants
| Constant | Type | Value | Description |
|---|---|---|---|
|
|
|
|
Stipulates if Oracle Server or not |
|
|
|
|
Stipulates if Oracle Client or not |
|
|
|
|
Stipulates if TimesTen or not |
|
|
|
|
Stipulates if Oracle Forms or not |