Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

What's New in Supplied PL/SQL Packages and Types?

Oracle9i Release 2 (9.2) Beta New Features in Supplied PL/SQL Packages and Types

Oracle9i Release 1 (9.0.1) New Features in Supplied PL/SQL Packages and Types

Oracle8i Release 2 (8.1.6) New Features in Supplied PL/SQL Packages

Oracle8i Release 1 (8.1.5) New Features in Supplied PL/SQL Packages

1 Introduction

Package Overview

Abbreviations for Datetime and Interval Datatypes

Summary of Oracle Supplied PL/SQL Packages

Summary of Subprograms in Supplemental Packages

2 DBMS_ALERT

Security, Constants, and Errors for DBMS_ALERT

Using Alerts

Summary of DBMS_ALERT Subprograms

3 DBMS_APPLICATION_INFO

Privileges

Summary of DBMS_APPLICATION_INFO Subprograms

4 DBMS_APPLY_ADM

Summary of DBMS_APPLY_ADM Subprograms

5 DBMS_AQ

Java Classes

Enumerated Constants

Data Structures for DBMS_AQ

Summary of DBMS_AQ Subprograms

6 DBMS_AQADM

Enumerated Constants

Summary of DBMS_AQADM Subprograms

7 DBMS_AQELM

Summary of DBMS_AQELM Subprograms

8 DBMS_CAPTURE_ADM

Summary of DBMS_CAPTURE_ADM Subprograms

9 DBMS_DDL

Summary of DBMS_DDL Subprograms

10 DBMS_DEBUG

Using DBMS_DEBUG

Usage Notes

Types and Constants

Error Codes, Exceptions, and Variables

Common and Debug Session Sections

OER Breakpoints

Summary of DBMS_DEBUG Subprograms

11 DBMS_DEFER

Summary of DBMS_DEFER Subprograms

12 DBMS_DEFER_QUERY

Summary of DBMS_DEFER_QUERY Subprograms

13 DBMS_DEFER_SYS

Summary of DBMS_DEFER_SYS Subprograms

14 DBMS_DESCRIBE

Security, Types, and Errors for DBMS_DESCRIBE

Summary of DBMS_DESCRIBE Subprograms

15 DBMS_DISTRIBUTED_TRUST_ADMIN

Requirements

Summary of DBMS_DISTRIBUTED_TRUST_ADMIN Subprograms

16 DBMS_FGA

Summary of DBMS_FGA Subprograms

17 DBMS_FLASHBACK

DBMS_FLASHBACK Error Messages

Using DBMS_FLASHBACK: Example

Summary of DBMS_FLASHBACK Subprograms

18 DBMS_HS_PASSTHROUGH

Security

Summary of DBMS_HS_PASSTHROUGH Subprograms

19 DBMS_IOT

Summary of DBMS_IOT Subprograms

20 DBMS_JOB

Requirements

Using the DBMS_JOB Package with Oracle Real Application Clusters

Summary of DBMS_JOB Subprograms

21 DBMS_LDAP

Exception Summary

Summary of Data Types

Summary of DBMS_LDAP Subprograms

22 DBMS_LIBCACHE

Requirements

Summary of DBMS_LIBCACHE Subprograms

23 DBMS_LOB

LOB Locators for DBMS_LOB

Datatypes, Constants, and Exceptions for DBMS_LOB

Security for DBMS_LOB

Rules and Limitations for DBMS_LOB

Temporary LOBs

Summary of DBMS_LOB Subprograms

24 DBMS_LOCK

Requirements, Security, and Constants for DBMS_LOCK

Summary of DBMS_LOCK Subprograms

Printing a Check: Example

25 DBMS_LOGMNR

DBMS_LOGMNR Constants

Summary of DBMS_LOGMNR Subprograms

26 DBMS_LOGMNR_CDC_PUBLISH

Publishing Change Data

Summary of DBMS_LOGMNR_CDC_PUBLISH Subprograms

27 DBMS_LOGMNR_CDC_SUBSCRIBE

Subscribing to Change Data

Summary of DBMS_LOGMNR_CDC_SUBSCRIBE Subprograms

28 DBMS_LOGMNR_D

Summary of DBMS_LOGMNR_D Subprograms

29 DBMS_LOGSTDBY

Configuring and Managing the Logical Standby Environment

Summary of DBMS_LOGSTDBY Subprograms

30 DBMS_METADATA

Summary of DBMS_METADATA Subprograms

31 DBMS_MGWADM

Summary of DBMS_MGWADM Object Types and Methods

DBMS_MGWADM Constants

MQSeries System Properties

Summary of DBMS_MGWADM Subprograms

Summary of Database Views

32 DBMS_MGWMSG

Summary of DBMS_MGWMSG Object Types and Methods

DBMS_MGWMSG Constants

Summary of DBMS_MGWMSG Subprograms

33 DBMS_MVIEW

Summary of DBMS_MVIEW Subprograms

34 DBMS_OBFUSCATION_TOOLKIT

Overview of Key Management

Summary of DBMS_OBFUSCATION Subprograms

35 DBMS_ODCI

Summary of DBMS_ODCI Subprograms

36 DBMS_OFFLINE_OG

Summary of DBMS_OFFLINE_OG Subprograms

37 DBMS_OFFLINE_SNAPSHOT

Summary of DBMS_OFFLINE_SNAPSHOT Subprograms

38 DBMS_OLAP

Requirements

Error Messages

Summary of DBMS_OLAP Subprograms

39 DBMS_ORACLE_TRACE_AGENT

Security

Summary of DBMS_ORACLE_TRACE_AGENT Subprograms

40 DBMS_ORACLE_TRACE_USER

Summary of DBMS_ORACLE_TRACE_USER Subprograms

41 DBMS_OUTLN

Requirements and Security for DBMS_OUTLN

Summary of DBMS_OUTLN Subprograms

42 DBMS_OUTLN_EDIT

Summary of DBMS_OUTLN_EDIT Subprograms

43 DBMS_OUTPUT

Security, Errors, and Types for DBMS_OUTPUT

Using DBMS_OUTPUT

Summary of DBMS_OUTPUT Subprograms

44 DBMS_PCLXUTIL

Using DBMS_PCLXUTIL

Limitations

Summary of DBMS_PCLUTTL Subprograms

45 DBMS_PIPE

Public Pipes, Private Pipes, and Pipe Uses

Security, Constants, and Errors

Summary of DBMS_PIPE Subprograms

46 DBMS_PROFILER

Using DBMS_PROFILER

Requirements

Security

Exceptions

Error Codes

Summary of DBMS_PROFILER Subprograms

47 DBMS_PROPAGATION_ADM

Summary of DBMS_PROPAGATION_ADM Subprograms

48 DBMS_RANDOM

Requirements

Summary of DBMS_RANDOM Subprograms

49 DBMS_RECTIFIER_DIFF

Summary of DBMS_RECTIFIER_DIFF Subprograms

50 DBMS_REDEFINITION

Constants for DBMS_REDEFINITION

Summary of DBMS_REDEFINITION Subprograms

51 DBMS_REFRESH

Summary of DBMS_REFRESH Subprograms

52 DBMS_REPAIR

Security, Enumeration Types, and Exceptions

Summary of DBMS_REPAIR Subprograms

53 DBMS_REPCAT

Summary of DBMS_REPCAT Subprograms

54 DBMS_REPCAT_ADMIN

Summary of DBMS_REPCAT_ADMIN Subprograms

55 DBMS_REPCAT_INSTANTIATE

Summary of DBMS_REPCAT_INSTANTIATE Subprograms

56 DBMS_REPCAT_RGT

Summary of DBMS_REPCAT_RGT Subprograms

57 DBMS_REPUTIL

Summary of DBMS_REPUTIL Subprograms

58 DBMS_RESOURCE_MANAGER

Requirements

Summary of DBMS_RESOURE_MANAGER Subprograms

59 DBMS_RESOURCE_MANAGER_PRIVS

Summary of DBMS_RESOURCE_MANAGER_PRIVS Subprograms

60 DBMS_RESUMABLE

Summary of DBMS_RESUMABLE Subprograms

61 DBMS_RLS

Dynamic Predicates

Security

Usage Notes

Summary of DBMS_RLS Subprograms

62 DBMS_ROWID

Usage Notes

Requirements

ROWID Types

Exceptions

Summary of DBMS_ROWID Subprograms

63 DBMS_RULE

Summary of DBMS_RULE Subprograms

64 DBMS_RULE_ADM

Summary of DBMS_RULE_ADM Subprograms

65 DBMS_SESSION

Requirements

Summary of DBMS_SESSION Subprograms

66 DBMS_SHARED_POOL

Installation Notes

Usage Notes

Summary of DBMS_SHARED_POOL Subprograms

67 DBMS_SPACE

Security

Requirements

Summary of DBMS_SPACE Subprograms

68 DBMS_SPACE_ADMIN

Security

SYSTEM Tablespace Migration: Conditions

Constants for DBMS_SPACE_ADMIN Constants

Summary of DBMS_SPACE_ADMIN Subprograms

69 DBMS_SQL

Using DBMS_SQL

Constants, Types, and Exceptions for DBMS_SQL

Execution Flow

Security

Processing Queries

Examples

Processing Updates, Inserts, and Deletes

Locating Errors

Summary of DBMS_SQL Subprograms

70 DBMS_STATS

Using DBMS_STATS

Setting or Getting Statistics

Transferring Statistics

Gathering Optimizer Statistics

Summary of DBMS_STATS Subprograms

71 DBMS_STORAGE_MAP

Mapping Terminology

Summary of DBMS_STORAGE_MAP Subprograms

Usage Notes for DBMS_STORAGE_MAP Subprograms

72 DBMS_STREAMS

Summary of DBMS_STREAMS Subprograms

73 DBMS_STREAMS_ADM

Summary of DBMS_STREAMS_ADM Subprograms

74 DBMS_TRACE

Requirements, Restrictions, and Constants for DBMS_TRACE

Using DBMS_TRACE

Summary of DBMS_TRACE Subprograms

75 DBMS_TRANSACTION

Requirements

Summary of DBMS_TRANSACTION Subprograms

76 DBMS_TRANSFORM

Summary of DBMS_TRANSFORM Subprograms

77 DBMS_TTS

Exceptions

Summary of DBMS_TTS Subprograms

78 DBMS_TYPES

Constants for DBMS_TYPES

79 DBMS_UTILITY

Requirements and Types for DBMS_UTILITY

Summary of DBMS_UTILITY Subprograms

80 DBMS_WM

Summary of DBMS_WM Subprograms

81 DBMS_XDB

Description of DBMS_XDB

Functions and Procedures of DBMS_XDB

82 DBMS_XDBT

Description of BMS_XDBT

Functions and Procedures of BMS_XDBT

Customizing the DBMS_XDBT package

83 DBMS_XDB_VERSION

Description of DBMS_XDB_VERSION

Functions and Procedures of DBMS_XDB_VERSION

84 DBMS_XMLDOM

Description of DBMS_XMLDOM

Types of DBMS_XMLDOM

Defined Constants of DBMS_XMLDOM

Exceptions of DBMS_XMLDOM

Functions and Procedures of DBMS_XMLDOM

85 DBMS_XMLGEN

Description of DMS_XMLGEN

Functions and Procedures of DBMS_XMLGEN

86 DBMS_XMLPARSER

Description of DBMS_XMLPARSER

Functions and Procedures of DBMS_XMLPARSER

87 DBMS_XMLQUERY

Description of DBMS_XMLQuery

Types of DBMS_XMLQuery

Constants of DBMS_XMLQuery

Functions and Procedures of DBMS_XMLQuery

88 DBMS_XMLSAVE

Description of DBMS_XMLSave

Types of DBMS_XMLSave

Constants of DBMS_XMLSave

Functions and Procedures of DBMS_XMLSave

89 DBMS_XMLSchema

Description of DBMS_XMLSCHEMA

Constants of DBMS_XMLSCHEMA

Procedures and Functions of DBMS_XMLSCHEMA

Catalog Views

90 DBMS_XPLAN

Using DBMS_XPLAN

Summary of DBMS_XPLAN Subprograms

Usage Notes

91 DBMS_XSLPROCESSOR

Description of DBMS_XSLPROCESSOR

Subprograms of DBMS_XSLPROCESSOR

92 DEBUG_EXTPROC

Requirements and Installation Notes for DEBUG_EXTPROC

Using DEBUG_EXTPROC

Summary of DBMS_EXTPROC Subprograms

93 UTL_COLL

Summary of UTL_COLL Subprograms

94 UTL_ENCODE

Summary of UTL_ENCODE Subprograms

95 UTL_FILE

Security

File Ownership and Protections

Exceptions

Types

Summary of UTL_FILE Subprograms

96 UTL_HTTP

UTL_HTTP Constants, Types and Flow

UTL_HTTP Exceptions

UTL_HTTP Examples

Summary of UTL_HTTP Subprograms

97 UTL_INADDR

Exceptions

Summary of UTL_INADDR Subprograms

98 UTL_RAW

Usage Notes

Summary of UTL_RAW Subprograms

99 UTL_REF

Requirements

Datatypes, Exceptions, and Security for UTL_REF

Summary of UTL_REF Subprograms

100 UTL_SMTP

Exceptions, Limitations, and Reply Codes

Summary of UTL_SMTP Subprograms

Example

101 UTL_TCP

Exceptions

Example

Summary of UTL_TCP Subprograms

102 UTL_URL

Introduction to the UTL_URL Package

UTL_URL Exceptions

Summary of UTL_URL Subprograms

103 ANYDATA TYPE

Construction

Summary of ANYDATA Subprograms

104 ANYDATASET TYPE

Construction

Summary of ANYDATASET Subprograms

105 ANYTYPE TYPE

Summary of ANYTYPE Subprograms

106 Advanced Queuing Types

Advanced Queuing Types

107 JMS Types

Constants to Support the aq$_jms_message Type

Summary of JMS Types

Summary of JMS Type Member and Static Subprograms

Enqueuing Through the Oracle JMS Administrative Interface: Example

108 Logical Change Record Types

LCR$_DDL_RECORD Type

LCR$_ROW_RECORD Type

Common Subprograms for LCR$_ROW_RECORD and LCR$_DDL_RECORD

LCR$_ROW_LIST Type

LCR$_ROW_UNIT Type

109 Rule Types

Rule Types

Index