ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
This package only contains 5 constants used to support conditional compilation of PL/SQL packages that are supported by Oracle, TimesTen Database, and other clients like Oracle Forms.
AUTHID
N/A
Constants
Name
Data Type
Value
IS_ORACLE_SERVER
BOOLEAN
TRUE
IS_ORACLE_CLIENT
BOOLEAN
FALSE
IS_ORACLE_FORMS
BOOLEAN
FALSE
IS_ORACLE_XE
BOOLEAN
FALSE
IS_TIMESTEN
BOOLEAN
FALSE
Dependencies
DBMS_ISCHED
DBMS_SQL
DBMS_UTILITY
DBMS_LOB
DBMS_SYS_MLE
UTL_RECOMP
DBMS_MLE
DBMS_SYS_SQL
Documented
Yes
First Available
11.1.0.7
Security Model
Owned by SYS with EXECUTE granted to PUBLIC
Source
{ORACLE_HOME}/rdbms/admin/utlident.sql
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 utl_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
