| General Information |
| Note: This package supports conditional compilation of PL/SQL packages that are supported by Oracle, TimesTen Database,
and possibly other clients like Oracle Forms. |
| Source |
{ORACLE_HOME}/rdbms/admin/utlident.sql |
| First Available |
11.1.0.7 |
| Constants |
| Name |
Data Type |
Value |
| IS_ORACLE_SERVER |
BOOLEAN |
TRUE |
| IS_ORACLE_CLIENT |
BOOLEAN |
FALSE |
| IS_ORACLE_FORMS |
BOOLEAN |
FALSE |
| IS_TIMESTEN |
BOOLEAN |
FALSE |
|
| Dependencies |
| DBMS_LOB |
DBMS_SYS_SQL |
UTL_RECOMP |
| DBMS_SQL |
DBMS_UTILITY |
|
|
| Security Model |
Execute is granted to PUBLIC |
| |
| RDBMS/ADMIN Examples |
| DBMS_SQL Usage |
$if utl_ident.is_oracle_server <> TRUE and
utl_ident.is_timesten <> TRUE $then
$error 'dbms_sql is not supported in this environment' $end
$end
$if utl_ident.is_oracle_server $then
type Blob_Table is table of Blob index by binary_integer;
type Clob_Table is table of Clob index by binary_integer;
type Bfile_Table is table of Bfile index by binary_integer;
$else
/* LOB datatypes are not supported */
$end
$if uutl_ident.is_oracle_server $then
TYPE Urowid_Table IS TABLE OF urowid INDEX BY binary_integer;
$else
/* urowid is not supported in this environment */
$end
$if utl_ident.is_oracle_server $then
TYPE time_with_time_zone_Table IS TABLE OF TIME_TZ_UNCONSTRAINED INDEX BY binary_integer;
TYPE timestamp_with_time_zone_Table IS TABLE OF TIMESTAMP_TZ_UNCONSTRAINED INDEX BY binary_integer;
TYPE timestamp_with_ltz_Table IS TABLE OF TIMESTAMP_LTZ_UNCONSTRAINED INDEX BY binary_integer;
$else
/* time zone features not supported in this environment */
$end
$if utl_ident.is_oracle_server $then
procedure bind_variable(c in integer, name in varchar2, value in blob);
pragma restrict_references(bind_variable,WNDS);
procedure bind_variable(c in integer, name in varchar2, value in clob character set any_cs);
pragma restrict_references(bind_variable,WNDS);
procedure bind_variable(c in integer, name in varchar2, value in bfile);
pragma restrict_references(bind_variable,WNDS);
$else
/* LOB overloads are not supported */
$end
|
| DBMS_UTIL Usage |
$if utl_ident.is_oracle_server <> TRUE and utl_ident.is_timesten <> TRUE $then
$error 'dbms_utility is not supported in this environment' $end
$end |
| UTL_RECOMP Usage |
$if utl_ident.is_oracle_server <> TRUE and utl_ident.is_timesten <> TRUE $then
$error 'utl_recomp is not supported in this environment' $end
$end
$if utl_ident.is_oracle_server $then
PROCEDURE parallel_slave(flags PLS_INTEGER);
$else
/* parallel_slave is not supported */
$end |
