Oracle9
i
Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
Part Number A89852-02
Home
Book List
Index
Master Index
Feedback
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?
Oracle9
i
Release 1 (9.0.1) New Features in Supplied PL/SQL Packages and Types
Oracle8
i
Release 2 (8.1.6) New Features in Supplied PL/SQL Packages
Oracle8
i
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
Copyright © 1996-2001, Oracle Corporation.
All Rights Reserved.
Home
Book List
Index
Master Index
Feedback