1 Introduction to Oracle Supplied PL/SQL Packages & Types

Oracle supplies many PL/SQL packages with the Oracle server to extend database functionality and provide PL/SQL access to SQL features. You can use the supplied packages when creating your applications or for ideas in creating your own stored procedures.

This manual covers the packages provided with the Oracle database server. Packages supplied with other products, such as Oracle Developer or the Oracle Application Server, are not covered.

Note that not every package or type described in this manual or elsewhere in the Oracle Database Documentation Library is installed by default. In such cases, the documentation states this and explains how to install the object. Run this query as a suitably privileged user:

SELECT DISTINCT Owner, Object_Type, Object_Name FROM DBA_Objects_AE
     WHERE Owner IN (
       'SYS', 'OUTLN', 'SYSTEM', 'CTXSYS', 'DBSNMP',
       'LOGSTDBY_ADMINISTRATOR', 'ORDSYS',
       'ORDPLUGINS', 'OEM_MONITOR', 'MDSYS', 'LBACSYS', 
       'DMSYS', 'WMSYS', 'OLAPDBA', 'OLAPSVR', 'OLAP_USER',
       'OLAPSYS', 'EXFSYS', 'SYSMAN', 'MDDATA',
       'SI_INFORMTN_SCHEMA', 'XDB', 'ODM')
     AND Object_Type IN ('PACKAGE', 'TYPE')
     ORDER BY Owner, Object_Type, Object_Name

This lists every Oracle-supplied package and type that is currently installed in the database. Note that it lists a number of objects not mentioned in the Oracle Database Documentation Library. This is deliberate. Some of the Oracle-supplied packages and types are intended to be used only by other Oracle-supplied components. Any package or type that is not described in the Oracle Database Documentation Library is not supported for direct customer use.

This chapter contains the following topics:


Package Overview

A package is an encapsulated collection of related program objects stored together in the database. Program objects are procedures, functions, variables, constants, cursors, and exceptions.


Package Components

PL/SQL packages have two parts: the specification and the body, although sometimes the body is unnecessary. The specification is the interface to your application; it declares the types, variables, constants, exceptions, cursors, and subprograms available for use. The body fully defines cursors and subprograms, and so implements the specification.

Unlike subprograms, packages cannot be called, parameterized, or nested. However, the formats of a package and a subprogram are similar:

CREATE PACKAGE name AS  -- specification (visible part)
   -- public type and item declarations
   -- subprogram specifications
END [name];

CREATE PACKAGE BODY name AS  -- body (hidden part)
   -- private type and item declarations
   -- subprogram bodies
[BEGIN
   -- initialization statements]
END [name];

The specification holds public declarations that are visible to your application. The body holds implementation details and private declarations that are hidden from your application. You can debug, enhance, or replace a package body without changing the specification. You can change a package body without recompiling calling programs because the implementation details in the body are hidden from your application.


Using Oracle Supplied Packages

Most Oracle supplied packages are automatically installed when the database is created. Certain packages are not installed automatically. Special installation instructions for these packages are documented in the individual chapters.

To call a PL/SQL function from SQL, you must either own the function or have EXECUTE privileges on the function. To select from a view defined with a PL/SQL function, you must have SELECT privileges on the view. No separate EXECUTE privileges are needed to select from the view. Instructions on special requirements for packages are documented in the individual chapters.


Creating New Packages

To create packages and store them permanently in an Oracle database, use the CREATE PACKAGE and CREATE PACKAGE BODY statements. You can execute these statements interactively from SQL*Plus or Enterprise Manager.

To create a new package, do the following:

  1. Create the package specification with the CREATE PACKAGE statement.

    You can declare program objects in the package specification. Such objects are called public objects. Public objects can be referenced outside the package, as well as by other objects in the package.

    Note:

    It is often more convenient to add the OR REPLACE clause in the CREATE PACKAGE statement. But note that CREATE PACKAGE warns you if you are about to overwrite an existing package with the same name while CREATE OR REPLACE just overwrites it with no warning.
  2. Create the package body with the CREATE PACKAGE BODY statement.

    You can declare and define program objects in the package body.

Separating the Specification and Body

The specification of a package declares the public types, variables, constants, and subprograms that are visible outside the immediate scope of the package. The body of a package defines the objects declared in the specification, as well as private objects that are not visible to applications outside the package.

Oracle stores the specification and body of a package separately in the database. Other schema objects that call or reference public program objects depend only on the package specification, not on the package body. Using this distinction, you can change the definition of a program object in the package body without causing Oracle to invalidate other schema objects that call or reference the program object. Oracle invalidates dependent schema objects only if you change the declaration of the program object in the package specification.

Creating a New Package: Example

The following example shows a package specification for a package named EMPLOYEE_MANAGEMENT. The package contains one stored function and two stored procedures.

CREATE PACKAGE employee_management AS
   FUNCTION hire_emp (name VARCHAR2, job VARCHAR2,
      mgr NUMBER, hiredate DATE, sal NUMBER, comm NUMBER,
      deptno NUMBER) RETURN NUMBER;
   PROCEDURE fire_emp (emp_id NUMBER);
   PROCEDURE sal_raise (emp_id NUMBER, sal_incr NUMBER);
END employee_management;

The body for this package defines the function and the procedures:

CREATE PACKAGE BODY employee_management AS
   FUNCTION hire_emp (name VARCHAR2, job VARCHAR2,
      mgr NUMBER, hiredate DATE, sal NUMBER, comm NUMBER,
      deptno NUMBER) RETURN NUMBER IS

The function accepts all arguments for the fields in the employee table except for the employee number. A value for this field is supplied by a sequence. The function returns the sequence number generated by the call to this function.

       new_empno    NUMBER(10);

   BEGIN
      SELECT emp_sequence.NEXTVAL INTO new_empno FROM dual;
      INSERT INTO emp VALUES (new_empno, name, job, mgr,
         hiredate, sal, comm, deptno);
      RETURN (new_empno);
   END hire_emp;

   PROCEDURE fire_emp(emp_id IN NUMBER) AS

The procedure deletes the employee with an employee number that corresponds to the argument emp_id. If no employee is found, then an exception is raised.

   BEGIN
      DELETE FROM emp WHERE empno = emp_id;
      IF SQL%NOTFOUND THEN
      raise_application_error(-20011, 'Invalid Employee
         Number: ' || TO_CHAR(emp_id));
   END IF;
END fire_emp;

PROCEDURE sal_raise (emp_id IN NUMBER, sal_incr IN NUMBER) AS

The procedure accepts two arguments. Emp_id is a number that corresponds to an employee number. Sal_incr is the amount by which to increase the employee's salary.

   BEGIN

   -- If employee exists, then update salary with increase.
   
      UPDATE emp
         SET sal = sal + sal_incr
         WHERE empno = emp_id;
      IF SQL%NOTFOUND THEN
         raise_application_error(-20011, 'Invalid Employee
            Number: ' || TO_CHAR(emp_id));
      END IF;
   END sal_raise;
END employee_management;

Note:

If you want to try this example, then first create the sequence number emp_sequence. You can do this using the following SQL*Plus statement:
SQL> CREATE SEQUENCE emp_sequence
   > START WITH 8000 INCREMENT BY 10;


Referencing Package Contents

To reference the types, items, and subprograms declared in a package specification, use the dot notation. For example:

package_name.type_name
package_name.item_name
package_name.subprogram_name

Summary of Oracle Supplied PL/SQL Packages and Types

Table 1-1 lists the supplied PL/SQL server packages. These packages run as the invoking user, rather than the package owner. Unless otherwise noted, the packages are callable through public synonyms of the same name.

Caution:

  • The procedures and functions provided in these packages and their external interfaces are reserved by Oracle and are subject to change.

  • Modifying Oracle supplied packages can cause internal errors and database security violations. Do not modify supplied packages.

Table 1-1 Summary of Oracle Supplied PL/SQL Packages

Package Name Description

APEX_CUSTOM_AUTH

Provides an interface for authentication and session management

APEX_APPLICATION

Enables users to take advantage of global variables

APEX_ITEM

Enables users to create form elements dynamically based on a SQL query instead of creating individual items page by page

APEX_UTIL

Provides utilities for getting and setting session state, getting files, checking authorizations for users, resetting different states for users, and also getting and setting preferences for users

CTX_ADM

Lets you administer servers and the data dictionary

CTX_CLS

Lets you generate CTXRULE rules for a set of documents

CTX_DDL

Lets you create and manage the preferences, section lists and stopgroups required for Text indexes

CTX_DOC

Lets you request document services

CTX_OUTPUT

Lets you manage the index log

CTX_QUERY

Lets you generate query feedback, count hits, and create stored query expressions

CTX_REPORT

Lets you create various index reports

CTX_THES

Lets you to manage and browse thesauri

CTX_ULEXER

For use with the user-lexer

DBMS_ADDM

Facilitates the use of Advisor functionality regarding the Automatic Database Diagnostic Monitor

DBMS_ADVANCED_REWRITE

Contains interfaces for advanced query rewrite users to create, drop, and maintain functional equivalence declarations for query rewrite

DBMS_ADVISOR

Part of the SQLAccess Advisor, an expert system that identifies and helps resolve performance problems relating to the execution of SQL statements

DBMS_ALERT

Provides support for the asynchronous notification of database events

DBMS_APPLICATION_INFO

Lets you register an application name with the database for auditing or performance tracking purposes

DBMS_APPLY_ADM

Provides administrative procedures to start, stop, and configure an apply process

DBMS_AQ

Lets you add a message (of a predefined object type) onto a queue or to dequeue a message

DBMS_AQADM

Lets you perform administrative functions on a queue or queue table for messages of a predefined object type

DBMS_AQELM

Provides procedures to manage the configuration of Advanced Queuing asynchronous notification by e-mail and HTTP

DBMS_AQIN

Plays a part in providing secure access to the Oracle JMS interfaces

DBMS_ASSERT

Provides an interface to validate properties of the input value

DBMS_AUTO_TASK_ADMIN

Used by the DBA as well as Enterprise Manager to access the AUTOTASK controls

DBMS_AUTO_TASK_IMMEDIATE

Cconsists of one subprogram whose function is to initiate gathering of optimizer statistics without delay

DBMS_AW_STATS

Contains a subprogram that generates and stores optimizer statistics for cubes and dimensions

DBMS_CAPTURE_ADM

Describes administrative procedures to start, stop, and configure a capture process; used in Streams

DBMS_CDC_PUBLISH

Identifies new data that has been added to, modified, or removed from, relational tables and publishes the changed data in a form that is usable by an application

DBMS_CDC_SUBSCRIBE

Lets you view and query the change data that was captured and published with the DBMS_LOGMNR_CDC_PUBLISH package

DBMS_COMPARISON

Provides interfaces to compare and converge database objects at different databases

DBMS_COMPRESSION

Provides an interface to facilitate choosing the correct compression level for an application

DBMS_CONNECTION_POOL

Provides an interface to manage the Database Resident Connection Pool

DBMS_CQ_NOTIFICATION

Is part of a set of features that clients use to receive notifications when result sets of a query have changed. The package contains interfaces that can be used by mid-tier clients to register objects and specify delivery mechanisms.

DBMS_CRYPTO

Lets you encrypt and decrypt stored data, can be used in conjunction with PL/SQL programs running network communications, and supports encryption and hashing algorithms

DBMS_CSX_ADMIN

Provides an interface to customize the setup when transporting a tablespace containing binary XML data

DBMS_CUBE

Contains subprograms that create OLAP cubes and dimensions, and that load and process the data for querying

DBMS_CUBE_ADVISE

Contains subprograms for evaluating cube materialized views to support log-based fast refresh and query rewrite

DBMS_DATA_MINING

Implements the Oracle Data Mining interface for creating, evaluating, and managing mining models

DBMS_DATA_MINING_TRANSFORM

Provides subroutines that can be used to prepare data for Oracle Data Mining

DBMS_DATAPUMP

Lets you move all, or part of, a database between databases, including both data and metadata

DBMS_DBFS_CONTENT

Provides an interface comprising a file system-like abstraction backed by one or more Store Providers

DBMS_DBFS_CONTENT_SPI

Provides the Application Programming Interface (API) specification for DBMS_DBFS_CONTENT service providers

DBMS_DBFS_HS

Provides users the ability to use tape or Amazon S3 Web service as a storage tier when doing Information Lifecycle Management for their database tables

DBMS_DBFS_SFS

Provides an interface to operate a SecureFile-based store (SFS) for the content interface described in the DBMS_DBFS_CONTENT package

DBMS_DB_VERSION

Specifies the Oracle version numbers and other information useful for simple conditional compilation selections based on Oracle versions

DBMS_DDL

Provides access to some SQL DDL statements from stored procedures, and provides special administration operations not available as DDLs

DBMS_DEBUG

Implements server-side debuggers and provides a way to debug server-side PL/SQL program units

DBMS_DEFER

Provides the user interface to a replicated transactional deferred remote procedure call facility. Requires the Distributed Option.

DBMS_DEFER_QUERY

Permits querying the deferred remote procedure calls (RPC) queue data that is not exposed through views. Requires the Distributed Option.

DBMS_DEFER_SYS

Provides the system administrator interface to a replicated transactional deferred remote procedure call facility. Requires the Distributed Option.

DBMS_DESCRIBE

Describes the arguments of a stored procedure with full name translation and security checking

DBMS_DG

Allows applications to notify the primary database in an Oracle Data Guard broker environment to initiate a fast-start failover when the application encounters a condition that warrants a failover

DBMS_DIMENSION

Enables you to verify dimension relationships and provides an alternative to the Enterprise Manager Dimension Wizard for displaying a dimension definition

DBMS_DISTRIBUTED_TRUST_ADMIN

Maintains the Trusted Database List, which is used to determine if a privileged database link from a particular server can be accepted

DBMS_EPG

Implements the embedded PL/SQL gateway that enables a Web browser to invoke a PL/SQL stored procedure through an HTTP listener

DBMS_ERRLOG

Provides a procedure that enables you to create an error logging table so that DML operations can continue after encountering errors rather than abort and roll back

DBMS_EXPFIL

Contains all the procedures used to manage attribute sets, expression sets, expression indexes, optimizer statistics, and privileges by Expression Filter

DBMS_FGA

Provides fine-grained security functions

DBMS_FILE_GROUP

One of a set of Streams packages, provides administrative interfaces for managing file groups, file group versions, files and file group repositories

DBMS_FILE_TRANSFER

Lets you copy a binary file within a database or to transfer a binary file between databases

DBMS_FLASHBACK

Lets you flash back to a version of the database at a specified wall-clock time or a specified system change number (SCN)

DBMS_FLASHBACK_ARCHIVE

Containsprocedures for disassociation and reassociation of a Flashback Data Archive (FDA) enabled table from/with its underlying FDA respectively.

DBMS_FREQUENT_ITEMSET

Enables frequent itemset counting

DBMS_HM

Contains constants and procedure declarations for health check management

DBMS_HPROF

Provides an interface for profiling the execution of PL/SQL applications

DBMS_HS_PARALLEL

Enables parallel processing for heterogeneous targets access

DBMS_HS_PASSTHROUGH

Lets you use Heterogeneous Services to send pass-through SQL statements to non-Oracle systems

DBMS_IOT

Creates a table into which references to the chained rows for an Index Organized Table can be placed using the ANALYZE command

DBMS_JAVA

Provides a PL/SQL interface for accessing database functionality from Java

DBMS_JOB

Schedules and manages jobs in the job queue

DBMS_LDAP

Provides functions and procedures to access data from LDAP servers

DBMS_LDAP_UTL

Provides the Oracle Extension utility functions for LDAP

DBMS_LIBCACHE

Prepares the library cache on an Oracle instance by extracting SQL and PL/SQL from a remote instance and compiling this SQL locally without execution

DBMS_LOB

Provides general purpose routines for operations on Oracle Large Object (LOBs) datatypes - BLOB, CLOB (read/write), and BFILEs (read-only)

DBMS_LOCK

Lets you request, convert and release locks through Oracle Lock Management services

DBMS_LOGMNR

Provides functions to initialize and run the log reader

DBMS_LOGMNR_D

Queries the dictionary tables of the current database, and creates a text based file containing their contents

DBMS_LOGSTDBY

Describes procedures for configuring and managing the logical standby database environment

DBMS_METADATA

Lets callers easily retrieve complete database object definitions (metadata) from the dictionary

DBMS_METADATA_DIFF

Contains the interfaces for comparing two metadata documents in SXML format. The result of the comparison is an SXML difference document. This document can be converted to other formats using the DBMS_METADATA submit interface and the CONVERT API.

DBMS_MGD_ID_UTL

Provides a set of utility subprograms

DBMS_MGWADM

Describes the Messaging Gateway administrative interface; used in Advanced Queuing

DBMS_MGWMSG

Describes object types (used by the canonical message types to convert message bodies) and helper methods, constants, and subprograms for working with the Messaging Gateway message types; used in Advanced Queuing.

DBMS_MONITOR

Let you use PL/SQL for controlling additional tracing and statistics gathering

DBMS_MVIEW

Lets you refresh snapshots that are not part of the same refresh group and purge logs. DBMS_SNAPSHOT is a synonym.

DBMS_NETWORK_ACL_ADMIN

Provides the interface to administer the network Access Control List (ACL)

DBMS_NETWORK_UTL

Provides the interface to administer the network Access Control List (ACL)

DBMS_OBFUSCATION_TOOLKIT

Provides procedures for Data Encryption Standards

DBMS_ODCI

Returns the CPU cost of a user function based on the elapsed time of the function

DBMS_OFFLINE_OG

Provides a public interface for offline instantiation of master groups

DBMS_OLAP

Provides procedures for summaries, dimensions, and query rewrites

DBMS_OUTLN

Provides the interface for procedures and functions associated with management of stored outlines Synonymous with OUTLN_PKG

DBMS_OUTPUT

Accumulates information in a buffer so that it can be retrieved later

DBMS_PARALLEL_EXECUTE

Enables the user to incrementally update table data in parallel

DBMS_PCLXUTIL

Provides intra-partition parallelism for creating partition-wise local indexes

DBMS_PIPE

Provides a DBMS pipe service which enables messages to be sent between sessions

DBMS_PREDICTIVE_ANALYTICS

Provides subroutines that implement automatic data mining operations for predict, explain, and profile

DBMS_PREPROCESSOR

Provides an interface to print or retrieve the source text of a PL/SQL unit in its post-processed form

DBMS_PROFILER

Provides a Probe Profiler API to profile existing PL/SQL applications and identify performance bottlenecks

DBMS_PROPAGATION_ADM

Provides administrative procedures for configuring propagation from a source queue to a destination queue

DBMS_RANDOM

Provides a built-in random number generator

DBMS_RECTIFIER_DIFF

Provides an interface to detect and resolve data inconsistencies between two replicated sites

DBMS_REDEFINITION

Lets you perform an online reorganization of tables

DBMS_REFRESH

Lets you create groups of snapshots that can be refreshed together to a transactionally consistent point in time Requires the Distributed Option

DBMS_REPAIR

Provides data corruption repair procedures

DBMS_REPCAT

Provides routines to administer and update the replication catalog and environment. Requires the Replication Option.

DBMS_REPCAT_ADMIN

Lets you create users with the privileges needed by the symmetric replication facility. Requires the Replication Option.

DBMS_REPCAT_INSTANTIATE

Instantiates deployment templates. Requires the Replication Option.

DBMS_REPCAT_RGT

Controls the maintenance and definition of refresh group templates. Requires the Replication Option.

DBMS_REPUTIL

Provides routines to generate shadow tables, triggers, and packages for table replication.

DBMS_RESCONFIG

Provides an interface to operate on the Resource Configuration List, and to retrieve listener information for a resource

DBMS_RESOURCE_MANAGER

Maintains plans, consumer groups, and plan directives; it also provides semantics so that you may group together changes to the plan schema

DBMS_RESOURCE_MANAGER_PRIVS

Maintains privileges associated with resource consumer groups

DBMS_RESULT_CACHE

Provides an interface to operate on the Result Cache

DBMS_RESUMABLE

Lets you suspend large operations that run out of space or reach space limits after executing for a long time, fix the problem, and make the statement resume execution

DBMS_RLMGR

Contains various procedures to create and manage rules and rule sessions by the Rules Manager

DBMS_RLS

Provides row level security administrative interface

DBMS_ROWID

Provides procedures to create rowids and to interpret their contents

DBMS_RULE

Describes the EVALUATE procedure used in Streams

DBMS_RULE_ADM

Describes the administrative interface for creating and managing rules, rule sets, and rule evaluation contexts; used in Streams

DBMS_SCHEDULER

Provides a collection of scheduling functions that are callable from any PL/SQL program

DBMS_SERVER_ALERT

Lets you issue alerts when some threshold has been violated

DBMS_SERVICE

Lets you create, delete, activate and deactivate services for a single instance

DBMS_SESSION

Provides access to SQL ALTER SESSION statements, and other session information, from stored procedures

DBMS_SHARED_POOL

Lets you keep objects in shared memory, so that they will not be aged out with the normal LRU mechanism

DBMS_SPACE

Provides segment space information not available through standard SQL

DBMS_SPACE_ADMIN

Provides tablespace and segment space administration not available through the standard SQL

DBMS_SPM

Supports the SQL plan management feature by providing an interface for the DBA or other user to perform controlled manipulation of plan history and SQL plan baselines maintained for various SQL statements

DBMS_SQL

Lets you use dynamic SQL to access the database

DBMS_SQLDIAG

Provides an interface to the SQL Diagnosability functionality

DBMS_SQLPA

Provides an interface to implement the SQL Performance Analyzer.

DBMS_SQLTUNE

Provides the interface to tune SQL statements

DBMS_STAT_FUNCS

Provides statistical functions

DBMS_STATS

Provides a mechanism for users to view and modify optimizer statistics gathered for database objects

DBMS_STORAGE_MAP

Communicates with FMON to invoke mapping operations

DBMS_STREAMS

Describes the interface to convert SYS.AnyData objects into LCR objects and an interface to annotate redo entries generated by a session with a binary tag.

DBMS_STREAMS_ADMIN

Describes administrative procedures for adding and removing simple rules, without transformations, for capture, propagation, and apply at the table, schema, and database level

DBMS_STREAMS_ADVISOR_ADM

Provides an interface to gather information about an Oracle Streams environment and advise database administrators based on the information gathered

DBMS_STREAMS_AUTH

Provides interfaces for granting privileges to Streams administrators and revoking privileges from Streams administrators

DBMS_STREAMS_HANDLER_ADM

Provides interfaces to enqueue messages into and dequeue messages from a SYS.AnyData queue

DBMS_STREAMS_MESSAGING

Provides interfaces to enqueue messages into and dequeue messages from a SYS.AnyData queue

DBMS_STREAMS_TABLESPACE_ADM

Provides administrative procedures for copying tablespaces between databases and moving tablespaces from one database to another

DBMS_TDB

Reports whether a database can be transported between platforms using the RMAN CONVERT DATABASE command. It verifies that databases on the current host platform are of the same endian format as the destination platform, and that the state of the current database does not prevent transport of the database.

DBMS_TRACE

Provides routines to start and stop PL/SQL tracing

DBMS_TRANSACTION

Provides access to SQL transaction statements from stored procedures and monitors transaction activities

DBMS_TRANSFORM

Provides an interface to the message format transformation features of Oracle Advanced Queuing

DBMS_TTS

Checks if the transportable set is self-contained

DBMS_TYPES

Consists of constants, which represent the built-in and user-defined types

DBMS_UTILITY

Provides various utility routines

DBMS_WARNING

Provides the interface to query, modify and delete current system or session settings

DBMS_WM

Describes how to use the programming interface to Oracle Database Workspace Manager to work with long transactions

DBMS_WORKLOAD_CAPTURE

Configures the Workload Capture system and produce the workload capture data.

DBMS_WORKLOAD_REPLAY

Provides an interface to replay and report on a record of a workload on a production or test system

DBMS_WORKLOAD_REPOSITORY

Lets you manage the Workload Repository, performing operations such as managing snapshots and baselines

DBMS_XA

Contains the XA/Open interface for applications to call XA interface in PL/SQL

DBMS_XDB

Describes Resource Management and Access Control interface for PL/SQL

DBMS_XDB_ADMIN

Provides an interface to implement XMLIndex administration operation

DBMS_XDBRESOURCE

Provides an interface to operate on the XDB resource's metadata and contents

DBMS_XDB_VERSION

Describes the versioning interface

DBMS_XDBT

Describes how an administrator can create a ConText index on the XML DB hierarchy and configure it for automatic maintenance

DBMS_XDBZ

Controls the Oracle XML DB repository security, which is based on Access Control Lists (ACLs)

DBMS_XEVENT

Provides event-related types and supporting subprograms

DBMS_XMLDOM

Explains access to XMLType objects

DBMS_XMLGEN

Converts the results of a SQL query to a canonical XML format

DBMS_XMLINDEX

Provides an interface to implement asychronous indexing and apply node referencing

DBMS_XMLPARSER

Explains access to the contents and structure of XML documents

DBMS_XMLQUERY

Provides database-to-XMLType functionality

DBMS_XMLSAVE

Provides XML-to-database-type functionality

DBMS_XMLSCHEMA

Explains procedures to register and delete XML schemas

DBMS_XMLSTORE

Provides the ability to store XML data in relational tables

DBMS_XMLTRANSLATIONS

Provides an interface to perform translations so that strings can be searched or displayed in various languages

DBMS_XPLAN

Describes how to format the output of the EXPLAIN PLAN command

DBMS_XSLPROCESSOR

Explains access to the contents and structure of XML documents

DEBUG_EXTPROC

Lets you debug external procedures on platforms with debuggers that attach to a running process

HTF

Hypertext functions generate HTML tags

HTP

Hypertext procedures generate HTML tags

ORD_DICOM

Supports the management and manipulation of Digital Imaging and Communications in Medicine (DICOM) content stored in BLOBs or BFILEs rather than in an ORDDicom object type

ORD_DICOM_ADMIN

Used by Oracle Multimedia Digital Imaging and Communications in Medicine (DICOM) administrators to maintain the Oracle Multimedia DICOM data model repository

OWA_CACHE

Provides an interface that enables the PL/SQL Gateway cache to improve the performance of PL/SQL Web applications

OWA_COOKIE

Provides an interface for sending and retrieving HTTP cookies from the client's browser

OWA_CUSTOM

Provides a Global PLSQL Agent Authorization callback function

OWA_IMAGE

Provides an interface to access the coordinates where a user clicked on an image

OWA_OPT_LOCK

Contains subprograms that impose optimistic locking strategies so as to prevent lost updates

OWA_PATTERN

Provides an interface to locate text patterns within strings and replace the matched string with another string

OWA_SEC

Provides an interface for custom authentication

OWA_TEXT

Contains subprograms used by OWA_PATTERN for manipulating strings. They are externalized so you can use them directly.

OWA_UTIL

Contains utility subprograms for performing operations such as getting the value of CGI environment variables, printing the data that is returned to the client, and printing the results of a query in an HTML table

SDO_CS

Provides functions for coordinate system transformation

SDO_CSW_PROCESS

Contains subprograms for various processing operations related to support for Catalog Services for the Web (CSW)

SDO_GCDR

Contains the Oracle Spatial geocoding subprograms, which let you geocode unformatted postal addresses

SDO_GEOM

Provides functions implementing geometric operations on spatial objects

SDO_GEOR

Contains functions and procedures for the Spatial GeoRaster feature, which lets you store, index, query, analyze, and deliver raster image data and its associated Spatial vector geometry data and metadata

SDO_GEOR_ADMIN

Contains subprograms for administrative operations related to GeoRaster.

SDO_GEOR_UTL

Contains utility functions and procedures for the Spatial GeoRaster feature, including those related to using triggers with GeoRaster data

SDO_LRS

Provides functions for linear referencing system support

SDO_MIGRATE

Provides functions for migrating spatial data from previous releases

SDO_NET

Provides functions and procedures for working with data modeled as nodes and links in a network

SDO_NET_MEM

Contains functions and procedures for performing editing and analysis operations on network data using a network memory object

SDO_OLS

Contains functions and procedures for performing editing and analysis operations on network data using a network memory object

SDO_PC_PKG

Contains subprograms to support the use of point clouds in Spatial

SDO_SAM

Contains functions and procedures for spatial analysis and data mining

SDO_TIN_PKG

Contains subprograms to support the use of triangulated irregular networks (TINs) in Spatial

SDO_TOPO

Provides procedures for creating and managing Spatial topologies

SDO_TOPO_MAP

Contains subprograms for editing Spatial topologies using a cache (TopoMap object)

SDO_TUNE

Provides functions for selecting parameters that determine the behavior of the spatial indexing scheme used in Oracle Spatial

SDO_UTIL

Provides utility functions and procedures for Oracle Spatial

SDO_WFS_LOCK

Contains subprograms for WFS support for registering and unregistering feature tables

SDO_WFS_PROC

Provides utility functions and procedures for Oracle Spatial

SEM_APIS

Contains subprograms for working with the Resource Description Framework (RDF) and Web Ontology Language (OWL) in an Oracle database.

SEM_PERF

Contains subprograms for examining and enhancing the performance of the Resource Description Framework (RDF) and Web Ontology Language (OWL) support in an Oracle database

SEM_RDFCTX

Contains subprograms for managing extractor policies and semantic indexes created for documents

SEM_RDFSA

Contains subprograms for providing fine-grained access control to RDF data, using either a virtual private database (VPD) or Oracle Label Security (OLS)

UTL_COLL

Enables PL/SQL programs to use collection locators to query and update

UTL_COMPRESS

Provides a set of data compression utilities

UTL_DBWS

Provides database Web services

UTL_ENCODE

Provides functions that encode RAW data into a standard encoded format so that the data can be transported between hosts

UTL_FILE

Enables your PL/SQL programs to read and write operating system text files and provides a restricted version of standard operating system stream file I/O

UTL_HTTP

Enables HTTP callouts from PL/SQL and SQL to access data on the Internet or to call Oracle Web Server Cartridges

UTL_I18N

Provides a set of services (Oracle Globalization Service) that help developers build multilingual applications

UTL_INADDR

Provides a procedure to support internet addressing

UTL_IDENT

Specifies which database or client PL/SQL is running

UTL_LMS

Retrieves and formats error messages in different languages

UTL_MAIL

A utility for managing email which includes commonly used email features, such as attachments, CC, BCC, and return receipt

UTL_NLA

Exposes a subset of the BLAS and LAPACK (Version 3.0) operations on vectors and matrices represented as VARRAYs

UTL_RAW

Provides SQL functions for manipulating RAW datatypes

UTL_RECOMP

Recompiles invalid PL/SQL modules, invalid views, Java classes, indextypes and operators in a database, either sequentially or in parallels

UTL_REF

Enables a PL/SQL program to access an object by providing a reference to the object

UTL_SMTP

Provides PL/SQL functionality to send emails

UTL_SPADV

Provides subprograms to collect and analyze statistics for the Oracle Streams components in a distributed database environment

UTL_TCP

Provides PL/SQL functionality to support simple TCP/IP-based communications between servers and the outside world

UTL_URL

Provides escape and unescape mechanisms for URL characters

WPG_DOCLOAD

Provides an interface to download files, both BLOBs and BFILEs

ANYDATA TYPE

A self-describing data instance type containing an instance of the type plus a description

ANYDATASET TYPE

Contains a description of a given type plus a set of data instances of that type

ANYTYPE TYPE

Contains a type description of any persistent SQL type, named or unnamed, including object types and collection types; or, it can be used to construct new transient type descriptions

Oracle Streams AQ Types

Describes the types used in Advanced Queuing

DBFS Content Interface Types

Describes public types defined to support the DBMS_DBFS_CONTENT interface.

Database URI Type

Contains URI Support, UriType Super Type, HttpUriType Subtype, DBUriType Subtype, XDBUriType Subtype, UriFactory Package

Expression Filter Types

Expression Filter feature is supplied with a set of predefined types and public synonyms for these types.

JMS TYPES

Describes JMS types so that a PL/SQL application can use JMS queues of JMS types

Oracle Multimedia ORDAudio TYPE

Supports the storage and management of audio data

Oracle Multimedia ORDDicom Type

Supports the storage, management, and manipulation of Digital Imaging and Communications in Medicine (DICOM) data

Oracle Multimedia ORDDoc TYPE

Supports the storage and management of heterogeneous media data including image, audio, and video

Oracle Multimedia ORDImage TYPE

Supports the storage, management, and manipulation of image data

Oracle Multimedia SQL/MM Still Image TYPE

Supports the SQL/MM Still Image Standard, which lets you store, retrieve, and modify images in the database and locate images using visual predicates

Oracle Multimedia ORDVideo TYPE

Supports the storage and management of video data

LOGICAL CHANGE RECORD TYPES

Describes LCR types, which are message payloads that contain information about changes to a database, used in Streams

MG_ID Package Types

Provides an extensible framework that supports current RFID tags with the standard family of EPC bit encodings for the supported encoding types

RULES TYPEs

Describes the types used with rules, rule sets, and evaluation contexts

RULES Manager Types

Rules Manager is supplied with one predefined type and a public synonym

UTL Streams Types

Describes describes abstract streams types used with Oracle XML functionality

XMLType

Describes the types and functions used for native XML support in the server