Contents

Title and Copyright Information

Preface

Changes in This Release for Oracle Database PL/SQL Packages and Types Reference

1 Introduction to Oracle Supplied PL/SQL Packages & Types

2 APEX_CUSTOM_AUTH

3 APEX_APPLICATION

4 APEX_ITEM

5 APEX_UTIL

6 CTX_ADM

7 CTX_ANL

8 CTX_CLS

9 CTX_DDL

10 CTX_DOC

11 CTX_ENTITY

12 CTX_OUTPUT

13 CTX_QUERY

14 CTX_REPORT

15 CTX_THES

16 CTX_ULEXER

17 DBMS_ADDM

18 DBMS_ADVANCED_REWRITE

19 DBMS_ADVISOR

20 DBMS_ALERT

21 DBMS_APP_CONT

22 DBMS_APPLICATION_INFO

23 DBMS_APPLY_ADM

24 DBMS_AQ

25 DBMS_AQADM

26 DBMS_AQELM

27 DBMS_AQIN

28 DBMS_ASSERT

29 DBMS_AUDIT_MGMT

30 DBMS_AUTO_SQLTUNE

31 DBMS_AUTO_REPORT

32 DBMS_AUTO_TASK_ADMIN

33 DBMS_AW_STATS

34 DBMS_CAPTURE_ADM

35 DBMS_COMPARISON

36 DBMS_COMPRESSION

37 DBMS_CONNECTION_POOL

38 DBMS_CQ_NOTIFICATION

39 DBMS_CREDENTIAL

40 DBMS_CRYPTO

41 DBMS_CSX_ADMIN

42 DBMS_CUBE

43 DBMS_CUBE_ADVISE

44 DBMS_CUBE_LOG

45 DBMS_DATA_MINING

46 DBMS_DATA_MINING_TRANSFORM

47 DBMS_DATAPUMP

48 DBMS_DBFS_CONTENT

49 DBMS_DBFS_CONTENT_SPI

50 DBMS_DBFS_HS

51 DBMS_DBFS_SFS

52 DBMS_DB_VERSION

53 DBMS_DEBUG

54 DBMS_DDL

55 DBMS_DEFER

56 DBMS_DEFER_QUERY

57 DBMS_DEFER_SYS

58 DBMS_DESCRIBE

59 DBMS_DG

60 DBMS_DIMENSION

61 DBMS_DNFS

62 DBMS_DST

63 DBMS_DISTRIBUTED_TRUST_ADMIN

64 DBMS_EDITIONS_UTILITIES

65 DBMS_EPG

66 DBMS_ERRLOG

67 DBMS_FGA

68 DBMS_FILE_GROUP

69 DBMS_FILE_TRANSFER

70 DBMS_FLASHBACK

71 DBMS_FLASHBACK_ARCHIVE

72 DBMS_GOLDENGATE_AUTH

73 DBMS_FREQUENT_ITEMSET

74 DBMS_HEAT_MAP

75 DBMS_HM

76 DBMS_HPROF

77 DBMS_HS_PARALLEL

78 DBMS_HS_PASSTHROUGH

79 DBMS_ILM

80 DBMS_ILM_ADMIN

81 DBMS_INMEMORY

82 DBMS_IOT

83 DBMS_JAVA

84 DBMS_JOB

85 DBMS_LDAP

86 DBMS_LDAP_UTL

87 DBMS_LIBCACHE

88 DBMS_LOB

89 DBMS_LOCK

90 DBMS_LOGMNR

91 DBMS_LOGMNR_D

92 DBMS_LOGSTDBY

93 DBMS_LOGSTDBY_CONTEXT

94 DBMS_METADATA

95 DBMS_METADATA_DIFF

96 DBMS_MGD_ID_UTL

97 DBMS_MGWADM

98 DBMS_MGWMSG

99 DBMS_MONITOR

100 DBMS_MVIEW

101 DBMS_NETWORK_ACL_ADMIN

102 DBMS_NETWORK_ACL_UTILITY

103 DBMS_ODCI

104 DBMS_OFFLINE_OG

105 DBMS_OUTLN

106 DBMS_OUTPUT

107 DBMS_PARALLEL_EXECUTE

108 DBMS_PART

109 DBMS_PCLXUTIL

110 DBMS_PDB

111 DBMS_PERF

112 DBMS_PIPE

113 DBMS_PREDICTIVE_ANALYTICS

114 DBMS_PREPROCESSOR

115 DBMS_PRIVILEGE_CAPTURE

116 DBMS_PROFILER

117 DBMS_PROPAGATION_ADM

118 DBMS_QOPATCH

119 DBMS_RANDOM

120 DBMS_RECTIFIER_DIFF

121 DBMS_REDACT

122 DBMS_REDEFINITION

123 DBMS_REFRESH

124 DBMS_REPAIR

125 DBMS_REPCAT

126 DBMS_REPCAT_ADMIN

127 DBMS_REPCAT_INSTANTIATE

128 DBMS_REPCAT_RGT

129 DBMS_REPUTIL

130 DBMS_RESCONFIG

131 DBMS_RESOURCE_MANAGER

132 DBMS_RESOURCE_MANAGER_PRIVS

133 DBMS_RESULT_CACHE

134 DBMS_RESUMABLE

135 DBMS_RLS

136 DBMS_ROLLING

137 DBMS_ROWID

138 DBMS_RULE

139 DBMS_RULE_ADM

140 DBMS_SCHEDULER

141 DBMS_SERVER_ALERT

142 DBMS_SERVICE

143 DBMS_SESSION

144 DBMS_SHARED_POOL

145 DBMS_SPACE

146 DBMS_SPACE_ADMIN

147 DBMS_SPD

148 DBMS_SPM

149 DBMS_SQL

150 DBMS_SQL_TRANSLATOR

151 DBMS_SQL_MONITOR

152 DBMS_SQLDIAG

153 DBMS_SQLPA

154 DBMS_SQLTUNE

155 DBMS_STATS

156 DBMS_STAT_FUNCS

157 DBMS_STORAGE_MAP

158 DBMS_STREAMS

159 DBMS_STREAMS_ADM

160 DBMS_STREAMS_ADVISOR_ADM

161 DBMS_STREAMS_AUTH

162 DBMS_STREAMS_HANDLER_ADM

163 DBMS_STREAMS_MESSAGING

164 DBMS_STREAMS_TABLESPACE_ADM

165 DBMS_SYNC_REFRESH

166 DBMS_TDB

167 DBMS_TRACE

168 DBMS_TRANSACTION

169 DBMS_TRANSFORM

170 DBMS_TSDP_MANAGE

171 DBMS_TSDP_PROTECT

172 DBMS_TTS

173 DBMS_TYPES

174 DBMS_UTILITY

175 DBMS_WARNING

176 DBMS_WM

177 DBMS_WORKLOAD_CAPTURE

178 DBMS_WORKLOAD_REPLAY

179 DBMS_WORKLOAD_REPOSITORY

180 DBMS_XA

181 DBMS_XDB

182 DBMS_XDB_ADMIN

183 DBMS_XDB_CONFIG

184 DBMS_XDB_CONSTANTS

185 DBMS_XDB_REPOS

186 DBMS_XDB_VERSION

187 DBMS_XDBRESOURCE

188 DBMS_XDBT

189 DBMS_XDBZ

190 DBMS_XEVENT

191 DBMS_XMLDOM

192 DBMS_XMLGEN

193 DBMS_XMLINDEX

194 DBMS_XMLPARSER

195 DBMS_XMLQUERY

196 DBMS_XMLSAVE

197 DBMS_XMLSCHEMA

198 DBMS_XMLSCHEMA_ANNOTATE

199 DBMS_XMLSTORAGE_MANAGE

200 DBMS_XMLSTORE

201 DBMS_XMLTRANSLATIONS

202 DBMS_XPLAN

203 DBMS_XSLPROCESSOR

204 DBMS_XSTREAM_ADM

205 DBMS_XSTREAM_AUTH

206 DEBUG_EXTPROC

207 HTF

208 HTP

209 ORD_DICOM

210 ORD_DICOM_ADMIN

211 OWA_CACHE

212 OWA_COOKIE

213 OWA_CUSTOM

214 OWA_IMAGE

215 OWA_OPT_LOCK

216 OWA_PATTERN

217 OWA_SEC

218 OWA_TEXT

219 OWA_UTIL

220 SDO_CS

221 SDO_CSW_PROCESS

222 SDO_GCDR

223 SDO_GEOM

224 SDO_GEOR

225 SDO_GEOR_ADMIN

226 SDO_GEOR_AGGR

227 SDO_GEOR_RA

228 SDO_GEOR_UTL

229 SDO_LRS

230 SDO_MIGRATE

231 SDO_NET

232 SDO_OLS

233 SDO_PC_PKG

234 SDO_SAM

235 SDO_TIN_PKG

236 SDO_TOPO

237 SDO_TOPO_MAP

238 SDO_TUNE

239 SDO_UTIL

240 SDO_WFS_LOCK

241 SDO_WFS_PROCESS

242 SEM_APIS

243 SEM_OLS

244 SEM_PERF

245 SEM_RDFCTX

246 SEM_RDFSA

247 UTL_CALL_STACK

248 UTL_COLL

249 UTL_COMPRESS

250 UTL_ENCODE

251 UTL_FILE

252 UTL_HTTP

253 UTL_I18N

254 UTL_INADDR

255 UTL_IDENT

256 UTL_LMS

257 UTL_MAIL

258 UTL_MATCH

259 UTL_NLA

260 UTL_RAW

261 UTL_RECOMP

262 UTL_REF

263 UTL_SMTP

264 UTL_SPADV

265 UTL_TCP

266 UTL_URL

267 WPG_DOCLOAD

268 ANYDATA TYPE

269 ANYDATASET TYPE

270 ANYTYPE TYPE

271 Oracle Database Advanced Queuing (AQ) Types

272 DBFS Content Interface Types

273 Database URI TYPEs

274 JMS Types

275 Logical Change Record TYPEs

276 Oracle Multimedia ORDAudio TYPE

277 Oracle Multimedia ORDDicom TYPE

278 Oracle Multimedia ORDDoc TYPE

279 Oracle Multimedia ORDImage TYPE

280 Oracle Multimedia SQL/MM Still Image TYPES

281 Oracle Multimedia ORDVideo TYPE

282 MGD_ID Package Types

283 Rule TYPEs

284 UTL Streams Types

285 XMLTYPE

Index