Thursday, October 9, 2008

Oracle Supplied PL/SQL Packages

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

=================================================================


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_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_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_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_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_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_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_OUTLN_EDIT
Lets you edit an invoker's rights package
DBMS_OUTPUT
Accumulates information in a buffer so that it can be retrieved later
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_INSTATIATE
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_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_AUTH
Provides interfaces for granting privileges to Streams administrators and revoking privileges from Streams administrators
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_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
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_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_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
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