Oracle UTL_IDENT
Version 18.1.0.0

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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 (Updated to 12.2.0.1)
DBMS_ISCHED DBMS_SQL DBMS_UTILITY
DBMS_LOB DBMS_SYS_SQL UTL_RECOMP
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

Related Topics
DBMS_DB_VERSION
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved