DBMS_JAVA

Title and Copyright Information
Preface
- Audience
- Documentation Accessibility
- Related Documents
- Conventions
Changes in This Release for Oracle Database PL/SQL Packages and Types Reference
- Changes in Oracle Database Release 19c, Version 19.1
1 Introduction to Oracle Supplied PL/SQL Packages & Types
- 1.1 Package Overview
- 1.2 Summary of Oracle Supplied PL/SQL Packages and 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
- 14.1 DBMS_ADDM Security Model
- 14.2 Summary of DBMS_ADDM Subprograms
15 DBMS_ADVANCED_REWRITE
- 15.1 DBMS_ADVANCED_REWRITE Security Model
- 15.2 Summary of DBMS_ADVANCED_REWRITE Subprograms
16 DBMS_ADVISOR
- 16.1 DBMS_ADVISOR Deprecated Subprograms
- 16.2 DBMS_ADVISOR Security Model
- 16.3 Summary of DBMS_ADVISOR Subprograms
17 DBMS_ALERT
- 17.1 DBMS_ALERT Overview
- 17.2 DBMS_ALERT Security Model
- 17.3 DBMS_ALERT Constants
- 17.4 DBMS_ALERT Restrictions
- 17.5 DBMS_ALERT Exceptions
- 17.6 DBMS_ALERT Operational Notes
- 17.7 DBMS_ALERT Examples
- 17.8 Summary of DBMS_ALERT Subprograms
18 DBMS_APP_CONT
- 18.1 DBMS_APP_CONT Overview
- 18.2 DBMS_APP_CONT Security Model
- 18.3 Summary of DBMS_APP_CONT Subprograms
  - 18.3.1 GET_LTXID_OUTCOME Procedure
19 DBMS_APPLICATION_INFO
- 19.1 DBMS_APPLICATION_INFO Overview
- 19.2 DBMS_APPLICATION_INFO Security Model
- 19.3 DBMS_APPLICATION_INFO Operational Notes
- 19.4 Summary of DBMS_APPLICATION_INFO Subprograms
20 DBMS_APPLY_ADM
- 20.1 DBMS_APPLY_ADM Overview
- 20.2 DBMS_APPLY_ADM Security Model
- 20.3 DBMS_APPLY_ADM Deprecated Subprograms
- 20.4 Summary of DBMS_APPLY_ADM Subprograms
21 DBMS_AQ
- 21.1 DBMS_AQ Security Model
- 21.2 DBMS_AQ Constants
- 21.3 DBMS_AQ Data Types
- 21.4 DBMS_AQ Operational Notes
- 21.5 Summary of DBMS_AQ Subprograms
22 DBMS_AQADM
- 22.1 DBMS_AQADM Security Model
- 22.2 DBMS_AQADM Constants
- 22.3 DBMS_AQADM Subprogram Groups
- 22.4 Summary of DBMS_AQADM Subprograms
23 DBMS_AQELM
- 23.1 DBMS_AQELM Security Model
- 23.2 Summary of DBMS_AQELM Subprograms
24 DBMS_AQIN
- 24.1 DBMS_AQIN Security Model
25 DBMS_ASSERT
- 25.1 DBMS_ASSERT Operational Notes
- 25.2 Summary of DBMS_ASSERT Subprograms
26 DBMS_AUDIT_MGMT
- 26.1 DBMS_AUDIT_MGMT Overview
- 26.2 DBMS_AUDIT_MGMT Deprecated Subprograms
- 26.3 DBMS_AUDIT_MGMT Security Model
- 26.4 DBMS_AUDIT_MGMT Constants
- 26.5 DBMS_AUDIT_MGMT Views
- 26.6 DBMS_AUDIT_MGMT Subprogram Groups
  - 26.6.1 DBMS_AUDIT_MGMT Audit Trail Management Subprograms
  - 26.6.2 DBMS_AUDIT_MGMT Audit Trail Cleanup Subprograms
- 26.7 Summary of DBMS_AUDIT_MGMT Subprograms
27 DBMS_AUDIT_UTIL
- 27.1 DBMS_AUDIT_UTIL Overview
- 27.2 DBMS_AUDIT_UTIL Security Model
- 27.3 DBMS_AUDIT_UTIL Views
- 27.4 Summary of DBMS_AUDIT_UTIL Subprograms
28 DBMS_AUTO_SQLTUNE
- 28.1 DBMS_AUTO_SQLTUNE Overview
- 28.2 DBMS_AUTO_SQLTUNE Security Model
- 28.3 Summary of DBMS_AUTO_SQLTUNE Subprograms
29 DBMS_AUTO_INDEX
- 29.1 DBMS_AUTO_INDEX Overview
- 29.2 Summary of DBMS_AUTO_INDEX Subprograms
30 DBMS_AUTO_REPORT
- 30.1 DBMS_AUTO_REPORT Overview
- 30.2 DBMS_AUTO_REPORT Security Model
- 30.3 Summary of DBMS_AUTO_REPORT Subprograms
31 DBMS_AUTO_TASK_ADMIN
- 31.1 DBMS_AUTO_TASK_ADMIN Deprecated Subprograms
- 31.2 DBMS_AUTO_TASK_ADMIN Security Model
- 31.3 DBMS_AUTO_TASK_ADMIN Constants
- 31.4 Summary of DBMS_AUTO_TASK_ADMIN Subprograms
32 DBMS_AW_STATS
- 32.1 Using DBMS_AW_STATS
- 32.2 Summary of DBMS_AW_STATS Subprograms
  - 32.2.1 ANALYZE Procedure
  - 32.2.2 CLEAR Procedure
33 DBMS_CAPTURE_ADM
- 33.1 DBMS_CAPTURE_ADM Overview
- 33.2 DBMS_CAPTURE_ADM Security Model
- 33.3 Summary of DBMS_CAPTURE_ADM Subprograms
34 DBMS_COMPARISON
- 34.1 DBMS_COMPARISON Overview
- 34.2 DBMS_COMPARISON Security Model
- 34.3 DBMS_COMPARISON Constants
- 34.4 DBMS_COMPARISON Views
- 34.5 DBMS_COMPARISON Operational Notes
- 34.6 DBMS_COMPARISON Data Structures
  - 34.6.1 COMPARISON_TYPE Record Type
- 34.7 Summary of DBMS_COMPARISON Subprograms
35 DBMS_COMPRESSION
- 35.1 DBMS_COMPRESSION Overview
- 35.2 DBMS_COMPRESSION Security Model
- 35.3 DBMS_COMPRESSION Constants
- 35.4 DBMS_COMPRESSION Data Structures
  - 35.4.1 COMPREC Record Type
  - 35.4.2 COMPRECLIST Table Type
- 35.5 Summary of DBMS_COMPRESSION Subprograms
  - 35.5.1 GET_COMPRESSION_RATIO Procedure
  - 35.5.2 GET_COMPRESSION_TYPE Function
36 DBMS_CONNECTION_POOL
- 36.1 Summary of DBMS_CONNECTION_POOL Subprograms
37 DBMS_CQ_NOTIFICATION
- 37.1 DBMS_CQ_NOTIFICATION Overview
- 37.2 DBMS_CQ_NOTIFICATION Security Model
- 37.3 DBMS_CQ_NOTIFICATION Constants
- 37.4 DBMS_CQ_NOTIFICATION Operational Notes
- 37.5 DBMS_CQ_NOTIFICATION Examples
- 37.6 DBMS_CQ_NOTIFICATION Data Structures
- 37.7 Summary of DBMS_CQ_NOTIFICATION Subprograms
38 DBMS_CREDENTIAL
- 38.1 DBMS_CREDENTIAL Overview
- 38.2 DBMS_CREDENTIAL Security Model
- 38.3 DBMS_CREDENTIAL Operational Notes
- 38.4 Summary of DBMS_CREDENTIAL Subprograms
39 DBMS_CRYPTO
- 39.1 DBMS_CRYPTO Overview
- 39.2 DBMS_CRYPTO Security Model
- 39.3 DBMS_CRYPTO Datatypes
- 39.4 DBMS_CRYPTO Algorithms
- 39.5 DBMS_CRYPTO Restrictions
- 39.6 DBMS_CRYPTO Exceptions
- 39.7 DBMS_CRYPTO Operational Notes
- 39.8 DBMS_CRYPTO Examples
- 39.9 Summary of DBMS_CRYPTO Subprograms
40 DBMS_CSX_ADMIN
- 40.1 DBMS_CSX_ADMIN Overview
- 40.2 DBMS_CSX_ADMIN Security Model
- 40.3 DBMS_CSX_ADMIN Constants
- 40.4 Summary of DBMS_CSX_ADMIN Subprograms
41 DBMS_CUBE
- 41.1 Using DBMS_CUBE
  - 41.1.1 DBMS_CUBE Security Model
- 41.2 Using SQL Aggregation Management
- 41.3 Upgrading 10g Analytic Workspaces
- 41.4 Summary of DBMS_CUBE Subprograms
42 DBMS_CUBE_ADVISE
- 42.1 DBMS_CUBE_ADVISE Security Model
- 42.2 Summary of DBMS_CUBE_ADVISE Subprograms
43 DBMS_CUBE_LOG
- 43.1 Using DBMS_CUBE_LOG
- 43.2 Summary of DBMS_CUBE_LOG Subprograms
44 DBMS_DATA_MINING
- 44.1 DBMS_DATA_MINING Overview
- 44.2 DBMS_DATA_MINING Security Model
- 44.3 DBMS_DATA_MINING — Mining Functions
- 44.4 DBMS_DATA_MINING — Model Settings
- 44.5 DBMS_DATA_MINING — Solver Settings
  - 44.5.1 DBMS_DATA_MINING — Solver Settings: ADMM
  - 44.5.2 DBMS_DATA_MINING — Solver Settings: LBFGS
- 44.6 DBMS_DATA_MINING Datatypes
  - 44.6.1 Deprecated Types
- 44.7 Summary of DBMS_DATA_MINING Subprograms
45 DBMS_DATA_MINING_TRANSFORM
- 45.1 DBMS_DATA_MINING_TRANSFORM Overview
- 45.2 DBMS_DATA_MINING_TRANSFORM Operational Notes
- 45.3 DBMS_DATA_MINING_TRANSFORM Security Model
- 45.4 DBMS_DATA_MINING_TRANSFORM Datatypes
- 45.5 DBMS_DATA_MINING_TRANSFORM Constants
- 45.6 Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
46 DBMS_DATAPUMP
- 46.1 DBMS_DATAPUMP Overview
- 46.2 DBMS_DATAPUMP Security Model
- 46.3 DBMS_DATAPUMP Constants
- 46.4 DBMS_DATAPUMP Data Structures
- 46.5 Summary of DBMS_DATAPUMP Subprograms
47 DBMS_DB_VERSION
- 47.1 DBMS_DB_VERSION Overview
- 47.2 DBMS_DB_VERSION Constants
- 47.3 DBMS_DB_VERSION Examples
48 DBMS_DBCOMP
- 48.1 Using DBMS_DBCOMP
- 48.2 DBMS_DBCOMP Security Model
- 48.3 Summary of the DBMS_DBCOMP Subprogram
  - 48.3.1 DBCOMP Procedure
49 DBMS_DBFS_CONTENT
- 49.1 DBMS_DBFS_CONTENT Overview
- 49.2 DBMS_DBFS_CONTENT Security Model
- 49.3 DBMS_DBFS_CONTENT Constants
- 49.4 Exceptions
- 49.5 DBMS_DBFS_CONTENT Operational Notes
- 49.6 DBMS_DBFS_CONTENT Data Structures
- 49.7 Summary of DBMS_DBFS_CONTENT Subprograms
50 DBMS_DBFS_CONTENT_SPI
- 50.1 ODBMS_DBFS_CONTENT_SPI Overview
- 50.2 DBMS_DBFS_CONTENT_SPI Security Model
- 50.3 DBMS_DBFS_CONTENT_SPI Operational Notes
- 50.4 Summary of DBMS_DBFS_CONTENT_SPI Subprograms
51 DBMS_DBFS_HS
- 51.1 DBMS_DBFS_HS Overview
- 51.2 DBMS_DBFS_HS Security Model
- 51.3 DBMS_DBFS_HS Constants
- 51.4 DBMS_DBFS_HS Operational Notes
- 51.5 Summary of DBMS_DBFS_HS Subprograms
52 DBMS_DBFS_SFS
- 52.1 DBMS_DBFS_SFS Overview
- 52.2 DBMS_DBFS_SFS Security Model
- 52.3 DBMS_DBFS_SFS Constants
- 52.4 Summary of DBMS_DBFS_SFS Subprograms
53 DBMS_DDL
- 53.1 DBMS_DDL Deprecated Subprograms
- 53.2 DBMS_DDL Security Model
- 53.3 DBMS_DDL Operational Notes
- 53.4 Summary of DBMS_DDL Subprograms
54 DBMS_DEBUG
- 54.1 DBMS_DEBUG Overview
- 54.2 DBMS_DEBUG Constants
- 54.3 DBMS_DEBUG Variables
- 54.4 DBMS_DEBUG Exceptions
- 54.5 DBMS_DEBUG Operational Notes
- 54.6 DBMS_DEBUG Data Structures
- 54.7 Summary of DBMS_DEBUG Subprograms
55 DBMS_DEBUG_JDWP
- 55.1 DBMS_DEBUG_JDWP Overview
- 55.2 DBMS_DEBUG_JDWP Security Model
- 55.3 Summary DBMS_DEBUG_JDWP Subprograms
56 DBMS_DEBUG_JDWP_CUSTOM
- 56.1 DBMS_DEBUG_JDWP_CUSTOM Overview
- 56.2 DBMS_DEBUG_JDWP_CUSTOM Security Model
- 56.3 Summary DBMS_DEBUG_JDWP_CUSTOM Subprograms
  - 56.3.1 CONNECT_DEBUGGER Procedure
57 DBMS_DESCRIBE
- 57.1 DBMS_DESCRIBE Overview
- 57.2 DBMS_DESCRIBE Security Model
- 57.3 DBMS_DESCRIBE Types
- 57.4 DBMS_DESCRIBE Exceptions
- 57.5 DBMS_DESCRIBE Examples
- 57.6 Summary of DBMS_DESCRIBE Subprograms
  - 57.6.1 DESCRIBE_PROCEDURE Procedure
58 DBMS_DG
- 58.1 Using DBMS_DG
- 58.2 DBMS_DG Security Model
- 58.3 Summary of the DBMS_DG Subprogram
  - 58.3.1 INITIATE_FS_FAILOVER Procedure
59 DBMS_DIMENSION
- 59.1 DBMS_DIMENSION Security Model
- 59.2 Summary of DBMS_DIMENSION Subprograms
  - 59.2.1 DESCRIBE_DIMENSION Procedure
  - 59.2.2 VALIDATE_DIMENSION Procedure
60 DBMS_DISTRIBUTED_TRUST_ADMIN
- 60.1 DBMS_DISTRIBUTED_TRUST_ADMIN Overview
- 60.2 DBMS_DISTRIBUTED_TRUST_ADMIN Security Model
- 60.3 DBMS_DISTRIBUTED_TRUST_ADMIN Examples
- 60.4 Summary of DBMS_DISTRIBUTED_TRUST_ADMIN Subprograms
61 DBMS_DNFS
- 61.1 DBMS_DNFS Security Model
- 61.2 Summary of DBMS_DNFS Subprograms
  - 61.2.1 CLONEDB_RENAMEFILE Procedure
62 DBMS_DST
- 62.1 DBMS_DST Overview
- 62.2 DBMS_DST Security Model
- 62.3 DBMS_DST Views
- 62.4 Summary of DBMS_DST Subprograms
63 DBMS_EDITIONS_UTILITIES
- 63.1 DBMS_EDITIONS_UTILITIES Overview
- 63.2 DBMS_EDITIONS_UTILITIES Security Model
- 63.3 DBMS_EDITIONS_UTILITIES Exceptions
- 63.4 Summary of DBMS_EDITIONS_UTILITIES Subprograms
64 DBMS_EPG
- 64.1 DBMS_EPG Overview
- 64.2 DBMS_EPG Security Model
- 64.3 DBMS_EPG Exceptions
- 64.4 DBMS_EPG Data Structures
- 64.5 DBMS_EPG Subprogram Groups
  - 64.5.1 DBMS_EPG Configuration Subprograms
  - 64.5.2 DBMS_EPG Authorization Subprograms
- 64.6 Summary of DBMS_EPG Subprograms
65 DBMS_ERRLOG
- 65.1 DBMS_DIMENSION Security Model
- 65.2 Summary of DBMS_ERRLOG Subprograms
  - 65.2.1 CREATE_ERROR_LOG Procedure
66 DBMS_FGA
- 66.1 DBMS_FGA Security Model
- 66.2 DBMS_FGA Operational Notes
- 66.3 Summary of DBMS_FGA Subprograms
67 DBMS_FILE_GROUP
- 67.1 DBMS_FILE_GROUP Overview
- 67.2 DBMS_FILE_GROUP Security Model
- 67.3 DBMS_FILE_GROUP Constants
- 67.4 Summary of DBMS_FILE_GROUP Subprograms
68 DBMS_FILE_TRANSFER
- 68.1 DBMS_FILE_TRANSFER Overview
- 68.2 DBMS_FILE_TRANSFER Security Model
- 68.3 DBMS_FILE_TRANSFER Operational Notes
- 68.4 Summary of DBMS_FILE_TRANSFER Subprograms
69 DBMS_FLASHBACK
- 69.1 DBMS_FLASHBACK Overview
- 69.2 DBMS_FLASHBACK Security Model
- 69.3 DBMS_FLASHBACK Types
- 69.4 DBMS_FLASHBACK Exceptions
- 69.5 DBMS_FLASHBACK Operational Notes
- 69.6 DBMS_FLASHBACK Examples
- 69.7 Summary of DBMS_FLASHBACK Subprograms
70 DBMS_FLASHBACK_ARCHIVE
- 70.1 DBMS_FLASHBACK_ARCHIVE Overview
- 70.2 DBMS_FLASHBACK_ARCHIVE Security Model
- 70.3 DBMS_FLASHBACK_ARCHIVE Constants
- 70.4 Summary of DBMS_FLASHBACK_ARCHIVE Subprograms
71 DBMS_FREQUENT_ITEMSET
- 71.1 Summary of DBMS_FREQUENT_ITEMSET Subprograms
  - 71.1.1 FI_HORIZONTAL Function
  - 71.1.2 FI_TRANSACTIONAL Function
72 DBMS_FS
- 72.1 DBMS_FS Overview
- 72.2 DBMS_FS Security Model
- 72.3 Summary of DBMS_FS Subprograms
73 DBMS_GOLDENGATE_ADM
- 73.1 Using DBMS_GOLDENGATE_ADM
  - 73.1.1 DBMS_GOLDENGATE_ADM Overview
  - 73.1.2 DBMS_GOLDENGATE_ADM Security Model
- 73.2 Summary of DBMS_GOLDENGATE_ADM Subprograms
74 DBMS_GOLDENGATE_AUTH
- 74.1 DBMS_GOLDENGATE_AUTH Overview
- 74.2 DBMS_GOLDENGATE_AUTH Security Model
- 74.3 Summary of DBMS_GOLDENGATE_AUTH Subprograms
  - 74.3.1 GRANT_ADMIN_PRIVILEGE Procedure
  - 74.3.2 REVOKE_ADMIN_PRIVILEGE Procedure
75 DBMS_HADOOP
- 75.1 DBMS_HADOOP Overview
- 75.2 DBMS_HADOOP Security Model
- 75.3 Summary of DBMS_HADOOP Subprograms
76 DBMS_HANG_MANAGER
- 76.1 DBMS_HANG_MANAGER Overview
- 76.2 DBMS_HANG_MANAGER Security Model
- 76.3 DBMS_HANG_MANAGER Constants
- 76.4 DBMS_HANG_MANAGER Exceptions
- 76.5 Summary of DBMS_HANG_MANAGER Subprograms
  - 76.5.1 SET Procedure
77 DBMS_HEAT_MAP
- 77.1 DBMS_HEAT_MAP Overview
- 77.2 DBMS_HEAT_MAP Security Model
- 77.3 Summary of DBMS_HEAT_MAP Subprograms
78 DBMS_HIERARCHY
- 78.1 DBMS_HIERARCHY Overview
- 78.2 DBMS_HIERARCHY Security Model
- 78.3 Summary of DBMS_HIERARCHY Subprograms
79 DBMS_HM
- 79.1 DBMS_HM Security Model
- 79.2 Summary of DBMS_HM Subprograms
  - 79.2.1 GET_RUN_REPORT Function
  - 79.2.2 RUN_CHECK Procedure
80 DBMS_HPROF
- 80.1 Summary of DBMS_HPROF Subprograms
81 DBMS_HS_PARALLEL
- 81.1 Using the DBMS_HS_PARALLEL Subprogram
- 81.2 Summary of DBMS_HS_PARALLEL Subprograms
82 DBMS_HS_PASSTHROUGH
- 82.1 DBMS_HS_PASSTHROUGH Overview
- 82.2 DBMS_HS_PASSTHROUGH Operational Notes
- 82.3 Summary of DBMS_HS_PASSTHROUGH Subprograms
83 DBMS_ILM
- 83.1 DBMS_ILM Overview
- 83.2 DBMS_ILM Security Model
- 83.3 DBMS_ILM Constants
- 83.4 DBMS_ILM Exceptions
- 83.5 Summary of DBMS_ILM Subprograms
84 DBMS_ILM_ADMIN
- 84.1 DBMS_ILM_ADMIN Overview
- 84.2 DBMS_ILM_ADMIN Security Model
- 84.3 DBMS_ILM_ADMIN Constants
- 84.4 Summary of DBMS_ILM_ADMIN Subprograms
85 DBMS_INMEMORY
- 85.1 DBMS_INMEMORY Overview
- 85.2 DBMS_INMEMORY Security Model
- 85.3 Summary of DBMS_INMEMORY Subprograms
86 DBMS_INMEMORY_ADMIN
- 86.1 DBMS_INMEMORY_ADMIN Overview
- 86.2 DBMS_INMEMORY_ADMIN Security Model
- 86.3 DBMS_INMEMORY_ADMIN Operational Notes
- 86.4 Summary of DBMS_INMEMORY_ADMIN Subprograms
87 DBMS_IOT
- 87.1 Summary of DBMS_IOT Subprograms
  - 87.1.1 BUILD_CHAIN_ROWS_TABLE Procedure
  - 87.1.2 BUILD_EXCEPTIONS_TABLE Procedure
88 DBMS_JAVA
89 DBMS_JOB
- 89.1 DBMS_JOB Security Model
- 89.2 DBMS_JOB Operational Notes
- 89.3 Summary of DBMS_JOB Subprograms
90 DBMS_JSON
- 90.1 DBMS_JSON Overview
- 90.2 DBMS_JSON Security Model
- 90.3 DBMS_JSON Constants
- 90.4 Summary of DBMS_JSON Subprograms
91 DBMS_LDAP
92 DBMS_LDAP_UTL
93 DBMS_LIBCACHE
- 93.1 DBMS_LIBCACHE Overview
- 93.2 DBMS_LIBCACHE Security Model
- 93.3 Summary of DBMS_LIBCACHE Subprograms
  - 93.3.1 COMPILE_FROM_REMOTE Procedure
94 DBMS_LOB
- 94.1 DBMS_LOB Overview
- 94.2 DBMS_LOB Deprecated Subprograms
- 94.3 DBMS_LOB Security Model
- 94.4 DBMS_LOB Constants
- 94.5 DBMS_LOB Datatypes
- 94.6 DBMS_LOB Operational Notes
- 94.7 DBMS_LOB Rules and Limits
- 94.8 DBMS_LOB Exceptions
- 94.9 Summary of DBMS_LOB Subprograms
95 DBMS_LOCK
- 95.1 DBMS_LOCK Overview
- 95.2 DBMS_LOCK Security Model
- 95.3 DBMS_LOCK Constants
- 95.4 DBMS_LOCK. Rules and Limits
- 95.5 DBMS_LOCK Operational Notes
- 95.6 Summary of DBMS_LOCK Subprograms
96 DBMS_LOGMNR
- 96.1 DBMS_LOGMNR Overview
- 96.2 DBMS_LOGMNR Security Model
- 96.3 DBMS_LOGMNR Constants
- 96.4 DBMS_LOGMNR Views
- 96.5 DBMS_LOGMNR Operational Notes
- 96.6 Summary of DBMS_LOGMNR Subprograms
97 DBMS_LOGSTDBY
- 97.1 DBMS_LOGSTDBY Overview
- 97.2 DBMS_LOGSTDBY Security Model
- 97.3 DBMS_LOGSTDBY Constants
- 97.4 Summary of DBMS_LOGSTDBY Subprograms
98 DBMS_LOGMNR_D
- 98.1 DBMS_LOGMNR_D Overview
- 98.2 DBMS_LOGMNR_D Security Model
- 98.3 Summary of DBMS_LOGMNR_D Subprograms
  - 98.3.1 BUILD Procedure
  - 98.3.2 SET_TABLESPACE Procedure
99 DBMS_LOGSTDBY_CONTEXT
- 99.1 DBMS_LOGSTDBY_CONTEXT Overview
- 99.2 DBMS_LOGSTDBY_CONTEXT Security Model
- 99.3 Summary of DBMS_LOGSTDBY_CONTEXT Subprograms
100 DBMS_MEMOPTIMIZE
- 100.1 DBMS_MEMOPTIMIZE Overview
- 100.2 Summary of DBMS_MEMOPTIMIZE Subprograms
101 DBMS_MEMOPTIMIZE_ADMIN
- 101.1 DBMS_MEMOPTIMIZE_ADMIN Overview
- 101.2 Summary of DBMS_MEMOPTIMIZE_ADMIN Subprograms
  - 101.2.1 WRITES_FLUSH Procedure
102 DBMS_METADATA
- 102.1 DBMS_METADATA Overview
- 102.2 DBMS_METADATA Security Model
- 102.3 Rules and Limits
- 102.4 DBMS_METADATA Data Structures - Object and Table Types
- 102.5 DBMS_METADATA Subprogram Groupings
  - 102.5.1 DBMS_METADATA Subprograms for Retrieving Multiple Objects From the Database
  - 102.5.2 DBMS_METADATA Subprograms for Submitting XML to the Database
- 102.6 Summary of All DBMS_METADATA Subprograms
103 DBMS_METADATA_DIFF
- 103.1 DBMS_METADATA_DIFF Overview
- 103.2 DBMS_METADATA_DIFF Security Model
- 103.3 DBMS_METADATA_DIFF — Browsing APIs for Fetching and Comparing Objects
- 103.4 Summary of DBMS_METADATA_DIFF Subprograms
104 DBMS_MGD_ID_UTL
- 104.1 DBMS_MGD_ID_UTL Security Model
- 104.2 DBMS_MGD_ID_UTL Constants
- 104.3 DBMS_MGD_ID_UTL Exceptions
- 104.4 Summary of DBMS_MGD_ID_UTL Subprograms
105 DBMS_MGWADM
- 105.1 DBMS_MGWADM Security Model
- 105.2 DBMS_MGWADM Deprecated Subprograms
- 105.3 DBMS_MGWADM Constants
- 105.4 DBMS_MGWADM Data Structures
- 105.5 Summary of DBMS_MGWADM Subprograms
106 DBMS_MGWMSG
- 106.1 DBMS_MGWMSG Security Model
- 106.2 DBMS_MGWMSG Constants
- 106.3 DBMS_MGWMSG Types
- 106.4 Summary of DBMS_MGWMSG Subprograms
107 DBMS_MONITOR
- 107.1 Summary of DBMS_MONITOR Subprograms
108 DBMS_MVIEW
- 108.1 DBMS_MVIEW Operational Notes
- 108.2 DBMS_MVIEW Security Model
- 108.3 DBMS_MVIEW Rules and Limits
- 108.4 Summary of DBMS_MVIEW Subprograms
109 DBMS_MVIEW_STATS
- 109.1 DBMS_MVIEW_STATS Overview
- 109.2 DBMS_MVIEW_STATS Security Model
- 109.3 Summary of DBMS_MVIEW_STATS Subprograms
110 DBMS_NETWORK_ACL_ADMIN
- 110.1 DBMS_NETWORK_ACL_ADMIN Overview
- 110.2 DBMS_NETWORK_ACL_ADMIN Deprecated Subprograms
- 110.3 DBMS_NETWORK_ACL_ADMIN Security Model
- 110.4 DBMS_NETWORK_ACL_ADMIN Constants
- 110.5 DBMS_NETWORK_ACL_ADMIN Exceptions
- 110.6 DBMS_NETWORK_ACL_ADMIN Examples
- 110.7 Summary of DBMS_NETWORK_ACL_ADMIN Subprograms
111 DBMS_NETWORK_ACL_UTILITY
- 111.1 DBMS_NETWORK_ACL_UTILITY Security Model
- 111.2 DBMS_NETWORK_ACL_UTILITY Examples
- 111.3 Summary of DBMS_NETWORK_ACL_UTILITY Subprograms
112 DBMS_ODCI
- 112.1 Summary of DBMS_ODCI Subprograms
  - 112.1.1 ESTIMATE_CPU_UNITS Function
113 DBMS_OUTLN
- 113.1 DBMS_OUTLN Overview
- 113.2 DBMS_OUTLN Security Model
- 113.3 Summary of DBMS_OUTLN Subprograms
114 DBMS_OUTPUT
- 114.1 DBMS_OUTPUT Overview
- 114.2 DBMS_OUTPUT Security Model
- 114.3 DBMS_OUTPUT Operational Notes
- 114.4 DBMS_OUTPUT Exceptions
- 114.5 DBMS_OUTPUT Rules and Limits
- 114.6 DBMS_OUTPUT Examples
- 114.7 DBMS_OUTPUT Data Structures
  - 114.7.1 CHARARR Table Type
  - 114.7.2 DBMS_OUTPUT DBMSOUTPUT_LINESARRAY Object Type
- 114.8 Summary of DBMS_OUTPUT Subprograms
115 DBMS_PARALLEL_EXECUTE
- 115.1 DBMS_PARALLEL_EXECUTE Overview
- 115.2 DBMS_PARALLEL_EXECUTE Security Model
- 115.3 DBMS_PARALLEL_EXECUTE Constants
- 115.4 DBMS_PARALLEL_EXECUTE Views
- 115.5 DBMS_PARALLEL_EXECUTE Exceptions
- 115.6 DBMS_PARALLEL_EXECUTE Examples
- 115.7 Summary of DBMS_PARALLEL_EXECUTE Subprograms
116 DBMS_PART
- 116.1 DBMS_PART Security Model
- 116.2 DBMS_PART Operational Notes
- 116.3 Summary of DBMS_PART Subprograms
  - 116.3.1 CLEANUP_GIDX Procedure
  - 116.3.2 CLEANUP_ONLINE_OP Procedure
117 DBMS_PCLXUTIL
- 117.1 DBMS_PCLXUTIL Overview
- 117.2 DBMS_PCLXUTIL Security Model
- 117.3 DBMS_PCLXUTIL Operational Notes
- 117.4 DBMS_PCLXUTIL Rules and Limits
- 117.5 Summary of DBMS_PCLXUTIL Subprograms
  - 117.5.1 BUILD_PART_INDEX Procedure
118 DBMS_PDB
- 118.1 DBMS_PDB Overview
- 118.2 DBMS_PDB Security Model
- 118.3 Summary of DBMS_PDB Subprograms
119 DBMS_PDB_ALTER_SHARING
- 119.1 DBMS_PDB_ALTER_SHARING Overview
- 119.2 DBMS_PDB_ALTER_SHARING Security Model
- 119.3 Summary of DBMS_PDB_ALTER_SHARING Subprograms
120 DBMS_PERF
- 120.1 DBMS_PERF Overview
- 120.2 DBMS_PERF Security Model
- 120.3 Summary of DBMS_PERF Subprograms
121 DBMS_PIPE
- 121.1 DBMS_PIPE Overview
- 121.2 DBMS_PIPE Security Model
- 121.3 DBMS_PIPE Constants
- 121.4 DBMS_PIPE Operational Notes
- 121.5 DBMS_PIPE Exceptions
- 121.6 DBMS_PIPE Examples
- 121.7 Summary of DBMS_PIPE Subprograms
122 DBMS_PLSQL_CODE_COVERAGE
- 122.1 DBMS_PLSQL_CODE_COVERAGE Overview
- 122.2 DBMS_PLSQL_CODE_COVERAGE Security Model
- 122.3 Summary of DBMS_PLSQL_CODE_COVERAGE Subprograms
123 DBMS_PREDICTIVE_ANALYTICS
- 123.1 DBMS_PREDICTIVE_ANALYTICS Overview
- 123.2 DBMS_PREDICTIVE_ANALYTICS Security Model
- 123.3 Summary of DBMS_PREDICTIVE_ANALYTICS Subprograms
124 DBMS_PREPROCESSOR
- 124.1 DBMS_PREPROCESSOR Overview
- 124.2 DBMS_PREPROCESSOR Operating Notes
- 124.3 DBMS_PREPROCESSOR Data Structures
  - 124.3.1 DBMS_PREPROCESSOR SOURCE_LINES_T Table Type
- 124.4 Summary of DBMS_PREPROCESSOR Subprograms
  - 124.4.1 GET_POST_PROCESSED_SOURCE Functions
  - 124.4.2 PRINT_POST_PROCESSED_SOURCE Procedures
125 DBMS_PRIVILEGE_CAPTURE
- 125.1 DBMS_PRIVILEGE_CAPTURE Overview
- 125.2 DBMS_PRIVILEGE_CAPTURE Security Model
- 125.3 DBMS_PRIVILEGE_CAPTURE Constants
- 125.4 DBMS_PRIVILEGE_CAPTURE Examples
- 125.5 Summary of DBMS_PRIVILEGE_CAPTURE Subprograms
126 DBMS_PROCESS
- 126.1 DBMS_PROCESS Overview
- 126.2 DBMS_PROCESS Security Model
- 126.3 Summary of DBMS_PROCESS Subprograms
127 DBMS_PROFILER
- 127.1 DBMS_PROFILER Overview
- 127.2 DBMS_PROFILER Security Model
- 127.3 DBMS_PROFILER Operational Notes
- 127.4 DBMS_PROFILER Exceptions
- 127.5 Summary of DBMS_PROFILER Subprograms
128 DBMS_PROPAGATION_ADM
- 128.1 DBMS_PROPAGATION_ADM Overview
- 128.2 DBMS_PROPAGATION_ADM Security Model
- 128.3 Summary of DBMS_PROPAGATION_ADM Subprograms
129 DBMS_QOPATCH
- 129.1 DBMS_QOPATCH Overview
- 129.2 DBMS_QOPATCH Security Model
- 129.3 DBMS_QOPATCH Operational Notes
- 129.4 DBMS_QOPATCH Exceptions
- 129.5 Summary of DBMS_QOPATCH Subprograms
130 DBMS_RANDOM
- 130.1 DBMS_RANDOM Deprecated Subprograms
- 130.2 DBMS_RANDOM Security Model
- 130.3 DBMS_RANDOM Operational Notes
- 130.4 Summary of DBMS_RANDOM Subprograms
131 DBMS_REDACT
- 131.1 DBMS_REDACT Overview
- 131.2 DBMS_REDACT Security Model
- 131.3 DBMS_REDACT Constants
- 131.4 DBMS_REDACT Operating Procedures
- 131.5 Summary of DBMS_REDACT Subprograms
132 DBMS_REDEFINITION
- 132.1 DBMS_REDEFINITION Overview
- 132.2 DBMS_REDEFINITION Security Model
- 132.3 DBMS_REDEFINITION Constants
- 132.4 DBMS_REDEFINITION Operational Notes
- 132.5 DBMS_REDEFINITION Rules and Limits
- 132.6 DBMS_REDEFINITION Examples
- 132.7 Summary of DBMS_REDEFINITION Subprograms
133 DBMS_REFRESH
- 133.1 DBMS_REFRESH Overview
- 133.2 DBMS_REFRESH Security Model
- 133.3 Summary of DBMS_REFRESH Subprograms
134 DBMS_REPAIR
- 134.1 DBMS_REPAIR Overview
- 134.2 DBMS_REPAIR Security Model
- 134.3 DBMS_REPAIR Constants
- 134.4 DBMS_REPAIR Operating Notes
- 134.5 DBMS_REPAIR Exceptions
- 134.6 DBMS_REPAIR Examples
- 134.7 Summary of DBMS_REPAIR Subprograms
135 DBMS_RESCONFIG
- 135.1 DBMS_RESCONFIG Overview
- 135.2 Summary of DBMS_RESCONFIG Subprograms
136 DBMS_RESOURCE_MANAGER
- 136.1 DBMS_RESOURCE_MANAGER Deprecated Subprograms
- 136.2 DBMS_RESOURCE_MANAGER Security Model
- 136.3 DBMS_RESOURCE_MANAGER Constants
- 136.4 Summary of DBMS_RESOURCE_MANAGER Subprograms
137 DBMS_RESOURCE_MANAGER_PRIVS
- 137.1 Summary of DBMS_RESOURCE_MANAGER_PRIVS Subprograms
138 DBMS_RESULT_CACHE
- 138.1 DBMS_RESULT_CACHE Security Model
- 138.2 DBMS_RESULT_CACHE Constants
- 138.3 Summary of DBMS_RESULT_CACHE Subprograms
139 DBMS_RESUMABLE
- 139.1 DBMS_RESUMABLE Operational Notes
- 139.2 Summary of DBMS_RESUMABLE Subprograms
140 DBMS_RLS
- 140.1 DBMS_RLS Overview
- 140.2 DBMS_RLS Security Model
- 140.3 DBMS_RLS Constants
- 140.4 DBMS_RLS Operational Notes
- 140.5 DBMS_RLS Rules and Limits
- 140.6 Summary of DBMS_RLS Subprograms
141 DBMS_ROLLING
- 141.1 DBMS_ROLLING Overview
- 141.2 DBMS_ROLLING Security Model
- 141.3 Summary of DBMS_ROLLING Subprograms
142 DBMS_ROWID
- 142.1 DBMS_ROWID Security Model
- 142.2 DBMS_ROWID Types
- 142.3 DBMS_ROWID Exceptions
- 142.4 DBMS_ROWID Operational Notes
- 142.5 DBMS_ROWID Examples
- 142.6 Summary of DBMS_ROWID Subprograms
143 DBMS_RULE
- 143.1 DBMS_RULE Overview
- 143.2 DBMS_RULE Security Model
- 143.3 Summary of DBMS_RULE Subprograms
144 DBMS_RULE_ADM
- 144.1 DBMS_RULE_ADM Overview
- 144.2 DBMS_RULE_ADM Security Model
- 144.3 Summary of DBMS_RULE_ADM Subprograms
145 DBMS_SCHEDULER
- 145.1 DBMS_SCHEDULER Deprecated Subprograms
- 145.2 DBMS_SCHEDULER Security Model
- 145.3 DBMS_SCHEDULER Rules and Limits
- 145.4 DBMS_SCHEDULER Operational Notes
- 145.5 DBMS_SCHEDULER Data Structures
- 145.6 Summary of DBMS_SCHEDULER Subprograms
146 DBMS_SERVER_ALERT
- 146.1 DBMS_SERVER_ALERT Security Model
- 146.2 DBMS_SERVER_ALERT Object Types
- 146.3 DBMS_SERVER_ALERT Relational Operators
- 146.4 DBMS_SERVER_ALERT Supported Metrics
- 146.5 Summary of DBMS_SERVER_ALERT Subprograms
147 DBMS_SERVICE
- 147.1 DBMS_SERVICE Overview
- 147.2 DBMS_SERVICE Security Model
- 147.3 DBMS_SERVICE Constants
- 147.4 DBMS_SERVICE Operating Procedures
- 147.5 DBMS_SERVICE Exceptions
- 147.6 Summary of DBMS_SERVICE Subprograms
148 DBMS_SESSION
- 148.1 DBMS_SESSION Security Model
- 148.2 DBMS_SESSION Operational Notes
- 148.3 DBMS_SESSION Data Structures
  - 148.3.1 DBMS_SERVICE INTEGER_ARRAY Table Type
  - 148.3.2 DBMS_SERVICE LNAME_ARRAY Table Type
- 148.4 Summary of DBMS_SESSION Subprograms
149 DBMS_SFW_ACL_ADMIN
- 149.1 DBMS_SFW_ACL_ADMIN Security Model
- 149.2 DBMS_SFW_ACL_ADMIN Operational Notes
- 149.3 DBMS_SFW_ACL_ADMIN Examples
- 149.4 Summary of DBMS_SFW_ACL_ADMIN Subprograms
150 DBMS_SODA
- 150.1 DBMS_SODA Security Model
- 150.2 Summary of DBMS_SODA Subprograms
151 DBMS_SHARED_POOL
- 151.1 DBMS_SHARED_POOL Overview
- 151.2 DBMS_SHARED_POOL Operational Notes
- 151.3 Summary of DBMS_SHARED_POOL Subprograms
152 DBMS_SPACE
- 152.1 DBMS_SPACE Security Model
- 152.2 DBMS_SPACE Data Structures
- 152.3 Summary of DBMS_SPACE Subprograms
153 DBMS_SPACE_ADMIN
- 153.1 DBMS_SPACE_ADMIN Security Model
- 153.2 DBMS_SPACE_ADMIN Constants
- 153.3 DBMS_SPACE_ADMIN Operational Notes
- 153.4 Summary of DBMS_SPACE_ADMIN Subprograms
154 DBMS_SPD
- 154.1 DBMS_SPD Overview
- 154.2 DBMS_SPD Security Model
- 154.3 DBMS_SPD Views
- 154.4 Summary of DBMS_SPD Subprograms
155 DBMS_SPM
- 155.1 DBMS_SPM Overview
- 155.2 DBMS_SPM Security Model
- 155.3 DBMS_SPM Constants
- 155.4 DBMS_SPM Examples
- 155.5 DBMS_SPM Data Structures
  - 155.5.1 DBMS_SPM NAMELIST Table Type
- 155.6 Summary of DBMS_SPM Subprograms
156 DBMS_SQL
- 156.1 DBMS_SQL Overview
- 156.2 DBMS_SQL Security Model
- 156.3 DBMS_SQL Constants
- 156.4 DBMS_SQL Operational Notes
- 156.5 DBMS_SQL Execution Flow
- 156.6 DBMS_SQL Exceptions
- 156.7 DBMS_SQL Examples
- 156.8 DBMS_SQL Data Structures
- 156.9 Summary of DBMS_SQL Subprograms
157 DBMS_SQL_MONITOR
- 157.1 DBMS_SQL_MONITOR Overview
- 157.2 DBMS_SQL_MONITOR Security Model
- 157.3 DBMS_SQL_MONITOR Constants
- 157.4 Summary of DBMS_SQL_MONITOR Subprograms
158 DBMS_SQL_TRANSLATOR
- 158.1 DBMS_SQL_TRANSLATOR Security Model
- 158.2 DBMS_SQL_TRANSLATOR Constants
- 158.3 DBMS_SQL_TRANSLATOR Operational Notes
- 158.4 DBMS_SQL_TRANSLATOR Exceptions
- 158.5 DBMS_SQL_TRANSLATOR Examples
- 158.6 Summary of DBMS_SQL_TRANSLATOR Subprograms
159 DBMS_SQLDIAG
- 159.1 DBMS_SQLDIAG Overview
- 159.2 DBMS_SQLDIAG Security Model
- 159.3 DBMS_SQLDIAG Constants
- 159.4 Summary of DBMS_SQLDIAG Subprograms
160 DBMS_SQLPA
- 160.1 DBMS_SQLPA Overview
- 160.2 DBMS_SQLPA Security Model
- 160.3 Summary of DBMS_SQLPA Subprograms
161 DBMS_SQLQ
- 161.1 DBMS_SQLQ Overview
- 161.2 Summary of DBMS_SQLQ Subprograms
162 DBMS_SQLSET
- 162.1 DBMS_SQLSET Overview
- 162.2 DBMS_SQLSET Security Model
- 162.3 DBMS_SQLSET Data Structures
  - 162.3.1 SQLSET_ROW Object Type
- 162.4 Summary of DBMS_SQLSET Subprograms
163 DBMS_SQLTUNE
- 163.1 DBMS_SQLTUNE Overview
- 163.2 DBMS_SQLTUNE Security Model
- 163.3 DBMS_SQLTUNE Data Structures
  - 163.3.1 SQLSET_ROW Object Type
- 163.4 DBMS_SQLTUNE Subprogram Groups
- 163.5 Summary of DBMS_SQLTUNE Subprograms
164 DBMS_STAT_FUNCS
- 164.1 Summary of DBMS_STAT_FUNCS Subprograms
165 DBMS_STATS
- 165.1 DBMS_STATS Overview
- 165.2 DBMS_STATS Deprecated Subprograms
- 165.3 DBMS_STATS Types
- 165.4 DBMS_STATS Constants
- 165.5 DBMS_STATS Operational Notes
- 165.6 DBMS_STATS Data Structures
  - 165.6.1 DBMS_STATS STAT_REC Record Type
- 165.7 Summary of DBMS_STATS Subprograms
166 DBMS_STORAGE_MAP
- 166.1 DBMS_STORAGE_MAP Overview
- 166.2 DBMS_STORAGE_MAP Operational Notes
- 166.3 Summary of DBMS_STORAGE_MAP Subprograms
167 DBMS_SYNC_REFRESH
- 167.1 DBMS_SYNC_REFRESH Overview
- 167.2 DBMS_SYNC_REFRESH Security Model
- 167.3 Summary of DBMS_SYNC_REFRESH Subprograms
168 DBMS_TDB
- 168.1 DBMS_TDB Overview
- 168.2 DBMS_TDB Security Model
- 168.3 DBMS_TDB Constants
- 168.4 DBMS_TDB Views
- 168.5 DBMS_TDB Operational Notes
- 168.6 Summary of DBMS_TDB Subprograms
  - 168.6.1 CHECK_DB Function
  - 168.6.2 CHECK_EXTERNAL Function
169 DBMS_TF
- 169.1 DBMS_TF Overview
- 169.2 DBMS_TF Security Model
- 169.3 DBMS_TF Constants
- 169.4 DBMS_TF Operational Notes
- 169.5 DBMS_TF Execution Flow
- 169.6 DBMS_TF Restrictions
- 169.7 DBMS_TF Examples
  - 169.7.1 Echo Polymorphic Table Function Example
- 169.8 DBMS_TF Data Structures
- 169.9 Summary of DBMS_TF Subprograms
170 DBMS_TNS
- 170.1 DBMS_TNS Overview
- 170.2 DBMS_TNS Security Model
- 170.3 Summary of DBMS_TNS Subprograms
  - 170.3.1 RESOLVE_TNSNAME Function
171 DBMS_TRACE
- 171.1 DBMS_TRACE Overview
- 171.2 DBMS_TRACE Security Model
- 171.3 DBMS_TRACE Constants
- 171.4 DBMS_TRACE Restrictions
- 171.5 DBMS_TRACE Operational Notes
- 171.6 Summary of DBMS_TRACE Subprograms
172 DBMS_TRANSACTION
- 172.1 DBMS_TRANSACTION Security Model
- 172.2 Summary of DBMS_TRANSACTION Subprograms
173 DBMS_TRANSFORM
- 173.1 Summary of DBMS_TRANSFORM Subprograms
174 DBMS_TSDP_MANAGE
- 174.1 DBMS_TSDP_MANAGE Overview
- 174.2 DBMS_TSDP_MANAGE Security Model
- 174.3 Summary of DBMS_TSDP_MANAGE Subprograms
175 DBMS_TSDP_PROTECT
- 175.1 DBMS_TSDP_PROTECT Overview
- 175.2 DBMS_TSDP_PROTECT Security Model
- 175.3 DBMS_TSDP_PROTECT Constants
- 175.4 DBMS_TSDP_PROTECT Data Structures
  - 175.4.1 FEATURE_OPTIONS Table Type
  - 175.4.2 POLICY_CONDITIONS Table Type
- 175.5 Summary of DBMS_TSDP_PROTECT Subprograms
176 DBMS_TTS
- 176.1 DBMS_TTS Security Model
- 176.2 DBMS_TTS Exceptions
- 176.3 DBMS_TTS Operational Notes
- 176.4 Summary of DBMS_TTS Subprograms
  - 176.4.1 DOWNGRADE Procedure
  - 176.4.2 TRANSPORT_SET_CHECK Procedure
177 DBMS_TYPES
- 177.1 DBMS_TYPES Constants
- 177.2 DBMS_TYPES Exceptions
178 DBMS_UMF
- 178.1 Summary of DBMS_UMF Subprograms
179 DBMS_UTILITY
- 179.1 DBMS_UTILITY Deprecated Subprograms
- 179.2 DBMS_UTILITY Security Model
- 179.3 DBMS_UTILITY Constants
- 179.4 DBMS_UTILITY Exceptions
- 179.5 DBMS_UTILITY Data Structures
- 179.6 Summary of DBMS_UTILITY Subprograms
180 DBMS_WARNING
- 180.1 DBMS_WARNING Security Model
- 180.2 Summary of DBMS_WARNING Subprograms
181 DBMS_WM
182 DBMS_WORKLOAD_CAPTURE
- 182.1 DBMS_WORKLOAD_CAPTURE Overview
- 182.2 DBMS_WORKLOAD_CAPTURE Security Model
- 182.3 Summary of DBMS_WORKLOAD_CAPTURE Subprograms
183 DBMS_WORKLOAD_REPLAY
- 183.1 DBMS_WORKLOAD_REPLAY Overview
- 183.2 DBMS_WORKLOAD_REPLAY Security Model
- 183.3 Summary of DBMS_WORKLOAD_REPLAY Subprograms
184 DBMS_WORKLOAD_REPOSITORY
- 184.1 DBMS_WORKLOAD_REPOSITORY Examples
- 184.2 DBMS_WORKLOAD_REPOSITORY Data Structures
- 184.3 Summary of DBMS_WORKLOAD_REPOSITORY Subprograms
185 DBMS_XA
- 185.1 DBMS_XA Overview
- 185.2 DBMS_XA Security Model
- 185.3 DBMS_XA Constants
- 185.4 DBMS_XA Operational Notes
- 185.5 DBMS_XA Data Structures
  - 185.5.1 DBMS_XA DBMS_XA_XID Object Type
  - 185.5.2 DBMS_XA DBMS_XA_XID_ARRAY Table Type
- 185.6 Summary of DBMS_XA Subprograms
186 DBMS_XDB
- 186.1 DBMS_XDB Overview
- 186.2 DBMS_XDB Security Model
- 186.3 DBMS_XDB Constants
- 186.4 Summary of DBMS_XDB Subprograms
187 DBMS_XDB_ADMIN
- 187.1 DBMS_XDB_ADMIN Security Model
- 187.2 Summary of DBMS_XDB_ADMIN Subprograms
188 DBMS_XDB_CONFIG
- 188.1 DBMS_XDB_CONFIG Overview
- 188.2 DBMS_XDB_CONFIG Security Model
- 188.3 DBMS_XDB_CONFIG Constants
- 188.4 Summary of DBMS_XDB_CONFIG Subprograms
189 DBMS_XDB_CONSTANTS
- 189.1 DBMS_XDB_CONSTANTS Security Model
- 189.2 Summary of DBMS_XDB_CONSTANTS Subprograms
190 DBMS_XDB_REPOS
- 190.1 DBMS_XDB_REPOS Overview
- 190.2 DBMS_XDB_REPOS Security Model
- 190.3 DBMS_XDB_REPOS Constants
- 190.4 Summary of DBMS_XDB_REPOS Subprograms
191 DBMS_XDB_VERSION
- 191.1 DBMS_XDB_VERSION Security Model
- 191.2 Summary of DBMS_XDB_VERSION Subprograms
192 DBMS_XDBRESOURCE
- 192.1 DBMS_XDBRESOURCE Overview
- 192.2 DBMS_XDBRESOURCE Security Model
- 192.3 Summary of DBMS_XDBRESOURCE Subprograms
193 DBMS_XDBT
- 193.1 DBMS_XDBT Overview
- 193.2 DBMS_XDBT Security Model
- 193.3 DBMS_XDBT Operational Notes
- 193.4 Summary of DBMS_XDBT Subprograms
194 DBMS_XDBZ
- 194.1 DBMS_XDBZ Security Model
- 194.2 DBMS_XDBZ Constants
- 194.3 Summary of DBMS_XDBZ Subprograms
195 DBMS_XEVENT
- 195.1 DBMS_XEVENT Security Model
- 195.2 DBMS_XEVENT Constants
- 195.3 Subprogram Groups
- 195.4 Summary of DBMS_XEVENT Subprograms
196 DBMS_XMLDOM
- 196.1 DBMS_XMLDOM Overview
- 196.2 DBMS_XMLDOM Security Model
- 196.3 DBMS_XMLDOM Constants
- 196.4 DBMS_XMLDOM Types
- 196.5 DBMS_XMLDOM Exceptions
- 196.6 DBMS_XMLDOM Subprogram Groups
- 196.7 Summary of DBMS_XMLDOM Subprograms
197 DBMS_XMLGEN
- 197.1 DBMS_XMLGEN Security Model
- 197.2 Summary of DBMS_XMLGEN Subprograms
198 DBMS_XMLINDEX
- 198.1 DBMS_XMLINDEX Overview
- 198.2 DBMS_XMLINDEX Security Model
- 198.3 Summary of DBMS_XMLINDEX Subprograms
199 DBMS_XMLPARSER
- 199.1 DBMS_XMLPARSER Security Model
- 199.2 Summary of DBMS_XMLPARSER Subprograms
200 DBMS_XMLQUERY
- 200.1 DBMS_XMLQUERY Security Model
- 200.2 DBMS_XMLQUERY Constants
- 200.3 Types
- 200.4 Summary of DBMS_XMLQUERY Subprograms
201 DBMS_XMLSAVE
- 201.1 DBMS_XMLSAVE Security Model
- 201.2 DBMS_XMLSAVE Constants
- 201.3 Types
- 201.4 Summary of DBMS_XMLSAVE Subprograms
202 DBMS_XMLSCHEMA
- 202.1 DBMS_XMLSCHEMA Overview
- 202.2 DBMS_XMLSCHEMA Security Model
- 202.3 DBMS_XMLSCHEMA Constants
- 202.4 Views
- 202.5 DBMS_XMLSCHEMA Operational Notes
- 202.6 Summary of DBMS_XMLSCHEMA Subprograms
203 DBMS_XMLSCHEMA_ANNOTATE
- 203.1 DBMS_XMLSCHEMA_ANNOTATE Overview
- 203.2 DBMS_XMLSCHEMA_ANNOTATE Security Model
- 203.3 Summary of DBMS_XMLSCHEMA_ANNOTATE Subprograms
204 DBMS_XMLSTORAGE_MANAGE
- 204.1 DBMS_XMLSTORAGE_MANAGE Overview
- 204.2 DBMS_XMLSTORAGE_MANAGE Security Model
- 204.3 Summary of DBMS_XMLSTORAGE_MANAGE Subprograms
205 DBMS_XMLSTORE
- 205.1 DBMS_XMLSTORE Security Model
- 205.2 Types
- 205.3 Summary of DBMS_XMLSTORE Subprograms
206 DBMS_XPLAN
- 206.1 DBMS_XPLAN Overview
- 206.2 DBMS_XPLAN Security Model
- 206.3 DBMS_XPLAN Data Structures
  - 206.3.1 DBMS_XPLAN PLAN_OBJECT_LIST Table Type
- 206.4 Examples
- 206.5 Summary of DBMS_XPLAN Subprograms
207 DBMS_XSLPROCESSOR
- 207.1 DBMS_XSLPROCESSOR Overview
- 207.2 DBMS_XSLPROCESSOR Deprecated Subprograms
- 207.3 DBMS_XSLPROCESSOR Security Model
- 207.4 Summary of DBMS_XSLPROCESSOR Subprograms
208 DBMS_XSTREAM_ADM
- 208.1 DBMS_XSTREAM_ADM Overview
- 208.2 DBMS_XSTREAM_ADM Security Model
- 208.3 DBMS_XSTREAM_ADM Operational Notes
- 208.4 Summary of DBMS_XSTREAM_ADM Subprograms
209 DBMS_XSTREAM_AUTH
- 209.1 DBMS_XSTREAM_AUTH Overview
- 209.2 DBMS_XSTREAM_AUTH Security Model
- 209.3 Summary of DBMS_XSTREAM_AUTH Subprograms
210 DEBUG_EXTPROC
- 210.1 DEBUG_EXTPROC Security Model
- 210.2 DEBUG_EXTPROC Operational Notes
- 210.3 Rules and Limits
- 210.4 Summary of DEBUG_EXTPROC Subprograms
  - 210.4.1 STARTUP_EXTPROC_AGENT Procedure
211 HTF
- 211.1 HTF Deprecated Subprograms
- 211.2 HTF Operational Notes
- 211.3 Rules and Limits
- 211.4 HTF Examples
- 211.5 Summary of Tags
- 211.6 Summary of HTF Subprograms
212 HTP
- 212.1 HTP Operational Notes
- 212.2 HTP Rules and Limits
- 212.3 HTP Examples
- 212.4 HTP Summary of Tags
- 212.5 Summary of HTP Subprograms
213 OWA_CACHE
- 213.1 OWA_CACHE Constants
- 213.2 Summary of OWA_CACHE Subprograms
214 OWA_COOKIE
- 214.1 OWA_CUSTOM Overview
- 214.2 OWA_COOKIE Types
- 214.3 OWA_COOKIE Rules and Limits
- 214.4 Summary of OWA_COOKIE Subprograms
215 OWA_CUSTOM
- 215.1 OWA_CUSTOM Constants
- 215.2 Summary of OWA_CUSTOM Subprograms
  - 215.2.1 AUTHORIZE Function
216 OWA_IMAGE
- 216.1 OWA_IMAGE Overview
- 216.2 OWA_IMAGE Types
- 216.3 OWA_IMAGE Variables
- 216.4 OWA_IMAGE Examples
- 216.5 Summary of OWA_IMAGE Subprograms
  - 216.5.1 GET_X Function
  - 216.5.2 GET_Y Function
217 OWA_OPT_LOCK
- 217.1 OWA_OPT_LOCK Overview
- 217.2 OWA_TEXT Types
- 217.3 Summary of OWA_OPT_LOCK Subprograms
218 OWA_PATTERN
- 218.1 OWA_PATTERN Types
- 218.2 OWA_PATTERN Operational Notes
- 218.3 Summary of OWA_PATTERN Subprograms
219 OWA_SEC
- 219.1 OWA_SEC Operational Notes
- 219.2 Summary of OWA_SEC Subprograms
220 OWA_TEXT
- 220.1 OWA_OPT_LOCK Types
- 220.2 Summary of OWA_TEXT Subprograms
221 OWA_UTIL
- 221.1 OWA_UTIL Overview
- 221.2 OWA_UTIL Types
- 221.3 Summary of OWA_UTIL Subprograms
222 SDO_CS
223 SDO_CSW_PROCESS
224 SDO_GCDR
225 SDO_GEOM
226 SDO_GEOR
227 SDO_GEOR_ADMIN
228 SDO_GEOR_AGGR
229 SDO_GEOR_RA
230 SDO_GEOR_UTL
231 SDO_LRS
232 SDO_MIGRATE
233 SDO_NET
234 SDO_NFE
235 SDO_OLS
236 SDO_PC_PKG
237 SDO_SAM
238 SDO_TIN_PKG
239 SDO_TOPO
240 SDO_TOPO_MAP
241 SDO_TUNE
242 SDO_UTIL
243 SDO_WFS_LOCK
244 SDO_WFS_PROCESS
245 SEM_APIS
246 SEM_OLS
247 SEM_PERF
248 SEM_RDFCTX
249 SEM_RDFSA
250 UTL_CALL_STACK
- 250.1 UTL_CALL_STACK Overview
- 250.2 UTL_CALL_STACK Security Model
- 250.3 UTL_CALL_STACK Operational Notes
- 250.4 UTL_CALL_STACK Exceptions
- 250.5 UTL_CALL_STACK Data Structures
  - 250.5.1 UNIT_QUALIFIED_NAME
- 250.6 Summary of UTL_CALL_STACK Subprograms
251 UTL_COLL
- 251.1 Summary of UTL_COLL Subprograms
  - 251.1.1 IS_LOCATOR Function
252 UTL_COMPRESS
- 252.1 UTL_COMPRESS Constants
- 252.2 UTL_COMPRESS Exceptions
- 252.3 UTL_COMPRESS Operational Notes
- 252.4 Summary of UTL_COMPRESS Subprograms
253 UTL_ENCODE
- 253.1 Summary of UTL_ENCODE Subprograms
254 UTL_FILE
- 254.1 UTL_FILE Security Model
- 254.2 UTL_FILE Operational Notes
- 254.3 UTL_FILE Rules and Limits
- 254.4 UTL_FILE Exceptions
- 254.5 UTL_FILE Examples
- 254.6 UTL_FILE Data Structures
  - 254.6.1 FILETYPE Record Type
- 254.7 Summary of UTL_FILE Subprograms
255 UTL_HTTP
- 255.1 UTL_HTTP Overview
- 255.2 UTL_HTTP Security Model
- 255.3 UTL_HTTP Constants
- 255.4 UTL_HTTP Exceptions
- 255.5 UTL_HTTP Examples
- 255.6 UTL_HTTP Data Structures
- 255.7 UTL_HTTP Operations
- 255.8 UTL_HTTP Subprogram Groups
- 255.9 Summary of UTL_HTTP Subprograms
256 UTL_I18N
- 256.1 UTL_I18N Overview
- 256.2 UTL_I18N Security Model
- 256.3 UTL_I18N Constants
- 256.4 Summary of UTL_I18N Subprograms
257 UTL_IDENT
- 257.1 UTL_IDENT Overview
- 257.2 UTL_IDENT Security Model
- 257.3 UTL_IDENT Constants
258 UTL_INADDR
- 258.1 UTL_INADDR Security Model
- 258.2 UTL_INADDR Exceptions
- 258.3 UTL_INADDR Examples
- 258.4 Summary of UTL_INADDR Subprograms
  - 258.4.1 GET_HOST_ADDRESS Function
  - 258.4.2 GET_HOST_NAME Function
259 UTL_LMS
- 259.1 UTL_LMS Security Model
- 259.2 Summary of UTL_LMS Subprograms
  - 259.2.1 FORMAT_MESSAGE Function
  - 259.2.2 GET_MESSAGE Function
260 UTL_MAIL
- 260.1 UTL_MAIL Security Model
- 260.2 UTL_MAIL Operational Notes
- 260.3 UTL_MAIL Rules and Limits
- 260.4 Summary of UTL_MAIL Subprograms
261 UTL_MATCH
- 261.1 UTL_MATCH Overview
- 261.2 UTL_MATCH Security Model
- 261.3 Summary of UTL_MATCH Subprograms
262 UTL_NLA
- 262.1 UTL_NLA Overview
- 262.2 UTL_NLA Rules and Limits
- 262.3 UTL_NLA Security Model
- 262.4 Subprogram Groups
- 262.5 Summary of UTL_NLA Subprograms
263 UTL_RAW
- 263.1 UTL_RAW Overview
- 263.2 UTL_RAW Operational Notes
- 263.3 Summary of UTL_RAW Subprograms
264 UTL_RECOMP
- 264.1 UTL_RECOMP Overview
- 264.2 UTL_RECOMP Operational Notes
- 264.3 UTL_RECOMP Examples
- 264.4 Summary of UTL_RECOMP Subprograms
  - 264.4.1 RECOMP_PARALLEL Procedure
  - 264.4.2 RECOMP_SERIAL Procedure
265 UTL_REF
- 265.1 UTL_REF Overview
- 265.2 UTL_REF Security Model
- 265.3 UTL_REF Types
- 265.4 UTL_REF Exceptions
- 265.5 Summary of UTL_REF Subprograms
266 UTL_RPADV
- 266.1 UTL_RPADV Overview
- 266.2 DBMS_COMPARISON Security Model
- 266.3 UTL_RPADV Operational Notes
- 266.4 Summary of UTL_RPADV Subprograms
267 UTL_SMTP
- 267.1 UTL_SMTP Overview
- 267.2 UTL_SMTP Security Model
- 267.3 UTL_SMTP Constants
- 267.4 UTL_SMTP Types
- 267.5 UTL_SMTP Reply Codes
- 267.6 UTL_SMTP Operational Notes
- 267.7 UTL_SMTP Exceptions
- 267.8 UTL_SMTP Rules and Limits
- 267.9 UTL_SMTP Examples
- 267.10 Summary of UTL_SMTP Subprograms
268 UTL_TCP
- 268.1 UTL_TCP Overview
- 268.2 UTL_TCP Security Model
- 268.3 UTL_TCP Types
- 268.4 UTL_TCP Exceptions
- 268.5 UTL_TCP Rules and Limits
- 268.6 UTL_TCP Examples
- 268.7 Summary of UTL_TCP Subprograms
269 UTL_URL
- 269.1 UTL_URL Overview
- 269.2 UTL_URL Exceptions
- 269.3 UTL_URL Examples
- 269.4 Summary of UTL_URL Subprograms
  - 269.4.1 ESCAPE Function
  - 269.4.2 UNESCAPE Function
270 WPG_DOCLOAD
- 270.1 WPG_DOCLOAD Constants
- 270.2 Summary of WPG_DOCLOAD Subprograms
  - 270.2.1 DOWNLOAD_FILE Procedures
271 ANYDATA TYPE
- 271.1 ANYDATA TYPE Restrictions
- 271.2 ANYDATA TYPE Operational Notes
- 271.3 Summary of ANYDATA Subprograms
272 ANYDATASET TYPE
- 272.1 ANYDATASET TYPE Construction
- 272.2 Summary of ANYDATASET TYPE Subprograms
273 ANYTYPE TYPE
- 273.1 Summary of ANYTYPE Subprograms
274 Oracle Database Advanced Queuing (AQ) Types
- 274.1 Advanced Queuing (AQ)Types Security Model
- 274.2 Oracle Database Advanced Queuing (AQ) Types —Summary of Types
275 DBFS Content Interface Types
- 275.1 DDBFS Content Interface Types Overview
- 275.2 DBFS Content Interface Types Security Model
- 275.3 DBFS Content Interface Types —Data Structures
276 Database URI TYPEs
- 276.1 Summary of URITYPE Supertype Subprograms
- 276.2 Summary of HTTPURITYPE Subtype Subprograms
- 276.3 Summary of DBURITYPE Subtype Subprogams
- 276.4 Summary of XDBURITYPE Subtype Subprograms
- 276.5 Summary of URIFACTORY Package Subprograms
277 JMS Types
- 277.1 JMS Types Overview
- 277.2 JMS Types Security Model
- 277.3 Java Versus PL/SQL Datatypes
- 277.4 More on Bytes, Stream and Map Messages
- 277.5 Upcasting and Downcasting Between General and Specific Messages
- 277.6 JMS Types Error Reporting
- 277.7 Oracle JMS Type Constants
- 277.8 CONVERT_JMS_SELECTOR
- 277.9 Summary of JMS Types
278 JSON Data Structures
- 278.1 JSON_ELEMENT_T Object Type
- 278.2 JSON_OBJECT_T Object Type
- 278.3 JSON_ARRAY_T Object Type
- 278.4 JSON_SCALAR_T Object Type
- 278.5 JSON_KEY_LIST Type
279 Logical Change Record TYPEs
- 279.1 Logical Change Record TYPEs Overview
- 279.2 Logical Change Record Types Security Model
- 279.3 Summary of Logical Change Record Types
280 MGD_ID Package Types
- 280.1 MGD_ID Package Types Security Model
- 280.2 Summary of Types
- 280.3 Summary of MGD_ID Subprograms
281 Rule TYPEs
- 281.1 Rule TYPEs Overview
- 281.2 Rule TYPEs Security Model
- 281.3 Summary of Rule Types
282 SODA Types
- 282.1 SODA Types Overview
- 282.2 SODA Types Security Model
- 282.3 Summary of SODA Types
283 UTL Streams Types
- 283.1 UTL Streams Types Security Model
- 283.2 Summary of UTL Binary Streams Types
284 XMLTYPE
- 284.1 Summary of XMLType Subprograms
Index

Search

Print

Download

PDF for offline and print

88 DBMS_JAVA

The DBMS_JAVA package provides a PL/SQL interface for accessing database functionality from Java.

For a complete description of this package within the context of DBMS_JAVA, see DBMS_JAVA in the Oracle Database Java Developer's Guide.