Contents

Title and Copyright Information

Preface

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

8 CTX_DDL

9 CTX_DOC

10 CTX_ENTITY

11 CTX_OUTPUT

12 CTX_QUERY

13 CTX_REPORT

14 CTX_THES

15 CTX_ULEXER

16 DBMS_ADDM

17 DBMS_ADVANCED_REWRITE

18 DBMS_ADVISOR

19 DBMS_ALERT

20 DBMS_APPLICATION_INFO

21 DBMS_APPLY_ADM

22 DBMS_AQ

23 DBMS_AQADM

24 DBMS_AQELM

25 DBMS_AQIN

26 DBMS_ASSERT

27 DBMS_AUDIT_MGMT

28 DBMS_AUTO_SQLTUNE

29 DBMS_AUTO_TASK_ADMIN

30 DBMS_AUTO_TASK_IMMEDIATE

31 DBMS_AW_STATS

32 DBMS_CAPTURE_ADM

33 DBMS_CDC_PUBLISH

34 DBMS_CDC_SUBSCRIBE

35 DBMS_COMPARISON

36 DBMS_COMPRESSION

37 DBMS_CONNECTION_POOL

38 DBMS_CQ_NOTIFICATION

39 DBMS_CRYPTO

40 DBMS_CSX_ADMIN

41 DBMS_CUBE

42 DBMS_CUBE_ADVISE

43 DBMS_CUBE_LOG

44 DBMS_DATA_MINING

45 DBMS_DATA_MINING_TRANSFORM

46 DBMS_DATAPUMP

47 DBMS_DBFS_CONTENT

48 DBMS_DBFS_CONTENT_SPI

49 DBMS_DBFS_HS

50 DBMS_DBFS_SFS

51 DBMS_DB_VERSION

52 DBMS_DEBUG

53 DBMS_DDL

54 DBMS_DEFER

55 DBMS_DEFER_QUERY

56 DBMS_DEFER_SYS

57 DBMS_DESCRIBE

58 DBMS_DG

59 DBMS_DIMENSION

60 DBMS_DST

61 DBMS_DISTRIBUTED_TRUST_ADMIN

62 DBMS_EDITIONS_UTILITIES

63 DBMS_EPG

64 DBMS_ERRLOG

65 DBMS_EXPFIL

66 DBMS_FGA

67 DBMS_FILE_GROUP

68 DBMS_FILE_TRANSFER

69 DBMS_FLASHBACK

70 DBMS_FLASHBACK_ARCHIVE

71 DBMS_FREQUENT_ITEMSET

72 DBMS_HM

73 DBMS_HPROF

74 DBMS_HS_PARALLEL

75 DBMS_HS_PASSTHROUGH

76 DBMS_IOT

77 DBMS_JAVA

78 DBMS_JOB

79 DBMS_LDAP

80 DBMS_LDAP_UTL

81 DBMS_LIBCACHE

82 DBMS_LOB

83 DBMS_LOCK

84 DBMS_LOGMNR

85 DBMS_LOGMNR_D

86 DBMS_LOGSTDBY

87 DBMS_METADATA

88 DBMS_METADATA_DIFF

89 DBMS_MGD_ID_UTL

90 DBMS_MGWADM

91 DBMS_MGWMSG

92 DBMS_MONITOR

93 DBMS_MVIEW

94 DBMS_NETWORK_ACL_ADMIN

95 DBMS_NETWORK_ACL_UTILITY

96 DBMS_OBFUSCATION_TOOLKIT

97 DBMS_ODCI

98 DBMS_OFFLINE_OG

99 DBMS_OUTLN

100 DBMS_OUTPUT

101 DBMS_PARALLEL_EXECUTE

102 DBMS_PCLXUTIL

103 DBMS_PIPE

104 DBMS_PREDICTIVE_ANALYTICS

105 DBMS_PREPROCESSOR

106 DBMS_PROFILER

107 DBMS_PROPAGATION_ADM

108 DBMS_RANDOM

109 DBMS_RECTIFIER_DIFF

110 DBMS_REDEFINITION

111 DBMS_REDACT

112 DBMS_REFRESH

113 DBMS_REPAIR

114 DBMS_REPCAT

115 DBMS_REPCAT_ADMIN

116 DBMS_REPCAT_INSTANTIATE

117 DBMS_REPCAT_RGT

118 DBMS_REPUTIL

119 DBMS_RESCONFIG

120 DBMS_RESOURCE_MANAGER

121 DBMS_RESOURCE_MANAGER_PRIVS

122 DBMS_RESULT_CACHE

123 DBMS_RESUMABLE

124 DBMS_RLMGR

125 DBMS_RLS

126 DBMS_ROWID

127 DBMS_RULE

128 DBMS_RULE_ADM

129 DBMS_SCHEDULER

130 DBMS_SERVER_ALERT

131 DBMS_SERVICE

132 DBMS_SESSION

133 DBMS_SHARED_POOL

134 DBMS_SPACE

135 DBMS_SPACE_ADMIN

136 DBMS_SPM

137 DBMS_SQL

138 DBMS_SQLDIAG

139 DBMS_SQLPA

140 DBMS_SQLTUNE

141 DBMS_STAT_FUNCS

142 DBMS_STATS

143 DBMS_STORAGE_MAP

144 DBMS_STREAMS

145 DBMS_STREAMS_ADM

146 DBMS_STREAMS_ADVISOR_ADM

147 DBMS_STREAMS_AUTH

148 DBMS_STREAMS_HANDLER_ADM

149 DBMS_STREAMS_MESSAGING

150 DBMS_STREAMS_TABLESPACE_ADM

151 DBMS_TDB

152 DBMS_TRACE

153 DBMS_TRANSACTION

154 DBMS_TRANSFORM

155 DBMS_TTS

156 DBMS_TYPES

157 DBMS_UTILITY

158 DBMS_WARNING

159 DBMS_WM

160 DBMS_WORKLOAD_CAPTURE

161 DBMS_WORKLOAD_REPLAY

162 DBMS_WORKLOAD_REPOSITORY

163 DBMS_XA

164 DBMS_XDB

165 DBMS_XDB_ADMIN

166 DBMS_XDB_VERSION

167 DBMS_XDBRESOURCE

168 DBMS_XDBT

169 DBMS_XDBZ

170 DBMS_XEVENT

171 DBMS_XMLDOM

172 DBMS_XMLGEN

173 DBMS_XMLINDEX

174 DBMS_XMLPARSER

175 DBMS_XMLQUERY

176 DBMS_XMLSAVE

177 DBMS_XMLSCHEMA

178 DBMS_XMLSTORE

179 DBMS_XMLTRANSLATIONS

180 DBMS_XPLAN

181 DBMS_XSLPROCESSOR

182 DEBUG_EXTPROC

183 HTF

184 HTP

185 ORD_DICOM

186 ORD_DICOM_ADMIN

187 OWA_CACHE

188 OWA_COOKIE

189 OWA_CUSTOM

190 OWA_IMAGE

191 OWA_OPT_LOCK

192 OWA_PATTERN

193 OWA_SEC

194 OWA_TEXT

195 OWA_UTIL

196 SDO_CS

197 SDO_CSW_PROCESS

198 SDO_GCDR

199 SDO_GEOM

200 SDO_GEOR

201 SDO_GEOR_ADMIN

202 SDO_GEOR_UTL

203 SDO_LRS

204 SDO_MIGRATE

205 SDO_NET

206 SDO_NET_MEM

207 SDO_OLS

208 SDO_PC_PKG

209 SDO_SAM

210 SDO_TIN_PKG

211 SDO_TOPO

212 SDO_TOPO_MAP

213 SDO_TUNE

214 SDO_UTIL

215 SDO_WFS_LOCK

216 SDO_WFS_PROCESS

217 SEM_APIS

218 SEM_PERF

219 SEM_RDFCTX

220 SEM_RDFSA

221 UTL_COLL

222 UTL_COMPRESS

223 UTL_ENCODE

224 UTL_FILE

225 UTL_HTTP

226 UTL_I18N

227 UTL_INADDR

228 UTL_IDENT

229 UTL_LMS

230 UTL_MAIL

231 UTL_MATCH

232 UTL_NLA

233 UTL_RAW

234 UTL_RECOMP

235 UTL_REF

236 UTL_SMTP

237 UTL_SPADV

238 UTL_TCP

239 UTL_URL

240 WPG_DOCLOAD

241 ANYDATA TYPE

242 ANYDATASET TYPE

243 ANYTYPE TYPE

244 Oracle Streams AQ TYPEs

245 DBFS Content Interface Types

246 Database URI TYPEs

247 JMS Types

248 Expression Filter Types

249 Logical Change Record TYPEs

250 Oracle Multimedia ORDAudio TYPE

251 Oracle Multimedia ORDDicom TYPE

252 Oracle Multimedia ORDDoc TYPE

253 Oracle Multimedia ORDImage TYPE

254 Oracle Multimedia SQL/MM Still Image TYPES

255 Oracle Multimedia ORDVideo TYPE

256 MGD_ID Package Types

257 Rule TYPEs

258 Rules Manager Types

259 UTL Streams Types

260 XMLTYPE

Index