Oracle Supplied Packages, 3 of 4

List of Oracle Supplied Packages

This section lists each of the Oracle supplied server packages and indicates where they are described in more detail. 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.

Please do not modify Oracle supplied packages as this could cause internal errors and database security violations.

Table 1-1 List of Oracle Supplied Packages

Package Name	Description	Documentation
Calendar (see Note #2 below)	Provides calendar maintenance functions.	Oracle8i Time Series User's Guide
DBMS_ALERT	Provides support for the asynchronous notification of database events.	Chapter 2
DBMS_APPLICATION_INFO	Lets you register an application name with the database for auditing or performance tracking purposes.	Chapter 3
DBMS_AQ	Lets you add a message (of a predefined object type) onto a queue or to dequeue a message.	Chapter 4
DBMS_AQADM	Lets you perform administrative functions on a queue or queue table for messages of a predefined object type.	Chapter 5
DBMS_BACKUP_RESTORE	Normalizes filenames on Windows NT platforms.	Chapter 6
DBMS_DDL	Provides access to some SQL DDL statements from stored procedures, and provides special administration operations not available as DDLs.	Chapter 7
DBMS_DEBUG	A PL/SQL API to the PL/SQL debugger layer, Probe, in the Oracle server.	Chapter 8
DBMS_DEFER	Provides the user interface to a replicated transactional deferred remote procedure call facility. Requires the Distributed Option.	Chapter 9
DBMS_DEFER_QUERY	Permits querying the deferred remote procedure calls (RPC) queue data that is not exposed through views. Requires the Distributed Option.	Chapter 10
DMBS_DEFER_SYS	Provides the system administrator interface to a replicated transactional deferred remote procedure call facility. Requires the Distributed Option.	Chapter 11
DBMS_DESCRIBE	Describes the arguments of a stored procedure with full name translation and security checking.	Chapter 12
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.	Chapter 13
DBMS_HS	Lets you create and modify objects in the Heterogeneous Services dictionary.	Chapter 14
DBMS_HS_PASSTHROUGH	Lets you use Heterogeneous Services to send pass-through SQL statements to non-Oracle systems.	Chapter 15
DBMS_IOT	Creates a table into which references to the chained rows for an Index Organized Table can be placed using the `ANALYZE` command.	Chapter 16
DBMS_JOB	Lets you schedule administrative procedures that you want performed at periodic intervals; it is also the interface for the job queue.	Chapter 17
DBMS_LOB	Provides general purpose routines for operations on Oracle Large Object (`LOB`s) datatypes - `BLOB`, `CLOB` (read-write), and `BFILE`s (read-only).	Chapter 18
DBMS_LOCK	Lets you request, convert and release locks through Oracle Lock Management services.	Chapter 19
DBMS_LOGMNR	Provides functions to initialize and run the log reader.	Chapter 20
DBMS_LOGMNR_D	Queries the dictionary tables of the current database, and creates a text based file containing their contents.	Chapter 21
DBMS_MVIEW	A synonym for DBMS_SNAPSHOT.	Chapter 22
DBMS_OBFUSCATION_TOOLKIT	Provides procedures for Data Encryption Standards.	Chapter 23
DBMS_OFFLINE_OG	Provides public APIs for offline instantiation of master groups.	Chapter 24
DBMS_OFFLINE_SNAPSHOT	Provides public APIs for offline instantiation of snapshots.	Chapter 25
DBMS_OLAP	Provides procedures for summaries, dimensions, and query rewrites.	Chapter 26
DBMS_ORACLE_TRACE_AGENT	Provides client callable interfaces to the Oracle TRACE instrumentation within the Oracle7 Server.	Chapter 27
DBMS_ORACLE_TRACE_USER	Provides public access to the Oracle release 7 Server Oracle TRACE instrumentation for the calling user.	Chapter 28
DBMS_OUTPUT	Accumulates information in a buffer so that it can be retrieved out later.	Chapter 29
DBMS_PCLXUTIL	Provides intra-partition parallelism for creating partition-wise local indexes.	Chapter 30
DBMS_PIPE	Provides a DBMS pipe service which enables messages to be sent between sessions.	Chapter 31
DBMS_PROFILER	Provides a Probe Profiler API to profile existing PL/SQL applications and identify performance bottlenecks.	Chapter 32
DBMS_RANDOM	Provides a built-in random number generator.	Chapter 33
DBMS_RECTIFIER_DIFF	Provides APIs used to detect and resolve data inconsistencies between two replicated sites.	Chapter 34
DBMS_REFRESH	Lets you create groups of snapshots that can be refreshed together to a transactionally consistent point in time. Requires the Distributed Option.	Chapter 35
DBMS_REPAIR	Provides data corruption repair procedures.	Chapter 36
DBMS_REPCAT	Provides routines to administer and update the replication catalog and environment. Requires the Replication Option.	Chapter 37
DBMS_REPCAT_ADMIN	Lets you create users with the privileges needed by the symmetric replication facility. Requires the Replication Option.	Chapter 38
DBMS_REPCAT_INSTATIATE	Instantiates deployment templates. Requires the Replication Option.	Chapter 39
DBMS_REPCAT_RGT	Controls the maintenance and definition of refresh group templates. Requires the Replication Option.	Chapter 40
DBMS_REPUTIL	Provides routines to generate shadow tables, triggers, and packages for table replication.	Chapter 41
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.	Chapter 42
DBMS_RESOURCE_MANAGER_PRIVS	Maintains privileges associated with resource consumer groups.	Chapter 43
DBMS_RLS	Provides row level security administrative interface.	Chapter 44
DBMS_ROWID	Provides procedures to create `ROWIDs` and to interpret their contents.	Chapter 45
DBMS_SESSION	Provides access to SQL `ALTER` `SESSION` statements, and other session information, from stored procedures.	Chapter 46
DBMS_SHARED_POOL	Lets you keep objects in shared memory, so that they will not be aged out with the normal LRU mechanism.	Chapter 47
DBMS_SNAPSHOT (synonym `DBMS_MVIEW`)	Lets you refresh snapshots that are not part of the same refresh group and purge logs. Requires the Distributed Option.	Chapter 48
DBMS_SPACE	Provides segment space information not available through standard SQL.	Chapter 49
DBMS_SPACE_ADMIN	Provides tablespace and segment space administration not available through the standard SQL.	Chapter 50
DBMS_SQL	Lets you use dynamic SQL to access the database.	Chapter 51
DBMS_STANDARD	Provides language facilities that help your application interact with Oracle.	(see Note #1 below)
DBMS_STATS	Provides a mechanism for users to view and modify optimizer statistics gathered for database objects.	Chapter 52
DBMS_TRACE	Provides routines to start and stop PL/SQL tracing.	Chapter 53
DBMS_TRANSACTION	Provides access to SQL transaction statements from stored procedures and monitors transaction activities.	Chapter 54
DBMS_TTS	Checks if the transportable set is self-contained.	Chapter 55
DBMS_UTILITY	Provides various utility routines.	Chapter 56
DEBUG_EXTPROC	Lets you debug external procedures on platforms with debuggers that can attach to a running process.	Chapter 57
OUTLN_PKG	Provides the interface for procedures and functions associated with management of stored outlines.	Chapter 58
PLITBLM	Handles index-table operations.	(see Note #1 below)
SDO_ADMIN (see Note #3 below)	Provides functions implementing spatial index creation and maintenance for spatial objects.	Oracle8i Spatial User's Guide and Reference
SDO_GEOM (see Note #3 below)	Provides functions implementing geometric operations on spatial objects.	Oracle8i Spatial User's Guide and Reference
SDO_MIGRATE (see Note #3 below)	Provides functions for migrating spatial data from release 7.3.3 and 7.3.4 to 8.1.x.	Oracle8i Spatial User's Guide and Reference
SDO_TUNE (see Note #3 below)	Provides functions for selecting parameters that determine the behavior of the spatial indexing scheme used in the Spatial Cartridge.	Oracle8i Spatial User's Guide and Reference
STANDARD	Declares types, exceptions, and subprograms which are available automatically to every PL/SQL program.	(see Note #1 below)
TimeSeries (see Note #2 below)	Provides functions that perform operations, such as extraction, retrieval, arithmetic, and aggregation, on time series data.	Oracle8i Time Series User's Guide
TimeScale (see Note #2 below)	Provides scaleup and scaledown functions.	Oracle8i Time Series User's Guide
TSTools (see Note #2 below)	Provides administrative tools procedures.	Oracle8i Time Series User's Guide
UTL_COLL	Enables PL/SQL programs to use collection locators to query and update.	Chapter 59
UTL_FILE	Enables your PL/SQL programs to read and write operating system (OS) text files and provides a restricted version of standard OS stream file I/O.	Chapter 60
UTL_HTTP	Enables HTTP callouts from PL/SQL and SQL to access data on the Internet or to call Oracle Web Server Cartridges.	Chapter 61
UTL_INADDR	Provides a procedure to support internet addressing.	Chapter 62
UTL_PG	Provides functions for converting COBOL numeric data into Oracle numbers and Oracle numbers into COBOL numeric data.	Oracle Procedural Gateway for APPC User's Guide
UTL_RAW	Provides SQL functions for `RAW` datatypes that concat, substr, etc. to and from `RAWS.`	Chapter 63
UTL_REF	Enables a PL/SQL program to access an object by providing a reference to the object.	Chapter 64
UTL_SMTP	Provides PL/SQL functionality to send emails.	Chapter 65
UTL_TCP	Provides PL/SQL functionality to support simple TCP/IP-based communications between servers and the outside world.	Chapter 66
Vir_Pkg (see Note #2 below)	Provides analytical and conversion functions for Visual Information Retrieval.	Oracle8i Visual Information Retrieval User's Guide and Reference
Note #1: The `DBMS_STANDARD`, `STANDARD`, and `PLITBLM` packages contain subprograms to help implement basic language features. Oracle does not recommend that the subprograms be directly called. For this reason, these three supplied packages are not documented in this book.
Note #2: Time-Series, Image, Visual Information Retrieval, Audio, and Server-Managed Video Cartridge packages are installed in user ORDSYS without public synonyms.
Note #3: Spatial Cartridge packages are installed in user MDSYS with public synonyms.