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 Oracle Application Express Packages APEX_APPLICATION Through APEX_ZIP

3 CTX_ADM

4 CTX_ANL

5 CTX_CLS

6 CTX_DDL

7 CTX_DOC

8 CTX_ENTITY

9 CTX_OUTPUT

10 CTX_QUERY

11 CTX_REPORT

12 CTX_THES

13 CTX_ULEXER

14 DBMS_ADDM

15 DBMS_ADVANCED_REWRITE

16 DBMS_ADVISOR

17 DBMS_ALERT

18 DBMS_APP_CONT

19 DBMS_APPLICATION_INFO

20 DBMS_APPLY_ADM

21 DBMS_AQ

22 DBMS_AQADM

23 DBMS_AQELM

24 DBMS_AQIN

25 DBMS_ASSERT

26 DBMS_AUDIT_MGMT

27 DBMS_AUDIT_UTIL

28 DBMS_AUTO_REPORT

29 DBMS_AUTO_SQLTUNE

30 DBMS_AUTO_TASK_ADMIN

31 DBMS_AW_STATS

32 DBMS_CAPTURE_ADM

33 DBMS_COMPARISON

34 DBMS_COMPRESSION

35 DBMS_CONNECTION_POOL

36 DBMS_CQ_NOTIFICATION

37 DBMS_CREDENTIAL

38 DBMS_CRYPTO

39 DBMS_CSX_ADMIN

40 DBMS_CUBE

41 DBMS_CUBE_ADVISE

42 DBMS_CUBE_LOG

43 DBMS_DATA_MINING

44 DBMS_DATA_MINING_TRANSFORM

45 DBMS_DATAPUMP

46 DBMS_DB_VERSION

47 DBMS_DBCOMP

48 DBMS_DBFS_CONTENT

49 DBMS_DBFS_CONTENT_SPI

50 DBMS_DBFS_HS

51 DBMS_DBFS_SFS

52 DBMS_DDL

53 DBMS_DEBUG

54 DBMS_DEBUG_JDWP

55 DBMS_DEBUG_JDWP_CUSTOM

56 DBMS_DESCRIBE

57 DBMS_DG

58 DBMS_DIMENSION

59 DBMS_DISTRIBUTED_TRUST_ADMIN

60 DBMS_DNFS

61 DBMS_DST

62 DBMS_EDITIONS_UTILITIES

63 DBMS_EPG

64 DBMS_ERRLOG

65 DBMS_FGA

66 DBMS_FILE_GROUP

67 DBMS_FILE_TRANSFER

68 DBMS_FLASHBACK

69 DBMS_FLASHBACK_ARCHIVE

70 DBMS_FREQUENT_ITEMSET

71 DBMS_FS

72 DBMS_GOLDENGATE_AUTH

73 DBMS_HADOOP

74 DBMS_HANG_MANAGER

75 DBMS_HEAT_MAP

76 DBMS_HIERARCHY

77 DBMS_HM

78 DBMS_HPROF

79 DBMS_HS_PARALLEL

80 DBMS_HS_PASSTHROUGH

81 DBMS_ILM

82 DBMS_ILM_ADMIN

83 DBMS_INMEMORY

84 DBMS_INMEMORY_ADMIN

85 DBMS_IOT

86 DBMS_JAVA

87 DBMS_JOB

88 DBMS_JSON

89 DBMS_LDAP

90 DBMS_LDAP_UTL

91 DBMS_LIBCACHE

92 DBMS_LOB

93 DBMS_LOCK

94 DBMS_LOGMNR

95 DBMS_LOGMNR_D

96 DBMS_LOGSTDBY

97 DBMS_LOGSTDBY_CONTEXT

98 DBMS_METADATA

99 DBMS_METADATA_DIFF

100 DBMS_MGD_ID_UTL

101 DBMS_MGWADM

102 DBMS_MGWMSG

103 DBMS_MONITOR

104 DBMS_MVIEW

105 DBMS_MVIEW_STATS

106 DBMS_NETWORK_ACL_ADMIN

107 DBMS_NETWORK_ACL_UTILITY

108 DBMS_ODCI

109 DBMS_OUTLN

110 DBMS_OUTPUT

111 DBMS_PARALLEL_EXECUTE

112 DBMS_PART

113 DBMS_PCLXUTIL

114 DBMS_PDB

115 DBMS_PDB_ALTER_SHARING

116 DBMS_PERF

117 DBMS_PIPE

118 DBMS_PLSQL_CODE_COVERAGE

119 DBMS_PREDICTIVE_ANALYTICS

120 DBMS_PREPROCESSOR

121 DBMS_PRIVILEGE_CAPTURE

122 DBMS_PROCESS

123 DBMS_PROFILER

124 DBMS_PROPAGATION_ADM

125 DBMS_QOPATCH

126 DBMS_RANDOM

127 DBMS_REDACT

128 DBMS_REDEFINITION

129 DBMS_REFRESH

130 DBMS_REPAIR

131 DBMS_RESCONFIG

132 DBMS_RESOURCE_MANAGER

133 DBMS_RESOURCE_MANAGER_PRIVS

134 DBMS_RESULT_CACHE

135 DBMS_RESUMABLE

136 DBMS_RLS

137 DBMS_ROLLING

138 DBMS_ROWID

139 DBMS_RULE

140 DBMS_RULE_ADM

141 DBMS_SCHEDULER

142 DBMS_SERVER_ALERT

143 DBMS_SERVICE

144 DBMS_SESSION

145 DBMS_SFW_ACL_ADMIN

146 DBMS_SHARED_POOL

147 DBMS_SPACE

148 DBMS_SPACE_ADMIN

149 DBMS_SPD

150 DBMS_SPM

151 DBMS_SQL

152 DBMS_SQL_MONITOR

153 DBMS_SQL_TRANSLATOR

154 DBMS_SQLDIAG

155 DBMS_SQLPA

156 DBMS_SQLTUNE

157 DBMS_STAT_FUNCS

158 DBMS_STATS

159 DBMS_STORAGE_MAP

160 DBMS_STREAMS

161 DBMS_STREAMS_ADM

162 DBMS_STREAMS_ADVISOR_ADM

163 DBMS_STREAMS_AUTH

164 DBMS_STREAMS_HANDLER_ADM

165 DBMS_STREAMS_MESSAGING

166 DBMS_STREAMS_TABLESPACE_ADM

167 DBMS_SYNC_REFRESH

168 DBMS_TDB

169 DBMS_TNS

170 DBMS_TRACE

171 DBMS_TRANSACTION

172 DBMS_TRANSFORM

173 DBMS_TSDP_MANAGE

174 DBMS_TSDP_PROTECT

175 DBMS_TTS

176 DBMS_TYPES

177 DBMS_UMF

178 DBMS_UTILITY

179 DBMS_WARNING

180 DBMS_WM

181 DBMS_WORKLOAD_CAPTURE

182 DBMS_WORKLOAD_REPLAY

183 DBMS_WORKLOAD_REPOSITORY

184 DBMS_XA

185 DBMS_XDB

186 DBMS_XDB_ADMIN

187 DBMS_XDB_CONFIG

188 DBMS_XDB_CONSTANTS

189 DBMS_XDB_REPOS

190 DBMS_XDB_VERSION

191 DBMS_XDBRESOURCE

192 DBMS_XDBT

193 DBMS_XDBZ

194 DBMS_XEVENT

195 DBMS_XMLDOM

196 DBMS_XMLGEN

197 DBMS_XMLINDEX

198 DBMS_XMLPARSER

199 DBMS_XMLQUERY

200 DBMS_XMLSAVE

201 DBMS_XMLSCHEMA

202 DBMS_XMLSCHEMA_ANNOTATE

203 DBMS_XMLSTORAGE_MANAGE

204 DBMS_XMLSTORE

205 DBMS_XMLTRANSLATIONS

206 DBMS_XPLAN

207 DBMS_XSLPROCESSOR

208 DBMS_XSTREAM_ADM

209 DBMS_XSTREAM_AUTH

210 DEBUG_EXTPROC

211 HTF

212 HTP

213 ORD_AUDIO

214 ORD_DICOM

215 ORD_DICOM_ADMIN

216 ORD_DOC

217 ORD_IMAGE

218 ORD_VIDEO

219 OWA_CACHE

220 OWA_COOKIE

221 OWA_CUSTOM

222 OWA_IMAGE

223 OWA_OPT_LOCK

224 OWA_PATTERN

225 OWA_SEC

226 OWA_TEXT

227 OWA_UTIL

228 SDO_CS

229 SDO_CSW_PROCESS

230 SDO_GCDR

231 SDO_GEOM

232 SDO_GEOR

233 SDO_GEOR_ADMIN

234 SDO_GEOR_AGGR

235 SDO_GEOR_RA

236 SDO_GEOR_UTL

237 SDO_LRS

238 SDO_MIGRATE

239 SDO_NET

240 SDO_NFE

241 SDO_OLS

242 SDO_PC_PKG

243 SDO_SAM

244 SDO_TIN_PKG

245 SDO_TOPO

246 SDO_TOPO_MAP

247 SDO_TUNE

248 SDO_UTIL

249 SDO_WFS_LOCK

250 SDO_WFS_PROCESS

251 SEM_APIS

252 SEM_OLS

253 SEM_PERF

254 SEM_RDFCTX

255 SEM_RDFSA

256 UTL_CALL_STACK

257 UTL_COLL

258 UTL_COMPRESS

259 UTL_ENCODE

260 UTL_FILE

261 UTL_HTTP

262 UTL_I18N

263 UTL_IDENT

264 UTL_INADDR

265 UTL_LMS

266 UTL_MAIL

267 UTL_MATCH

268 UTL_NLA

269 UTL_RAW

270 UTL_RECOMP

271 UTL_REF

272 UTL_SMTP

273 UTL_SPADV

274 UTL_TCP

275 UTL_URL

276 WPG_DOCLOAD

277 ANYDATA TYPE

278 ANYDATASET TYPE

279 ANYTYPE TYPE

280 Oracle Database Advanced Queuing (AQ) Types

281 DBFS Content Interface Types

282 Database URI TYPEs

283 JMS Types

284 JSON Data Structures

285 Logical Change Record TYPEs

286 Oracle Multimedia ORDAudio TYPE

287 Oracle Multimedia ORDDicom TYPE

288 Oracle Multimedia ORDDoc TYPE

289 Oracle Multimedia ORDImage TYPE

290 Oracle Multimedia SQL/MM Still Image TYPES (Deprecated)

291 Oracle Multimedia ORDVideo TYPE

292 MGD_ID Package Types

293 Rule TYPEs

294 UTL Streams Types

295 XMLTYPE

Index