Oracle UTL_IDENT
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
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_SQL UTL_RECOMP
DBMS_REPCAT_RGT    
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

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-2014 Daniel A. Morgan All Rights Reserved