Oracle UTL_IDENT
Version 19.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
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 18c
What's New In 19c

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