Oracle Supplied Packages

Packages marked * are new in 9.2

Package       Description

DBMS_ALERT    Notify a database event (asynchronous)

              Register an application name with the database
              for auditing or performance tracking.
              Application info can be pushed into V$SESSION/V$SESSION_LONGOPS
DBMS_AQ       Add a message (of a predefined object type) onto a queue 
              or dequeue a message.
DBMS_AQADM    Administer a queue or queue table 
              for messages of a predefined object type.
DBMS_AQELM    Configure Advanced Queuing
              asynchronous notification by e-mail and HTTP. *
              Normalize filenames on Windows NT platforms.
DBMS_DDL      Access SQL DDL statements from a stored procedure,
              provides special administration operations 
              not available as DDLs.
DBMS_DEBUG    Implement server-side debuggers and provide a way to 
              debug server-side PL/SQL program units. 
DBMS_DEFER    User interface to a replicated transactional deferred 
              RPC facility. Requires the Distributed Option. 
              Permit querying the deferred remote procedure calls (RPC)
              queue data that is not exposed through views.
              Requires the Distributed Option. 
              The system administrator interface to a replicated 
              transactional deferred RPC facility.
              Requires the Distributed Option.
              Describe the arguments of a stored procedure
              with full name translation and security checking.
              Maintain the Trusted Database List, which is used to 
              determine if a privileged database link from a particular 
              server can be accepted.

DBMS_ENCODE   Encode???
DBMS_FGA      Fine-grained security functions. *
              Flash back to a version of the database at a specified
              wall-clock time or a specified system change 
              number (SCN). *
              Send pass-through SQL statements to non-Oracle systems.
              (via Heterogeneous Services)
DBMS_IOT      Create a table into which references to the chained rows 
              for an Index Organized Table can be placed using the 
              ANALYZE command. 
DBMS_JOB      Schedule PL/SQL procedures that you want performed at 
              periodic intervals; also the job queue interface. 
DBMS_LDAP     Functions and procedures to access data from
              LDAP servers. *
              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      General purpose routines for operations on Oracle Large
              Object (LOBs) datatypes - BLOB, CLOB (read-write),
              and BFILEs (read-only). 
DBMS_LOCK     Request, convert and release locks through Oracle Lock 
              Management services.
DBMS_LOGMNR   Functions to initialize and run the log reader. 
              Identify new data that has been added to, modified, or 
              removed from, relational tables and publish the changed 
              data in a form that is usable by an application. *
              View and query the change data that was captured 
              and published with the DBMS_LOGMNR_CDC_PUBLISH package. *
              Query the dictionary tables of the current database, and 
              create a text based file containing their contents.
              Retrieve complete database object definitions (metadata) 
              from the dictionary. *
DBMS_MVIEW    Refresh snapshots that are not part of the same 
              refresh group and purge logs. DBMS_SNAPSHOT is a synonym.
              Procedures for Data Encryption Standards.
DBMS_ODCI     Get the CPU cost of a user function based on the 
              elapsed time of the function. *
              Public APIs for offline instantiation of master groups.
              Public APIs for offline instantiation of snapshots.
DBMS_OLAP     Procedures for summaries, dimensions, and query rewrites.
              Client callable interfaces to the Oracle TRACE
              instrumentation within the Oracle7 Server.
              Public access to the Oracle release 7 Server 
              Oracle TRACE instrumentation for the calling user.
DBMS_OUTLN    Interface for procedures and functions associated with 
              management of stored outlines. Synonymous with OUTLN_PKG
              Edit an invoker's rights package. *
DBMS_OUTPUT   Accumulate information in a buffer so that it can be 
              retrieved out later.
DBMS_PCLXUTIL Intra-partition parallelism for creating partition-wise 
              local indexes.
DBMS_PIPE     A DBMS pipe service which enables messages to be sent 
              between sessions.
DBMS_PROFILER A Probe Profiler API to profile PL/SQL applications
              and identify performance bottlenecks.
              To install this run profload.sql(as SYS) and proftab.sql(as user)
DBMS_RANDOM   A built-in random number generator.
              Options to generate random numbers within a range or distribution.
              APIs used to detect and resolve data inconsistencies 
              between two replicated sites.
              Reorganise a table (change it's structure) while it's
              still online and in use. *
DBMS_REFRESH  Create groups of snapshots that can be refreshed together
              to a transactionally consistent point in time.
              Requires the Distributed Option. 
DBMS_REPAIR   Repair data corruption.
DBMS_REPCAT   Administer and update the replication catalog and environment. 
              Requires the Replication Option.
              Create users with the privileges needed by the symmetric 
              replication facility. Requires the Replication Option.
              Instantiates deployment templates.
              Requires the Replication Option.
              Define and maintain refresh group templates. 
              Requires the Replication Option.

              Generate shadow tables, triggers, and packages 
              for table replication.
              Maintain plans, consumer groups, and plan directives; 
              also provides semantics so that you may group together 
              changes to the plan schema. 
              Maintain privileges associated with resource consumer groups. 
              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_RLS      Row level security administrative interface.
DBMS_ROWID    Procedures to create rowids and to interpret their contents. 
DBMS_SESSION  Access to SQL ALTER SESSION statements, and other session 
              information, from stored procedures.
              Keep objects in shared memory, so that they will not be aged
              out with the normal LRU mechanism.
              Synonym for DBMS_MVIEW
DBMS_SPACE    Segment space information not available through standard SQL.
              How much space is left before a new extent gets allocated?
              How many blocks are above the segments High Water Mark?
              How many blocks are in the free list(s)
              Tablespace and segment space administration not available 
              through the standard SQL.
DBMS_SQL      Use dynamic SQL to access the database.
              Language facilities that help your application interact 
              with Oracle.
DBMS_STATS    View and modify optimizer statistics gathered for database objects.
              In a small test environment this allows faking the stats
              to simulate running a large production database.
DBMS_TRACE    Routines to start and stop PL/SQL tracing.
              Access to SQL transaction statements from stored 
              procedures and monitors transaction activities.
              An interface to the message format transformation features 
              of Oracle Advanced Queuing. *
DBMS_TTS      Check if a transportable set is self-contained.
DBMS_TYPES    Constants, which represent the built-in and user-defined types.

DBMS_URL      Oracle Spatial connection_type ??

DBMS_UTILITY  Utility routines, Analyze, Time, Conversion etc.
DBMS_WM       Database Workspace Manager (long transactions) *
DBMS_XMLGEN   Convert the results of a SQL query to a canonical XML format. *
              Database-to-XMLType functionality. *
              XML-to-database-type functionality. *
              Debug external procedures on platforms with debuggers 
              that can attach to a running process.
OUTLN_PKG     Synonym of DBMS_OUTLN.
PLITBLM       Handle index-table operations.(Don't call directly)

              see Oracle Spatial User's Guide and Reference 
              Spatial packages are installed in user MDSYS with public synonyms.

STANDARD      Types, exceptions, and subprograms which are
              available automatically to every PL/SQL program. 

UTL_COLL      Collection locators - query and update from a PL/SQL program.
UTL_ENCODE    Encode RAW data into a standard encoded format
              so that the data can be transported between hosts. *
UTL_FILE      Read and write OS text files via PL/SQL. 
              A restricted version of standard OS stream file I/O. 
UTL_HTTP      Enable HTTP callouts from PL/SQL and SQL to access data 
              on the Internet or to call Oracle Web Server Cartridges.
UTL_INADDR    A procedure to support internet addressing.
UTL_PG        Convert COBOL numeric data into Oracle numbers 
              and convert Oracle numbers into COBOL numeric data. 
UTL_RAW       SQL functions for RAW datatypes that concat, 
              substr, etc. to and from RAWS.
UTL_REF       Enable a PL/SQL program to access an object by providing a 
              reference to the object.
UTL_SMTP      Send SMTP email. The mailer program needs to run on the server,
              but can be invoked from a client.
UTL_TCP       Simple TCP/IP-based communication between servers and the outside world.  
UTL_URL       Escape and unescape mechanism for URL characters. 
ANYDATA TYPE  A self-describing data instance TYPE.
              Describe 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.

To scroll this page, press [ a – z ] on the keyboard, also on the detail pages [s] for syntax and [e] for examples.

See also

EXEC - Execute a PL/SQL package
DESC - Describe a package

Related Views

                      ALL_ARGUMENTS        USER_ARGUMENTS
                      ALL_PROCEDURES       USER_PROCEDURES

Copyright © 1999-2024
Some rights reserved