Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
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_ISCHEDFW
DBMS_SQL
DBMS_UTILITY
DBMS_LOB
DBMS_SYS_MLE
PRVT_UTILITY
DBMS_MLE
DBMS_SYS_SQL
UTL_RECOMP
DBMS_OUTPUT
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