Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

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

Oracle Database 10g Release 1 (10.1) New Features

Oracle9i Release 2 (9.2) New Features

Oracle9i Release 1 (9.0.1) New Features

Oracle8i Release 2 (8.1.6) New Features

Oracle8i Release 1 (8.1.5) New Features

This book was new for release 8.1.5.

1 Introduction

Package Overview

Abbreviations for Datetime and Interval Datatypes

Summary of Oracle Supplied PL/SQL Packages

2 CTX_ADM

Documentation of CTX_ADM

3 CTX_CLS

Documentation of CTX_CLS

4 CTX_DDL

Documentation of CTX_DDL

5 CTX_DOC

Documentation of CTX_DOC

6 CTX_OUTPUT

Documentation of CTX_OUTPUT

7 CTX_QUERY

Documentation of CTX_QUERY

8 CTX_REPORT

Documentation of CTX_REPORT

9 CTX_THES

Documentation of CTX_THES

10 CTX_ULEXER

Documentation of CTX_ULEXER

11 DBMS_ADVANCED_REWRITE

Using DBMS_ADVANCED_REWRITE

Summary of DBMS_ADVANCED_REWRITE Subprograms

12 DBMS_ADVISOR

Using DBMS_ADVISOR

Summary of DBMS_ADVISOR Subprograms

13 DBMS_ALERT

Using DBMS_ALERT

Summary of DBMS_ALERT Subprograms

14 DBMS_APPLICATION_INFO

Using DBMS_APPLICATION_INFO

Summary of DBMS_APPLICATION_INFO Subprograms

15 DBMS_APPLY_ADM

Summary of DBMS_APPLY_ADM Subprograms

16 DBMS_AQ

Using DBMS_AQ

Summary of DBMS_AQ Subprograms

17 DBMS_AQADM

Using DBMS_AQADM

Summary of DBMS_AQADM Subprograms

18 DBMS_AQELM

Summary of DBMS_AQELM Subprograms

19 DBMS_CAPTURE_ADM

Summary of DBMS_CAPTURE_ADM Subprograms

20 DBMS_CDC_PUBLISH

Using DBMS_CDC_PUBLISH

Summary of DBMS_CDC_PUBLISH Subprograms

21 DBMS_CDC_SUBSCRIBE

Using DBMS_CDC_SUBSCRIBE

Summary of DBMS_CDC_SUBSCRIBE Subprograms

22 DBMS_CRYPTO

Using the DBMS_CRYPTO Subprograms

Summary of DBMS_CRYPTO Subprograms

23 DBMS_DATA_MINING

Using DBMS_DATA_MINING

Summary of DBMS_DATA_MINING Subprograms

24 DBMS_DATA_MINING_TRANSFORM

Using DBMS_DATA_MINING_TRANSFORM

Summary of DBMS_DATA_MINING_TRANSFORM Subprograms

25 DBMS_DATAPUMP

Using DBMS_DATAPUMP

Summary of DBMS_DATAPUMP Subprograms

26 DBMS_DDL

Using DBMS_DDL

Summary of DBMS_DDL Subprograms

27 DBMS_DEBUG

Using DBMS_DEBUG

Summary of DBMS_DEBUG Subprograms

28 DBMS_DEFER

Documentation of DBMS_DEFER

29 DBMS_DEFER_QUERY

Documentation of DBMS_DEFER_QUERY

30 DBMS_DEFER_SYS

Documentation of DBMS_DEFER_SYS

31 DBMS_DESCRIBE

Using DBMS_DESCRIBE

Summary of DBMS_DESCRIBE Subprograms

32 DBMS_DIMENSION

Using DBMS_DIMENSION

Summary of DBMS_DIMENSION Subprograms

33 DBMS_DISTRIBUTED_TRUST_ADMIN

Using DBMS_DISTRIBUTED_TRUST_ADMIN

Summary of DBMS_DISTRIBUTED_TRUST_ADMIN Subprograms

34 DBMS_FGA

Using DBMS_FGA

Summary of DBMS_FGA Subprograms

35 DBMS_FILE_TRANSFER

Summary of DBMS_FILE_TRANSFER Subprograms

36 DBMS_FLASHBACK

Using DBMS_FLASHBACK

Summary of DBMS_FLASHBACK Subprograms

37 DBMS_FREQUENT_ITEMSET

Summary of DBMS_FREQUENT_ITEMSET Subprograms

38 DBMS_HS_PASSTHROUGH

Summary of DBMS_HS_PASSTHROUGH Subprograms

39 DBMS_IOT

Summary of DBMS_IOT Subprograms

40 DBMS_JAVA

Documentation of DBMS_JAVA

41 DBMS_JOB

Using DBMS_JOB

Summary of DBMS_JOB Subprograms

42 DBMS_LDAP

Documentation of DBMS_LDAP

43 DBMS_LDAP_UTL

Documentation of DBMS_LDAP_UTL

44 DBMS_LIBCACHE

Using DBMS_LIBCACHE

Summary of DBMS_LIBCACHE Subprograms

45 DBMS_LOB

Using DBMS_LOB

Summary of DBMS_LOB Subprograms

46 DBMS_LOCK

Using DBMS_LOCK

Summary of DBMS_LOCK Subprograms

47 DBMS_LOGMNR

Using DBMS_LOGMNR

Summary of DBMS_LOGMNR Subprograms

48 DBMS_LOGMNR_D

Using DBMS_LOGMNR_D

Summary of DBMS_LOGMNR_D Subprograms

49 DBMS_LOGSTDBY

Using DBMS_LOGSTBY

Summary of DBMS_LOGSTDBY Subprograms

50 DBMS_METADATA

Using DBMS_METADATA

Summary of DBMS_METADATA Subprograms

51 DBMS_MGWADM

Using DBMS_MGWADM

Summary of DBMS_MGWADM Subprograms

52 DBMS_MGWMSG

Using DBMS_MGWMSG

Summary of DBMS_MGWMSG Subprograms

53 DBMS_MONITOR

Summary of DBMS_MONITOR Subprograms

54 DBMS_MVIEW

Using DBMS_MVIEW

Summary of DBMS_MVIEW Subprograms

55 DBMS_OBFUSCATION_TOOLKIT

Using DBMS_OBFUSCATION_TOOLKIT

Summary of DBMS_OBFUSCATION Subprograms

56 DBMS_ODCI

Summary of DBMS_ODCI Subprograms

57 DBMS_OFFLINE_OG

Documentation of DBMS_OFFLINE_OG

58 DBMS_OLAP

Using DBMS_OLAP

Summary of DBMS_OLAP Subprograms

59 DBMS_OUTLN

Using DBMS_OUTLN

Summary of DBMS_OUTLN Subprograms

60 DBMS_OUTLN_EDIT

Summary of DBMS_OUTLN_EDIT Subprograms

61 DBMS_OUTPUT

Using DBMS_OUTPUT

Summary of DBMS_OUTPUT Subprograms

62 DBMS_PCLXUTIL

Using DBMS_PCLXUTIL

Summary of DBMS_PCLXUTIL Subprograms

63 DBMS_PIPE

Using DBMS_PIPE

Summary of DBMS_PIPE Subprograms

64 DBMS_PROFILER

Using DBMS_PROFILER

Summary of DBMS_PROFILER Subprograms

65 DBMS_PROPAGATION_ADM

Summary of DBMS_PROPAGATION_ADM Subprograms

66 DBMS_RANDOM

Using DBMS_RANDOM

Summary of DBMS_RANDOM Subprograms

67 DBMS_RECTIFIER_DIFF

Documentation of DBMS_RECTIFIER_DIFF

68 DBMS_REDEFINITION

Using DBMS_REDEFINITION

Summary of DBMS_REDEFINITION Subprograms

69 DBMS_REFRESH

Documentation of DBMS_REFRESH

70 DBMS_REPAIR

Using DBMS_REPAIR

Summary of DBMS_REPAIR Subprograms

71 DBMS_REPCAT

Documentation of DBMS_REPCAT

72 DBMS_REPCAT_ADMIN

Documentation of DBMS_REPCAT_ADMIN

73 DBMS_REPCAT_INSTANTIATE

Documentation of DBMS_REPCAT_INSTANTIATE

74 DBMS_REPCAT_RGT

Documentation of DBMS_REPCAT_RGT

75 DBMS_REPUTIL

Documentation of DBMS_REPUTIL

76 DBMS_RESOURCE_MANAGER

Using DBMS_RESOURCE_MANAGER

Summary of DBMS_RESOURCE_MANAGER Subprograms

77 DBMS_RESOURCE_MANAGER_PRIVS

Summary of DBMS_RESOURCE_MANAGER_PRIVS Subprograms

78 DBMS_RESUMABLE

Using DBMS_RESUMABLE

Summary of DBMS_RESUMABLE Subprograms

79 DBMS_RLS

Using DBMS_RLS

Summary of DBMS_RLS Subprograms

80 DBMS_ROWID

Using DBMS_ROWID

Summary of DBMS_ROWID Subprograms

81 DBMS_RULE

Using DBMS_RULE

Summary of DBMS_RULE Subprograms

82 DBMS_RULE_ADM

Using DBMS_RULE_ADM

Summary of DBMS_RULE_ADM Subprograms

83 DBMS_SCHEDULER

Using DBMS_SCHEDULER

Summary of DBMS_SCHEDULER Subprograms

84 DBMS_SERVER_ALERT

Using DBMS_SERVER_ALERT

Summary of DBMS_SERVER_ALERT Subprograms

85 DBMS_SERVICE

Using DBMS_SERVICE

Summary of DBMS_SERVICE Subprograms

86 DBMS_SESSION

Using DBMS_SESSION

Summary of DBMS_SESSION Subprograms

87 DBMS_SHARED_POOL

Using DBMS_SHARED_POOL

Summary of DBMS_SHARED_POOL Subprograms

88 DBMS_SPACE

Using DBMS_SPACE

Summary of DBMS_SPACE Subprograms

89 DBMS_SPACE_ADMIN

Using DBMS_SPACE_ADMIN

Summary of DBMS_SPACE_ADMIN Subprograms

90 DBMS_SQL

Using DBMS_SQL

Summary of DBMS_SQL Subprograms

91 DBMS_SQLTUNE

Using DBMS_SQLTUNE

Summary of DBMS_SQLTUNE Subprograms

92 DBMS_STAT_FUNCS

Summary of DBMS_STAT_FUNCS Subprograms

93 DBMS_STATS

Using DBMS_STATS

Summary of DBMS_STATS Subprograms

94 DBMS_STORAGE_MAP

Using DBMS_STORAGE_MAP

Summary of DBMS_STORAGE_MAP Subprograms

95 DBMS_STREAMS

Using DBMS_STREAMS

Summary of DBMS_STREAMS Subprograms

96 DBMS_STREAMS_ADM

Using DBMS_STREAMS_ADM

Summary of DBMS_STREAMS_ADM Subprograms

97 DBMS_STREAMS_AUTH

Summary of DBMS_STREAMS_AUTH Subprograms

98 DBMS_STREAMS_MESSAGING

Summary of DBMS_STREAMS_MESSAGING Subprograms

99 DBMS_STREAMS_TABLESPACE_ADM

Using DBMS_STREAMS_TABLESPACE_ADM

Summary of DBMS_STREAMS_TABLESPACE_ADM Subprograms

100 DBMS_TRACE

Using DBMS_TRACE

Summary of DBMS_TRACE Subprograms

101 DBMS_TRANSACTION

Using DBMS_TRANSACTION

Summary of DBMS_TRANSACTION Subprograms

102 DBMS_TRANSFORM

Summary of DBMS_TRANSFORM Subprograms

103 DBMS_TYPES

Using DBMS_TYPES

104 DBMS_UTILITY

Using DBMS_UTILITY

Summary of DBMS_UTILITY Subprograms

105 DBMS_WARNING

Using DBMS_WARNING

Summary of DBMS_WARNING Subprograms

106 DBMS_WORKLOAD_REPOSITORY

Summary of DBMS_WORKLOAD_REPOSITORY Subprograms

107 DBMS_WM

Documentation of DBMS_WM

108 DBMS_XDB

Using DBMS_XDB

Summary of DBMS_XDB Subprograms

109 DBMS_XDB_VERSION

Summary of DBMS_XDB_VERSION Subprograms

110 DBMS_TTS

Using DBMS_TTS

Summary of DBMS_TTS Subprograms

111 DBMS_XDBT

Using DBMS_XDBT

Summary of DBMS_XDBT Subprograms

112 DBMS_XDBZ

Summary of DBMS_XDBZ Subprograms

113 DBMS_XMLDOM

Using DBMS_XMLDOM

Subprogram Groups

Summary of DBMS_XMLDOM Subprograms

114 DBMS_XMLGEN

Summary of DBMS_XMLGEN Subprograms

115 DBMS_XMLPARSER

Summary of DBMS_XMLPARSER Subprograms

116 DBMS_XMLQUERY

Using DBMS_XMLQUERY

Summary of DBMS_XMLQUERY Subprograms

117 DBMS_XMLSAVE

Using DBMS_XMLSAVE

Summary of DBMS_XMLSAVE Subprograms

118 DBMS_XMLSCHEMA

Constants of DBMS_XMLSCHEMA

Summary of DBMS_XMLSCHEMA Subprograms

Catalog Views of the DBMS_XMLSCHEMA

119 DBMS_XMLSTORE

Using DBMS_XMLSTORE

Summary of DBMS_XMLSTORE Subprograms

120 DBMS_XPLAN

Using DBMS_XPLAN

Summary of DBMS_XPLAN Subprograms

121 DBMS_XSLPROCESSOR

Summary of DBMS_XSLPROCESSOR Subprograms

122 DEBUG_EXTPROC

Using DEBUG_EXTPROC

Summary of DEBUG_EXTPROC Subprograms

123 HTF

Using HTF

Summary of Tags

Summary of HTF Subprograms

124 HTMLDB_CUSTOM_AUTH

Documentation of HTMLDB_CUSTOM_AUTH

125 HTMLDB_APPLICATION

Documentation of HTMLDB_APPLICATION

126 HTMLDB_ITEM

Documentation of HTMLDB_ITEM

127 HTMLDB_UTIL

Documentation of HTMLDB_UTIL

128 HTP

Using HTP

Summary of Tags

Summary of HTP Subprograms

129 OWA_CACHE

Using OWA_CACHE

Summary of OWA_CACHE Subprograms

130 OWA_COOKIE

Using OWA_COOKIE

Summary of OWA_COOKIE Subprograms

131 OWA_CUSTOM

Using OWA_CUSTOM

Summary of OWA_CUSTOM Subprograms

132 OWA_IMAGE

Using OWA_IMAGE

Summary of OWA_IMAGE Subprograms

133 OWA_OPT_LOCK

Using OWA_OPT_LOCK

Summary of OWA_OPT_LOCK Subprograms

134 OWA_PATTERN

Using OWA_PATTERN

Summary of OWA_PATTERN Subprograms

135 OWA_SEC

Using OWA_SEC

Summary of OWA_SEC Subprograms

136 OWA_TEXT

Using OWA_TEXT

Summary of OWA_TEXT Subprograms

137 OWA_UTIL

Using OWA_UTIL

Summary of OWA_UTIL Subprograms

138 SDO_CS

Documentation of SDO_CS

139 SDO_GCDR

Documentation of SDO_GCDR

140 SDO_GEOM

Documentation of SDO_GEOM

141 SDO_GEOR

Documentation of SDO_GEOR

142 SDO_GEOR_UTL

Documentation of SDO_GEOR_UTL

143 SDO_LRS

Documentation of SDO_LRS

144 SDO_MIGRATE

Documentation of SDO_MIGRATE

145 SDO_NET

Documentation of SDO_NET

146 SDO_SAM

Documentation of SDO_SAM

147 SDO_TOPO

Documentation of SDO_TOPO

148 SDO_TOPO_MAP

Documentation of SDO_TOPO_MAP

149 SDO_TUNE

Documentation of SDO_TUNE

150 SDO_UTIL

Documentation of SDO_UTIL

151 UTL_COLL

Summary of UTL_COLL Subprograms

152 UTL_COMPRESS

Using UTL_COMPRESS

Summary of UTL_COMPRESS Subprograms

153 UTL_DBWS

Using UTL_DBWS

Summary of UTL_DBWS Subprograms

154 UTL_ENCODE

Summary of UTL_ENCODE Subprograms

155 UTL_FILE

Using UTL_FILE

Summary of UTL_FILE Subprograms

156 UTL_HTTP

Using UTL_HTTP

Subprogram Groups

Summary of UTL_HTTP Subprograms

157 UTL_I18N

Using UTL_I18n

Summary of UTL_I18N Subprograms

158 UTL_INADDR

Using UTL_INADDR

Summary of UTL_INADDR Subprograms

159 UTL_LMS

Using UTL_LMS

Summary of UTL_LMS Subprograms

160 UTL_MAIL

Using UTL_MAIL

Summary of UTL_MAIL Subprograms

161 UTL_RAW

Using UTL_RAW

Summary of UTL_RAW Subprograms

162 UTL_RECOMP

Using UTL_RECOMP

Summary of UTL_RECOMP Subprograms

163 UTL_REF

Using UTL_REF

Summary of UTL_REF Subprograms

164 UTL_SMTP

Using UTL_SMTP

Summary of UTL_SMTP Subprograms

165 UTL_TCP

Using UTL_TCP

Summary of UTL_TCP Subprograms

166 UTL_URL

Using UTL_URL

Summary of UTL_URL Subprograms

167 WPG_DOCLOAD

Using WPG_DOCLOAD

Summary of WPG_DOCLOAD Subprograms

168 ANYDATA TYPE

Using ANYDATA TYPE

Summary of ANYDATA Subprograms

169 ANYDATASET TYPE

Construction

Summary of ANYDATASET TYPE Subprograms

170 ANYTYPE TYPE

Summary of ANYTYPE Subprograms

171 Oracle Streams AQ TYPEs

Summary of Types

172 Database URI TYPEs

Summary of URITYPE Supertype Subprograms

Summary of HTTPURITYPE Subtype Subprograms

Summary of DBURITYPE Subtype Subprogams

Summary of XDBURITYPE Subtype Subprograms

Summary of URIFACTORY Package Subprograms

173 JMS Types

Using JMS Types

Summary of JMS Types

174 Logical Change Record TYPEs

Summary of Logical Change Record Types

Common Subprograms for LCR$_DDL_RECORD and LCR$_ROW_RECORD

175 interMedia ORDAudio TYPE

Documentation of ORDAudio

176 interMedia ORDDoc TYPE

Documentation of ORDDoc

177 interMedia ORDImage TYPE

Documentation of ORDImage

178 interMedia ORDImageSignature TYPE

Documentation of ORDImageSignature

179 interMedia SQL/MM Still Image TYPE

Documentation of SQL/MM Still Image

180 interMedia ORDVideo TYPE

Documentation of ORDVideo

181 Rule TYPEs

Summary of Rule Types

182 XMLTYPE

Summary of XMLType Subprograms

Index