Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Related Documentation

Conventions

Documentation Accessibility

What's New 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_AQ

Java Classes

Enumerated Constants

Data Structures for DBMS_AQ

Summary of Subprograms

5 DBMS_AQADM

Enumerated Constants

Summary of DBMS_AQADM Subprograms

6 DBMS_AQELM

Summary of DBMS_AQELM Subprograms

7 DBMS_BACKUP_RESTORE

Filename Normalization for Oracle on Windows NT Platforms

8 DBMS_DDL

Summary of DBMS_DDL Subprograms

9 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

10 DBMS_DEFER

Summary of DBMS_DEFER Subprograms

11 DBMS_DEFER_QUERY

Summary of DBMS_DEFER_QUERY Subprograms

12 DBMS_DEFER_SYS

Summary of DBMS_DEFER_SYS Subprograms

13 DBMS_DESCRIBE

Security, Types, and Errors for DBMS_DESCRIBE

Summary of DBMS_DESCRIBE Subprograms

14 DBMS_DISTRIBUTED_TRUST_ADMIN

Requirements

Summary of DBMS_DISTRIBUTED_TRUST_ADMIN Subprograms

15 DBMS_FGA

Summary of DBMS_FGA Subprogram

16 DBMS_FLASHBACK

DBMS_FLASHBACK Error Messages

DBMS_FLASHBACK Example

Summary of DBMS_FLASHBACK Subprograms

17 DBMS_HS_PASSTHROUGH

Security

Summary of DBMS_HS_PASSTHROUGH Subprograms

18 DBMS_IOT

Summary of DBMS_IOT Subprograms

19 DBMS_JOB

Requirements

Using the DBMS_JOB Package with Oracle Parallel Server

Summary of DBMS_JOB Subprograms

20 DBMS_LDAP

Exception Summary

Summary of Data Types

Summary of DBMS_LDAP Subprograms

21 DBMS_LIBCACHE

Requirements

Summary of DBMS_LIBCACHE Subprograms

22 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

23 DBMS_LOCK

Requirements, Security, and Constants for DBMS_LOCK

Summary of DBMS_LOCK Subprograms

24 DBMS_LOGMNR

DBMS_LOGMNR Constants

Extracting Data Values From Redo Log Files

Example of Using DBMS_LOGMNR

Summary of DBMS_LOGMNR Subprograms

25 DBMS_LOGMNR_CDC_PUBLISH

Publishing Change Data

Summary of DBMS_LOGMNR_CDC_PUBLISH Subprograms

26 DBMS_LOGMNR_CDC_SUBSCRIBE

Subscribing to Change Data

Summary of DBMS_LOGMNR_CDC_SUBSCRIBE Subprograms

27 DBMS_LOGMNR_D

Extracting a Dictionary to the Redo Log Files

Extracting a Dictionary to a Flat File

Examples of Using DBMS_LOGMNR_D.BUILD

Summary of DBMS_LOGMNR_D Subprograms

28 DBMS_METADATA

Summary of DBMS_METADATA Subprograms

29 DBMS_MVIEW

Summary of DBMS_MVIEW Subprograms

30 DBMS_OBFUSCATION_TOOLKIT

Overview of Key Management

Summary of DBMS_OBFUSCATION Subprograms

31 DBMS_ODCI

Summary of DBMS_ODCI Subprograms

32 DBMS_OFFLINE_OG

Summary of DBMS_OFFLINE_OG Subprograms

33 DBMS_OFFLINE_SNAPSHOT

Summary of DBMS_OFFLINE_SNAPSHOT Subprograms

34 DBMS_OLAP

Requirements

Error Messages

Summary of DBMS_OLAP Subprograms

DBMS_OLAP Interface Views

35 DBMS_ORACLE_TRACE_AGENT

Security

Summary of DBMS_ORACLE_TRACE_AGENT Subprograms

36 DBMS_ORACLE_TRACE_USER

Summary of DBMS_ORACLE_TRACE_USER Subprograms

37 DBMS_OUTLN

Requirements and Security for DBMS_OUTLN

Summary of DBMS_OUTLN Subprograms

38 DBMS_OUTLN_EDIT

Summary of DBMS_OUTLN_EDIT Subprograms

39 DBMS_OUTPUT

Security, Errors, and Types for DBMS_OUTPUT

Using DBMS_OUTPUT

Summary of DBMS_OUTPUT Subprograms

40 DBMS_PCLXUTIL

Using DBMS_PCLXUTIL

Limitations

Summary of DBMS_PCLUTTL Subprograms

41 DBMS_PIPE

Public Pipes, Private Pipes, and Pipe Uses

Security, Constants, and Errors

Summary of DBMS_PIPE Subprograms

42 DBMS_PROFILER

Using DBMS_PROFILER

Requirements

Security

Exceptions

Error Codes

Summary of DBMS_PROFILER Subprograms

43 DBMS_RANDOM

Requirements

Summary of DBMS_RANDOM Subprograms

44 DBMS_RECTIFIER_DIFF

Summary of DBMS_RECTIFIER_DIFF Subprograms

45 DBMS_REDEFINITION

Summary of DBMS_REDEFINITION Subprograms

46 DBMS_REFRESH

Summary of DBMS_REFRESH Subprograms

47 DBMS_REPAIR

Security, Enumeration Types, and Exceptions

Summary of DBMS_REPAIR Subprograms

48 DBMS_REPCAT

Summary of DBMS_REPCAT Subprograms

49 DBMS_REPCAT_ADMIN

Summary of DBMS_REPCAT_ADMIN Subprograms

50 DBMS_REPCAT_INSTANTIATE

Summary of DBMS_REPCAT_INSTANTIATE Subprograms

51 DBMS_REPCAT_RGT

Summary of DBMS_REPCAT_RGT Subprograms

52 DBMS_REPUTIL

Summary of DBMS_REPUTIL Subprograms

53 DBMS_RESOURCE_MANAGER

Requirements

Summary of DBMS_RESOURE_MANAGER Subprograms

54 DBMS_RESOURCE_MANAGER_PRIVS

Summary of DBMS_RESOURCE_MANAGER_PRIVS Subprograms

55 DBMS_RESUMABLE

Summary of DBMS_RESUMABLE Subprograms

56 DBMS_RLS

Dynamic Predicates

Security

Usage Notes

Summary of DBMS_RLS Subprograms

57 DBMS_ROWID

Usage Notes

Requirements

ROWID Types

Exceptions

Summary of DBMS_ROWID Subprograms

58 DBMS_SESSION

Requirements

Summary of DBMS_SESSION Subprograms

59 DBMS_SHARED_POOL

Installation Notes

Usage Notes

Summary of DBMS_SHARED_POOL Subprograms

60 DBMS_SPACE

Security

Requirements

Summary of DBMS_SPACE Subprograms

61 DBMS_SPACE_ADMIN

Security and Constants for DBMS_SPACE_ADMIN

Summary of DBMS_SPACE_ADMIN Subprograms

62 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

63 DBMS_STATS

Using DBMS_STATS

Setting or Getting Statistics

Gathering Optimizer Statistics

Transferring Statistics

Summary of DBMS_STATS Subprograms

64 DBMS_TRACE

Requirements, Restrictions, and Constants for DBMS_TRACE

Using DBMS_TRACE

Summary of DBMS_TRACE Subprograms

65 DBMS_TRANSACTION

Requirements

Summary of DBMS_TRANSACTION Subprograms

66 DBMS_TRANSFORM

Summary of DBMS_TRANSFORM Subprograms

67 DBMS_TTS

Exceptions

Summary of DBMS_TTS Subprograms

68 DBMS_TYPES

Constants for DBMS_TYPES

69 DBMS_UTILITY

Requirements and Types for DBMS_UTILITY

Summary of DBMS_UTILITY Subprograms

70 DBMS_WM

Summary of DBMS_WM Subprograms

71 DBMS_XMLGEN

Summary of DBMS_XMLGEN Subprograms

72 DBMS_XMLQUERY

Summary of DBMS_XMLQUERY Subprograms

73 DBMS_XMLSAVE

Summary of DBMS_XMLSAVE Subprograms

74 DEBUG_EXTPROC

Requirements and Installation Notes for DEBUG_EXTPROC

Using DEBUG_EXTPROC

Summary of DBMS_EXTPROC Subprograms

75 UTL_COLL

Summary of UTL_COLL Subprograms

76 UTL_ENCODE

Summary of UTL_ENCODE Subprograms

77 UTL_FILE

Security

File Ownership and Protections

Types

Exceptions

Summary of UTL_FILE Subprograms

78 UTL_HTTP

UTL_HTTP Constants, Types and Flow

UTL_HTTP Exceptions

UTL_HTTP Examples

Summary of UTL_HTTP Subprograms

79 UTL_INADDR

Exceptions

Summary of UTL_INADDR Subprograms

80 UTL_RAW

Usage Notes

Summary of UTL_RAW Subprograms

81 UTL_REF

Requirements

Datatypes, Exceptions, and Security for UTL_REF

Summary of UTL_REF Subprograms

82 UTL_SMTP

Example

Exceptions, Limitations, and Reply Codes

Summary of UTL_SMTP Subprograms

83 UTL_TCP

Exceptions

Example

Summary of UTL_TCP Subprograms

84 UTL_URL

Introduction to the UTL_URL Package

UTL_URL Exceptions

Summary of UTL_URL Subprograms

85 ANYDATA TYPE

Construction

Summary of ANYDATA Subprograms

86 ANYDATASET TYPE

Construction

Summary of ANYDATASET Subprograms

87 ANYTYPE TYPE

Summary of ANYTYPE Subprograms

Index