Go to main content
1/206
Contents
List of Figures
List of Tables
Title and Copyright Information
Send Us Your Comments
Preface
Audience
Documentation Accessibility
Structure
Related Documents
Conventions
What's New in PL/SQL Packages and Types Reference?
Oracle Database 10g Release 2 (10.2) New Features
Oracle Database 10
g
Release 1 (10.1) New Features
1
Introduction
Package Overview
Package Components
Using Oracle Supplied Packages
Creating New Packages
Separating the Specification and Body
Referencing Package Contents
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
Security Model
Summary of DBMS_ADVANCED_REWRITE Subprograms
ALTER_REWRITE_EQUIVALENCE Procedure
BUILD_SAFE_REWRITE_EQUIVALENCE Procedure
DECLARE_REWRITE_EQUIVALENCE Procedures
DROP_REWRITE_EQUIVALENCE Procedure
VALIDATE_REWRITE_EQUIVALENCE Procedure
12
DBMS_ADVISOR
Using DBMS_ADVISOR
Security Model
Summary of DBMS_ADVISOR Subprograms
ADD_SQLWKLD_REF Procedure
ADD_SQLWKLD_STATEMENT Procedure
CANCEL_TASK Procedure
CREATE_FILE Procedure
CREATE_OBJECT Procedure
CREATE_SQLWKLD Procedure
CREATE_TASK Procedures
DELETE_SQLWKLD Procedure
DELETE_SQLWKLD_REF Procedure
DELETE_SQLWKLD_STATEMENT Procedure
DELETE_TASK Procedure
EXECUTE_TASK Procedure
GET_REC_ATTRIBUTES Procedure
GET_TASK_REPORT Function
GET_TASK_SCRIPT Function
IMPLEMENT_TASK Procedure
IMPORT_SQLWKLD_SCHEMA Procedure
IMPORT_SQLWKLD_SQLCACHE Procedure
IMPORT_SQLWKLD_STS Procedure
IMPORT_SQLWKLD_SUMADV Procedure
IMPORT_SQLWKLD_USER Procedure
INTERRUPT_TASK Procedure
MARK_RECOMMENDATION Procedure
QUICK_TUNE Procedure
RESET_SQLWKLD Procedure
RESET_TASK Procedure
SET_DEFAULT_SQLWKLD_PARAMETER Procedure
SET_DEFAULT_TASK_PARAMETER Procedures
SET_SQLWKLD_PARAMETER Procedure
SET_TASK_PARAMETER Procedure
TUNE_MVIEW Procedure
UPDATE_OBJECT Procedure
UPDATE_REC_ATTRIBUTES Procedure
UPDATE_SQLWKLD_ATTRIBUTES Procedure
UPDATE_SQLWKLD_STATEMENT Procedure
UPDATE_TASK_ATTRIBUTES Procedure
13
DBMS_ALERT
Using DBMS_ALERT
Overview
Security Model
Constants
Restrictions
Exceptions
Operational Notes
Examples
Summary of DBMS_ALERT Subprograms
REGISTER Procedure
REMOVE Procedure
REMOVEALL Procedure
SET_DEFAULTS Procedure
SIGNAL Procedure
WAITANY Procedure
WAITONE Procedure
14
DBMS_APPLICATION_INFO
Using DBMS_APPLICATION_INFO
Overview
Security Model
Operational Notes
Summary of DBMS_APPLICATION_INFO Subprograms
READ_CLIENT_INFO Procedure
READ_MODULE Procedure
SET_ACTION Procedure
SET_CLIENT_INFO Procedure
SET_MODULE Procedure
SET_SESSION_LONGOPS Procedure
15
DBMS_APPLY_ADM
Summary of DBMS_APPLY_ADM Subprograms
ALTER_APPLY Procedure
COMPARE_OLD_VALUES Procedure
CREATE_APPLY Procedure
CREATE_OBJECT_DEPENDENCY Procedure
DELETE_ALL_ERRORS Procedure
DELETE_ERROR Procedure
DROP_APPLY Procedure
DROP_OBJECT_DEPENDENCY
EXECUTE_ALL_ERRORS Procedure
EXECUTE_ERROR Procedure
GET_ERROR_MESSAGE Function
SET_DML_HANDLER Procedure
Signature of a DML Handler Procedure
Signature of an Error Handler Procedure
SET_ENQUEUE_DESTINATION Procedure
SET_EXECUTE Procedure
SET_GLOBAL_INSTANTIATION_SCN Procedure
SET_KEY_COLUMNS Procedures
SET_PARAMETER Procedure
SET_SCHEMA_INSTANTIATION_SCN Procedure
SET_TABLE_INSTANTIATION_SCN Procedure
SET_UPDATE_CONFLICT_HANDLER Procedure
SET_VALUE_DEPENDENCY Procedure
START_APPLY Procedure
STOP_APPLY Procedure
16
DBMS_AQ
Using DBMS_AQ
Constants
Data Structures
Object Name
Type Name
Oracle Streams AQ PL/SQL Callback
Operational Notes
DBMS_AQ and DBMS_AQADM Java Classes
Summary of DBMS_AQ Subprograms
BIND_AGENT Procedure
DEQUEUE Procedure
DEQUEUE_ARRAY Function
ENQUEUE Procedure
ENQUEUE_ARRAY Function
LISTEN Procedures
POST Procedure
REGISTER Procedure
UNBIND_AGENT Procedure
UNREGISTER Procedure
17
DBMS_AQADM
Using DBMS_AQADM
Constants
Subprogram Groups
Queue Table Subprograms
Privilege Subprograms
Queue Subprograms
Subscriber Subprograms
Notification Subprograms
Propagation Subprograms
Oracle Streams AQ Agent Subprograms
Alias Subprograms
Summary of DBMS_AQADM Subprograms
ADD_ALIAS_TO_LDAP Procedure
ADD_SUBSCRIBER Procedure
ALTER_AQ_AGENT Procedure
ALTER_PROPAGATION_SCHEDULE Procedure
ALTER_QUEUE Procedure
ALTER_QUEUE_TABLE Procedure
ALTER_SUBSCRIBER Procedure
CREATE_AQ_AGENT Procedure
CREATE_NP_QUEUE Procedure
CREATE_QUEUE Procedure
CREATE_QUEUE_TABLE Procedure
DEL_ALIAS_FROM_LDAP Procedure
DISABLE_DB_ACCESS Procedure
DISABLE_PROPAGATION_SCHEDULE Procedure
DROP_AQ_AGENT Procedure
DROP_QUEUE Procedure
DROP_QUEUE_TABLE Procedure
ENABLE_DB_ACCESS Procedure
ENABLE_JMS_TYPES Procedure
ENABLE_PROPAGATION_SCHEDULE Procedure
GET_WATERMARK Procedure
GRANT_QUEUE_PRIVILEGE Procedure
GRANT_SYSTEM_PRIVILEGE Procedure
MIGRATE_QUEUE_TABLE Procedure
PURGE_QUEUE_TABLE Procedure
QUEUE_SUBSCRIBERS Function
REMOVE_SUBSCRIBER Procedure
REVOKE_QUEUE_PRIVILEGE Procedure
REVOKE_SYSTEM_PRIVILEGE Procedure
SCHEDULE_PROPAGATION Procedure
SET_WATERMARK Procedure
START_QUEUE Procedure
STOP_QUEUE Procedure
UNSCHEDULE_PROPAGATION Procedure
VERIFY_QUEUE_TYPES Procedure
18
DBMS_AQELM
Summary of DBMS_AQELM Subprograms
SET_MAILHOST Procedure
SET_MAILPORT Procedure
SET_SENDFROM Procedure
19
DBMS_AQIN
Using DBMS_AQIN
Overview
20
DBMS_CAPTURE_ADM
Summary of DBMS_CAPTURE_ADM Subprograms
ABORT_GLOBAL_INSTANTIATION Procedure
ABORT_SCHEMA_INSTANTIATION Procedure
ABORT_TABLE_INSTANTIATION Procedure
ALTER_CAPTURE Procedure
BUILD Procedure
CREATE_CAPTURE Procedure
DROP_CAPTURE Procedure
INCLUDE_EXTRA_ATTRIBUTE Procedure
PREPARE_GLOBAL_INSTANTIATION Procedure
PREPARE_SCHEMA_INSTANTIATION Procedure
PREPARE_TABLE_INSTANTIATION Procedure
SET_PARAMETER Procedure
START_CAPTURE Procedure
STOP_CAPTURE Procedure
21
DBMS_CDC_PUBLISH
Using DBMS_CDC_PUBLISH
Overview
Deprecated Subprograms
Security Model
Views
Summary of DBMS_CDC_PUBLISH Subprograms
ALTER_AUTOLOG_CHANGE_SOURCE Procedure
ALTER_CHANGE_SET Procedure
ALTER_CHANGE_TABLE Procedure
ALTER_HOTLOG_CHANGE_SOURCE Procedure
CREATE_AUTOLOG_CHANGE_SOURCE Procedure
CREATE_CHANGE_SET Procedure
CREATE_CHANGE_TABLE Procedure
CREATE_HOTLOG_CHANGE_SOURCE Procedure
DROP_CHANGE_SET Procedure
DROP_CHANGE_SOURCE Procedure
DROP_CHANGE_TABLE Procedure
DROP_SUBSCRIPTION Procedure
PURGE Procedure
PURGE_CHANGE_SET Procedure
PURGE_CHANGE_TABLE Procedure
22
DBMS_CDC_SUBSCRIBE
Using DBMS_CDC_SUBSCRIBE
Overview
Deprecated Subprograms
Security Model
Views
Summary of DBMS_CDC_SUBSCRIBE Subprograms
ACTIVATE_SUBSCRIPTION Procedure
CREATE_SUBSCRIPTION Procedure
DROP_SUBSCRIPTION Procedure
EXTEND_WINDOW Procedure
PURGE_WINDOW Procedure
SUBSCRIBE Procedure
23
DBMS_CHANGE_NOTIFICATION
Using DBMS_CHANGE_NOTIFICATION
Overview
Security Model
Constants
Operational Notes
Examples
Data Structures
SYS.CHNF$_DESC Object Type
SYS.CHNF$_TDESC Object Type
SYS.CHNF$_TDESC_ARRAY Object (Array) Type
SYS.CHNF$_RDESC Object Type
SYS.CHNF$_RDESC_ARRAY Object (Array) Type
SYS.CHNF$_REG_INFO Object Type
Summary of DBMS_CHANGE_NOTIFICATION Subprograms
DEREGISTER Procedure
ENABLE_REG Procedure
NEW_REG_START Function
REG_END Procedure
24
DBMS_CRYPTO
Using the DBMS_CRYPTO Subprograms
Overview
Security Model
Types
Algorithms
Restrictions
Exceptions
Operational Notes
When to Use Encrypt and Decrypt Procedures or Functions
When to Use Hash or Message Authentication Code (MAC) Functions
About Generating and Storing Encryption Keys
Conversion Rules
Examples
Summary of DBMS_CRYPTO Subprograms
DECRYPT Function
DECRYPT Procedures
ENCRYPT Function
ENCRYPT Procedures
HASH Function
MAC Function
RANDOMBYTES Function
RANDOMINTEGER Function
RANDOMNUMBER Function
25
DBMS_DATA_MINING
Using DBMS_DATA_MINING
Overview
Oracle Data Mining Concepts
Oracle Data Mining APIs
New Functionality
Model Names
Constants
Constants that Specify the Mining Function
Constants that Specify Information About Mining Functions
Constants that Specify Information About Algorithms
Data Types
Exceptions
User Views
Summary of DBMS_DATA_MINING Subprograms
APPLY Procedure
Classification Algorithms
One-Class SVM (Anomaly Detection)
Regression using SVM
Clustering using
k
-Means and O-Cluster
Feature Extraction using NMF
COMPUTE_CONFUSION_MATRIX Procedure
COMPUTE_LIFT Procedure
COMPUTE_ROC Procedure
CREATE_MODEL Procedure
DROP_MODEL Procedure
EXPORT_MODEL Procedure
GET_ASSOCIATION_RULES Function
GET_DEFAULT_SETTINGS Function
GET_FREQUENT_ITEMSETS Function
GET_MODEL_DETAILS_ABN Function
GET_MODEL_DETAILS_AI Function
GET_MODEL_DETAILS_KM Function
GET_MODEL_DETAILS_NB Function
GET_MODEL_DETAILS_NMF Function
GET_MODEL_DETAILS_OC Function
GET_MODEL_DETAILS_SVM Function
GET_MODEL_DETAILS_XML Function
GET_MODEL_SETTINGS Function
GET_MODEL_SIGNATURE Function
IMPORT_MODEL Procedure
RANK_APPLY Procedure
Classification Models — NB, ABN, SVM
Clustering using
k
-Means or O-Cluster
Feature Extraction using NMF
RENAME_MODEL Procedure
26
DBMS_DATA_MINING_TRANSFORM
Using DBMS_DATA_MINING_TRANSFORM
Overview
Types
Transformation Methods
Binning
Normalization
Winsorizing and Trimming (Clipping)
Missing Value Treatment
Steps in Defining a Transformation
Creating a Transformation Definition Table
Defining a Transformation
Generating the Query for a Transform
Sample Transformation
Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
CREATE_BIN_CAT Procedure
CREATE_BIN_NUM Procedure
CREATE_CLIP Procedure
CREATE_MISS_CAT Procedure
CREATE_MISS_NUM Procedure
CREATE_NORM_LIN Procedure
INSERT_AUTOBIN_NUM_EQWIDTH Procedure
INSERT_BIN_CAT_FREQ Procedure
INSERT_BIN_NUM_EQWIDTH Procedure
INSERT_BIN_NUM_QTILE Procedure
INSERT_CLIP_TRIM_TAIL Procedure
INSERT_CLIP_WINSOR_TAIL Procedure
INSERT_MISS_CAT_MODE Procedure
INSERT_MISS_NUM_MEAN Procedure
INSERT_NORM_LIN_MINMAX Procedure
INSERT_NORM_LIN_SCALE Procedure
INSERT_NORM_LIN_ZSCORE Procedure
XFORM_BIN_CAT Procedure
XFORM_BIN_NUM Procedure
XFORM_CLIP Procedure
XFORM_MISS_CAT Procedure
XFORM_MISS_NUM Procedure
XFORM_NORM_LIN Procedure
27
DBMS_DATAPUMP
Using DBMS_DATAPUMP
Overview
Security Model
Roles
Constants
Mask Bit Definitions
Dump File Type Definitions
Data Structures
Data Structures - Object Types
Worker Status Types
Log Entry and Error Types
Job Status Types
Job Description Types
Status Types
Summary of DBMS_DATAPUMP Subprograms
ADD_FILE Procedure
ATTACH Function
DATA_FILTER Procedures
DETACH Procedure
GET_DUMPFILE_INFO Procedure
GET_STATUS Procedure
LOG_ENTRY Procedure
METADATA_FILTER Procedure
METADATA_REMAP Procedure
METADATA_TRANSFORM Procedure
OPEN Function
SET_PARALLEL Procedure
SET_PARAMETER Procedures
START_JOB Procedure
STOP_JOB Procedure
WAIT_FOR_JOB Procedure
28
DBMS_DB_VERSION
Using DBMS_DB_VERSION
Overview
Constants
Examples
29
DBMS_DDL
Using DBMS_DDL
Deprecated Subprograms
Security Model
Operational Notes
Summary of DBMS_DDL Subprograms
ALTER_COMPILE Procedure
ALTER_TABLE_NOT_REFERENCEABLE Procedure
ALTER_TABLE_REFERENCEABLE Procedure
CREATE_WRAPPED Procedures
IS_TRIGGER_FIRE_ONCE Function
SET_TRIGGER_FIRING_PROPERTY Procedure
WRAP Functions
30
DBMS_DEBUG
Using DBMS_DEBUG
Overview
Constants
Variables
Exceptions
Operational Notes
Control of the Interpreter
Session Termination
Deferred Operations
Diagnostic Output
Common and Debug Session Sections
OER Breakpoints
Namespaces
Libunit Types
Breakflags
Information Flags
Reasons for Suspension
Data Structures
BREAKPOINT_INFO Record Type
PROGRAM_INFO Record Type
RUNTIME_INFO Record Type
BACKTRACE_TABLE Table Type
BREAKPOINT_TABLE Table Type
INDEX_TABLE Table Type
VC2_TABLE Table Type
Summary of DBMS_DEBUG Subprograms
ATTACH_SESSION Procedure
CONTINUE Function
DEBUG_OFF Procedure
DEBUG_ON Procedure
DELETE_BREAKPOINT Function
DELETE_OER_BREAKPOINT Function
DETACH_SESSION Procedure
DISABLE_BREAKPOINT Function
ENABLE_BREAKPOINT Function
EXECUTE Procedure
GET_INDEXES Function
GET_MORE_SOURCE Procedure
GET_LINE_MAP Function
GET_RUNTIME_INFO Function
GET_TIMEOUT_BEHAVIOUR Function
GET_VALUE Function
INITIALIZE Function
PING Procedure
PRINT_BACKTRACE Procedure
Parameters
PRINT_INSTANTIATIONS Procedure
PROBE_VERSION Procedure
SELF_CHECK Procedure
SET_BREAKPOINT Function
SET_OER_BREAKPOINT Function
SET_TIMEOUT Function
SET_TIMEOUT_BEHAVIOUR Procedure
SET_VALUE Function
SHOW_BREAKPOINTS Procedures
SHOW_FRAME_SOURCE Procedure
SHOW_SOURCE Procedures
SYNCHRONIZE Function
TARGET_PROGRAM_RUNNING Procedure
31
DBMS_DEFER
Documentation of DBMS_DEFER
32
DBMS_DEFER_QUERY
Documentation of DBMS_DEFER_QUERY
33
DBMS_DEFER_SYS
Documentation of DBMS_DEFER_SYS
34
DBMS_DESCRIBE
Using DBMS_DESCRIBE
Overview
Security Model
Types
Exceptions
Examples
Summary of DBMS_DESCRIBE Subprograms
DESCRIBE_PROCEDURE Procedure
35
DBMS_DIMENSION
Using DBMS_DIMENSION
Security Model
Summary of DBMS_DIMENSION Subprograms
DESCRIBE_DIMENSION Procedure
VALIDATE_DIMENSION Procedure
36
DBMS_DISTRIBUTED_TRUST_ADMIN
Using DBMS_DISTRIBUTED_TRUST_ADMIN
Overview
Security Model
Examples
Summary of DBMS_DISTRIBUTED_TRUST_ADMIN Subprograms
ALLOW_ALL Procedure
ALLOW_SERVER Procedure
DENY_ALL Procedure
DENY_SERVER Procedure
37
DBMS_EPG
Using DBMS_EPG
Overview
Security Model
Exceptions
Data Structures
Subprogram Groups
Configuration Subprograms
Authorization Subprograms
Summary of DBMS_EPG Subprograms
AUTHORIZE_DAD Procedure
CREATE_DAD Procedure
DEAUTHORIZE_DAD Procedure
DELETE_DAD_ATTRIBUTE Procedure
DELETE_GLOBAL_ATTRIBUTE Procedure
DROP_DAD Procedure
GET_ALL_DAD_ATTRIBUTES Procedure
GET_ALL_DAD_MAPPINGS Procedure
GET_ALL_GLOBAL_ATTRIBUTES Procedure
GET_DAD_ATTRIBUTE Function
GET_DAD_LIST Procedure
GET_GLOBAL_ATTRIBUTE Function
MAP_DAD Procedure
SET_DAD_ATTRIBUTE Procedure
SET_GLOBAL_ATTRIBUTE Procedure
UNMAP_DAD Procedure
38
DBMS_ERRLOG
Using DBMS_ERRLOG
Security Model
Summary of DBMS_ERRLOG Subprograms
CREATE_ERROR_LOG Procedure
39
DBMS_EXPFIL
Summary of Expression Filter Subprograms
ADD_ELEMENTARY_ATTRIBUTE Procedures
ADD_FUNCTIONS Procedure
ASSIGN_ATTRIBUTE_SET Procedure
BUILD_EXCEPTIONS_TABLE Procedure
CLEAR_EXPRSET_STATS Procedure
COPY_ATTRIBUTE_SET Procedure
CREATE_ATTRIBUTE_SET Procedure
DEFAULT_INDEX_PARAMETERS Procedure
DEFAULT_XPINDEX_PARAMETERS Procedure
DEFRAG_INDEX Procedure
DROP_ATTRIBUTE_SET Procedure
GET_EXPRSET_STATS Procedure
GRANT_PRIVILEGE Procedure
INDEX_PARAMETERS Procedure
MODIFY_OPERATOR_LIST Procedure
REVOKE_PRIVILEGE Procedure
UNASSIGN_ATTRIBUTE_SET Procedure
VALIDATE_EXPRESSIONS Procedure
XPINDEX_PARAMETERS Procedure
40
DBMS_FGA
Using DBMS_FGA
Security Model
Operational Notes
Summary of DBMS_FGA Subprograms
ADD_POLICY Procedure
DISABLE_POLICY Procedure
DROP_POLICY Procedure
ENABLE_POLICY Procedure
41
DBMS_FILE_GROUP
Using DBMS_FILE_GROUP
Overview
Constants
Summary of DBMS_FILE_GROUP Subprograms
ADD_FILE Procedure
ALTER_FILE Procedure
ALTER_FILE_GROUP Procedure
ALTER_VERSION Procedure
CREATE_FILE_GROUP Procedure
CREATE_VERSION Procedure
DROP_FILE_GROUP Procedure
DROP_VERSION Procedure
GRANT_OBJECT_PRIVILEGE Procedure
GRANT_SYSTEM_PRIVILEGE Procedure
PURGE_FILE_GROUP Procedure
REMOVE_FILE Procedure
REVOKE_OBJECT_PRIVILEGE Procedure
REVOKE_SYSTEM_PRIVILEGE Procedure
42
DBMS_FILE_TRANSFER
Using DBMS_FILE_TRANSFER
Operating Notes
Summary of DBMS_FILE_TRANSFER Subprograms
COPY_FILE Procedure
GET_FILE Procedure
PUT_FILE Procedure
43
DBMS_FLASHBACK
Using DBMS_FLASHBACK
Overview
Security Model
Exceptions
Operational Notes
Examples
Summary of DBMS_FLASHBACK Subprograms
DISABLE Procedure
ENABLE_AT_SYSTEM_CHANGE_NUMBER Procedure
ENABLE_AT_TIME Procedure
GET_SYSTEM_CHANGE_NUMBER Function
SCN_TO_TIMESTAMP Function
TIMESTAMP_TO_SCN Function
44
DBMS_FREQUENT_ITEMSET
Summary of DBMS_FREQUENT_ITEMSET Subprograms
FI_HORIZONTAL Function
FI_TRANSACTIONAL Function
45
DBMS_HS_PASSTHROUGH
Summary of DBMS_HS_PASSTHROUGH Subprograms
BIND_INOUT_VARIABLE Procedure
Syntax
Parameters
Exceptions
Pragmas
BIND_INOUT_VARIABLE_RAW Procedure
Syntax
Parameters
Exceptions
Pragmas
BIND_OUT_VARIABLE Procedure
Syntax
Parameters
Exceptions
Pragmas
BIND_OUT_VARIABLE_RAW Procedure
Syntax
Parameters
Exceptions
Pragmas
BIND_VARIABLE Procedure
Syntax
Parameters
Exceptions
Pragmas
BIND_VARIABLE_RAW Procedure
Syntax
Parameters
Exceptions
Pragmas
CLOSE_CURSOR Procedure
Syntax
Parameters
Exceptions
Pragmas
EXECUTE_IMMEDIATE Procedure
Syntax
Parameters
Return Values
Exceptions
EXECUTE_NON_QUERY Function
Syntax
Parameters
Return Values
Exceptions
FETCH_ROW Function
Syntax
Parameters
Return Values
Exceptions
Pragmas
GET_VALUE Procedure
Syntax
Parameters
Exceptions
Pragmas
GET_VALUE_RAW Procedure
Syntax
Parameters
Exceptions
Pragmas
OPEN_CURSOR Function
Syntax
Return Values
Exceptions
Pragmas
PARSE Procedure
Syntax
Parameters
Exceptions
Pragmas
46
DBMS_IOT
Summary of DBMS_IOT Subprograms
BUILD_CHAIN_ROWS_TABLE Procedure
Syntax
Parameters
Usage Notes
Examples
BUILD_EXCEPTIONS_TABLE Procedure
Syntax
Parameters
Usage Notes
Examples
47
DBMS_JAVA
Documentation of DBMS_JAVA
48
DBMS_JOB
Using DBMS_JOB
Security Model
Operational Notes
Working with Real Application Clusters
Stopping a Job
Summary of DBMS_JOB Subprograms
BROKEN Procedure
CHANGE Procedure
INSTANCE Procedure
INTERVAL Procedure
NEXT_DATE Procedure
REMOVE Procedure
RUN Procedure
SUBMIT Procedure
USER_EXPORT Procedures
WHAT Procedure
49
DBMS_LDAP
Documentation of DBMS_LDAP
50
DBMS_LDAP_UTL
Documentation of DBMS_LDAP_UTL
51
DBMS_LIBCACHE
Using DBMS_LIBCACHE
Overview
Security Model
Summary of DBMS_LIBCACHE Subprograms
COMPILE_FROM_REMOTE Procedure
52
DBMS_LOB
Using DBMS_LOB
Overview
Security Model
Constants
Datatypes
Rules and Limits
General Rules and Limits
Rules and Limits Specific to External Files (BFILEs)
Maximum LOB Size
Maximum Buffer Size
Operational Notes
Internal LOBs
External LOBs
Temporary LOBs
Exceptions
Summary of DBMS_LOB Subprograms
APPEND Procedures
CLOSE Procedure
COMPARE Functions
CONVERTTOBLOB Procedure
CONVERTTOCLOB Procedure
COPY Procedures
CREATETEMPORARY Procedures
ERASE Procedures
FILECLOSE Procedure
FILECLOSEALL Procedure
FILEEXISTS Function
FILEGETNAME Procedure
FILEISOPEN Function
FILEOPEN Procedure
FREETEMPORARY Procedures
GET_STORAGE_LIMIT
GETCHUNKSIZE Functions
GETLENGTH Functions
INSTR Functions
ISOPEN Functions
ISTEMPORARY Functions
LOADBLOBFROMFILE Procedure
LOADCLOBFROMFILE Procedure
LOADFROMFILE Procedure
OPEN Procedures
READ Procedures
SUBSTR Functions
TRIM Procedures
WRITE Procedures
WRITEAPPEND Procedures
53
DBMS_LOCK
Using DBMS_LOCK
Overview
Security Model
Constants
Rules and Limits
Operational Notes
Summary of DBMS_LOCK Subprograms
ALLOCATE_UNIQUE Procedure
CONVERT Function
RELEASE Function
REQUEST Function
SLEEP Procedure
54
DBMS_LOGMNR
Using DBMS_LOGMNR
Overview
Security Model
Constants
Views
Operational Notes
Summary of DBMS_LOGMNR Subprograms
ADD_LOGFILE Procedure
COLUMN_PRESENT Function
END_LOGMNR Procedure
MINE_VALUE Function
REMOVE_LOGFILE Procedure
START_LOGMNR Procedure
55
DBMS_LOGMNR_D
Using DBMS_LOGMNR_D
Overview
Security Model
Summary of DBMS_LOGMNR_D Subprograms
BUILD Procedure
SET_TABLESPACE Procedure
56
DBMS_LOGSTDBY
Using DBMS_LOGSTDBY
Overview
Operational Notes
Deprecated Subprograms
Summary of DBMS_LOGSTDBY Subprograms
APPLY_SET Procedure
APPLY_UNSET Procedure
BUILD Procedure
INSTANTIATE_TABLE Procedure
PREPARE_FOR_NEW_PRIMARY Procedure
PURGE_SESSION Procedure
REBUILD Procedure
SET_TABLESPACE Procedure
SKIP Procedure
SKIP_ERROR Procedure
SKIP_TRANSACTION Procedure
UNSKIP Procedure
UNSKIP_ERROR Procedure
UNSKIP_TRANSACTION Procedure
57
DBMS_METADATA
Using DBMS_METADATA
Overview
Retrieving Metadata
Submitting XML
Security Model
Rules and Limits
Data Structures - Object and Table Types
Subprogram Groupings
Subprograms for Retrieving Multiple Objects From the Database
Subprograms for Submitting XML to the Database
Summary of All DBMS_METADATA Subprograms
ADD_TRANSFORM Function
CLOSE Procedure
CONVERT Functions and Procedures
FETCH_xxx Functions and Procedures
GET_xxx Functions
GET_QUERY Function
OPEN Function
OPENW Function
PUT Function
SET_COUNT Procedure
SET_FILTER Procedure
SET_PARSE_ITEM Procedure
SET_TRANSFORM_PARAM and SET_REMAP_PARAM Procedures
58
DBMS_MGWADM
Using DBMS_MGWADM
Constants
Views
MGW_GATEWAY View
MGW_LINKS View
MGW_MQSERIES_LINKS View
MGW_TIBRV_LINKS View
MGW_FOREIGN_QUEUES View
MGW_SUBSCRIBERS View
MGW_SCHEDULES View
Data Structures
SYS.MGW_MQSERIES_PROPERTIES Object Type
SYS.MGW_PROPERTIES Object Type
SYS.MGW_PROPERTY Object Type
SYS.MGW_TIBRV_PROPERTIES Object Type
Summary of DBMS_MGWADM Subprograms
ADD_SUBSCRIBER Procedure
ALTER_AGENT Procedure
ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous
ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ
ALTER_PROPAGATION_SCHEDULE Procedure
ALTER_SUBSCRIBER Procedure
CLEANUP_GATEWAY Procedure
CREATE_MSGSYSTEM_LINK Procedure for TIB/Rendezvous
CREATE_MSGSYSTEM_LINK Procedure for WebSphere MQ
DB_CONNECT_INFO Procedure
DISABLE_PROPAGATION_SCHEDULE Procedure
ENABLE_PROPAGATION_SCHEDULE Procedure
REGISTER_FOREIGN_QUEUE Procedure
REMOVE_MSGSYSTEM_LINK Procedure
REMOVE_SUBSCRIBER Procedure
RESET_SUBSCRIBER Procedure
SCHEDULE_PROPAGATION Procedure
SET_LOG_LEVEL Procedure
SHUTDOWN Procedure
STARTUP Procedure
UNREGISTER_FOREIGN_QUEUE Procedure
UNSCHEDULE_PROPAGATION Procedure
59
DBMS_MGWMSG
Using DBMS_MGWMSG
Security Model
Constants
Types
SYS.MGW_NAME_VALUE_T Type
SYS.MGW_NAME_TYPE_ARRAY_T Type
SYS.MGW_TEXT_VALUE_T Type
SYS.MGW_RAW_VALUE_T Type
SYS.MGW_BASIC_MSG_T Type
SYS.MGW_NUMBER_ARRAY_T Type
SYS.MGW_TIBRV_FIELD_T Type
SYS.MGW_TIBRV_MSG_T Type
Summary of DBMS_MGWMSG Subprograms
LCR_TO_XML Function
NVARRAY_ADD Procedure
NVARRAY_FIND_NAME Function
NVARRAY_FIND_NAME_TYPE Function
NVARRAY_GET Function
NVARRAY_GET_BOOLEAN Function
NVARRAY_GET_BYTE Function
NVARRAY_GET_DATE Function
NVARRAY_GET_DOUBLE Function
NVARRAY_GET_FLOAT Function
NVARRAY_GET_INTEGER Function
NVARRAY_GET_LONG Function
NVARRAY_GET_RAW Function
NVARRAY_GET_SHORT Function
NVARRAY_GET_TEXT Function
XML_TO_LCR Function
60
DBMS_MONITOR
Summary of DBMS_MONITOR Subprograms
CLIENT_ID_STAT_DISABLE Procedure
CLIENT_ID_STAT_ENABLE Procedure
CLIENT_ID_TRACE_DISABLE Procedure
CLIENT_ID_TRACE_ENABLE Procedure
DATABASE_TRACE_DISABLE Procedure
DATABASE_TRACE_ENABLE Procedure
SERV_MOD_ACT_STAT_DISABLE Procedure
SERV_MOD_ACT_STAT_ENABLE Procedure
SERV_MOD_ACT_TRACE_DISABLE Procedure
SERV_MOD_ACT_TRACE_ENABLE Procedure
SESSION_TRACE_DISABLE Procedure
SESSION_TRACE_ENABLE Procedure
61
DBMS_MVIEW
Using DBMS_MVIEW
Operational Notes
Rules and Limits
Summary of DBMS_MVIEW Subprograms
BEGIN_TABLE_REORGANIZATION Procedure
END_TABLE_REORGANIZATION Procedure
ESTIMATE_MVIEW_SIZE Procedure
EXPLAIN_MVIEW Procedure
EXPLAIN_REWRITE Procedure
I_AM_A_REFRESH Function
PMARKER Function
PURGE_DIRECT_LOAD_LOG Procedure
PURGE_LOG Procedure
PURGE_MVIEW_FROM_LOG Procedure
REFRESH Procedures
REFRESH_ALL_MVIEWS Procedure
REFRESH_DEPENDENT Procedures
REGISTER_MVIEW Procedure
UNREGISTER_MVIEW Procedure
62
DBMS_OBFUSCATION_TOOLKIT
Using DBMS_OBFUSCATION_TOOLKIT
Overview
Security Model
Operational Notes
Key Management
Storing the Key in the Database
Storing the Key in the Operating System
User-Supplied Keys
Summary of DBMS_OBFUSCATION Subprograms
DES3DECRYPT Procedures and Functions
DES3ENCRYPT Procedures and Functions
DES3GETKEY Procedures and Functions
DESDECRYPT Procedures and Functions
DESENCRYPT Procedures and Functions
DESGETKEY Procedures and Functions
MD5 Procedures and Functions
63
DBMS_ODCI
Summary of DBMS_ODCI Subprograms
ESTIMATE_CPU_UNITS Function
64
DBMS_OFFLINE_OG
Documentation of DBMS_OFFLINE_OG
65
DBMS_OLAP
Using DBMS_OLAP
Overview
Views
SYSTEM.MVIEW_EVALUATIONS
SYSTEM.MVIEW_EXCEPTIONS
SYSTEM.MVIEW_FILTER
SYSTEM.MVIEW_FILTERINSTANCE
SYSTEM.MVIEW_LOG
SYSTEM.MVIEW_RECOMMENDATIONS
SYSTEM.MVIEW_WORKLOAD
Deprecated Subprograms
Summary of DBMS_OLAP Subprograms
ADD_FILTER_ITEM Procedure
CREATE_ID Procedure
ESTIMATE_MVIEW_SIZE Procedure
EVALUATE_MVIEW_STRATEGY Procedure
GENERATE_MVIEW_REPORT Procedure
GENERATE_MVIEW_SCRIPT Procedure
LOAD_WORKLOAD_CACHE Procedure
LOAD_WORKLOAD_TRACE Procedure
LOAD_WORKLOAD_USER Procedure
PURGE_FILTER Procedure
PURGE_RESULTS Procedure
PURGE_WORKLOAD Procedure
RECOMMEND_MVIEW_STRATEGY Procedure
SET_CANCELLED Procedure
VALIDATE_DIMENSION Procedure
VALIDATE_WORKLOAD_CACHE Procedure
VALIDATE_WORKLOAD_TRACE Procedure
VALIDATE_WORKLOAD_USER Procedure
66
DBMS_OUTLN
Using DBMS_OUTLN
Overview
Security Model
Summary of DBMS_OUTLN Subprograms
CLEAR_USED Procedure
CREATE_OUTLINE Procedure
DROP_BY_CAT Procedure
DROP_UNUSED Procedure
EXACT_TEXT_SIGNATURES Procedure
UPDATE_BY_CAT Procedure
UPDATE_SIGNATURES Procedure
67
DBMS_OUTLN_EDIT
Summary of DBMS_OUTLN_EDIT Subprograms
CHANGE_JOIN_POS Procedure
CREATE_EDIT_TABLES Procedure
DROP_EDIT_TABLES Procedure
GENERATE_SIGNATURE Procedure
REFRESH_PRIVATE_OUTLINE Procedure
68
DBMS_OUTPUT
Using DBMS_OUTPUT
Overview
Security Model
Operational Notes
Exceptions
Rules and Limits
Examples
Data Structures
CHARARR Table Type
DBMSOUTPUT_LINESARRAY Object Type
Summary of DBMS_OUTPUT Subprograms
DISABLE Procedure
ENABLE Procedure
GET_LINE Procedure
GET_LINES Procedure
NEW_LINE Procedure
PUT Procedure
PUT_LINE Procedure
69
DBMS_PCLXUTIL
Using DBMS_PCLXUTIL
Overview
Operational Notes
Rules and Limits
Summary of DBMS_PCLXUTIL Subprograms
BUILD_PART_INDEX Procedure
70
DBMS_PIPE
Using DBMS_PIPE
Overview
Security Model
Constants
Operational Notes
Public Pipes
Writing and Reading Pipes
Private Pipes
Exceptions
Examples
Example 1: Debugging - PL/SQL
Example 2: Debugging - Pro*C
Example 3: Execute System Commands
Example 4: External Service Interface
Summary of DBMS_PIPE Subprograms
CREATE_PIPE Function
NEXT_ITEM_TYPE Function
PACK_MESSAGE Procedures
PURGE Procedure
RECEIVE_MESSAGE Function
RESET_BUFFER Procedure
REMOVE_PIPE Function
SEND_MESSAGE Function
UNIQUE_SESSION_NAME Function
UNPACK_MESSAGE Procedures
71
DBMS_PREPROCESSOR
Using DBMS_PREPROCESSOR
Overview
Operating Notes
Data Structures
SOURCE_LINES_T Table Type
Summary of DBMS_PREPROCESSOR Subprograms
GET_POST_PROCESSED_SOURCE Functions
PRINT_POST_PROCESSED_SOURCE Procedures
72
DBMS_PREDICTIVE_ANALYTICS
Using DBMS_PREDICTIVE_ANALYTICS
Overview
Summary of DBMS_PREDICTIVE_ANALYTICS Subprograms
EXPLAIN Procedure
PREDICT Procedure
73
DBMS_PROFILER
Using DBMS_PROFILER
Overview
Security Model
Operational Notes
Typical Run
Two Methods of Exception Generation
Exceptions
Summary of DBMS_PROFILER Subprograms
FLUSH_DATA Function and Procedure
GET_VERSION Procedure
INTERNAL_VERSION_CHECK Function
PAUSE_PROFILER Function and Procedure
RESUME_PROFILER Function and Procedure
START_PROFILER Functions and Procedures
STOP_PROFILER Function and Procedure
74
DBMS_PROPAGATION_ADM
Summary of DBMS_PROPAGATION_ADM Subprograms
ALTER_PROPAGATION Procedure
CREATE_PROPAGATION Procedure
DROP_PROPAGATION Procedure
START_PROPAGATION Procedure
STOP_PROPAGATION Procedure
75
DBMS_RANDOM
Using DBMS_RANDOM
Security Model
Operational Notes
Summary of DBMS_RANDOM Subprograms
INITIALIZE Procedure
NORMAL Function
RANDOM Procedure
SEED Procedures
STRING Function
TERMINATE Procedure
VALUE Functions
76
DBMS_RECTIFIER_DIFF
Documentation of DBMS_RECTIFIER_DIFF
77
DBMS_REDEFINITION
Using DBMS_REDEFINITION
Overview
Constants
Operational Notes
Rules and Limits
Summary of DBMS_REDEFINITION Subprograms
ABORT_REDEF_TABLE Procedure
CAN_REDEF_TABLE Procedure
COPY_TABLE_DEPENDENTS Procedure
FINISH_REDEF_TABLE Procedure
REGISTER_DEPENDENT_OBJECT Procedure
START_REDEF_TABLE Procedure
SYNC_INTERIM_TABLE Procedure
UNREGISTER_DEPENDENT_OBJECT Procedure
78
DBMS_REFRESH
Documentation of DBMS_REFRESH
79
DBMS_REPAIR
Using DBMS_REPAIR
Overview
Security Model
Constants
Operating Notes
Exceptions
Examples
Summary of DBMS_REPAIR Subprograms
ADMIN_TABLES Procedure
CHECK_OBJECT Procedure
DUMP_ORPHAN_KEYS Procedure
FIX_CORRUPT_BLOCKS Procedure
ONLINE_INDEX_CLEAN Function
REBUILD_FREELISTS Procedure
SEGMENT_FIX_STATUS Procedure
SKIP_CORRUPT_BLOCKS Procedure
80
DBMS_REPCAT
Documentation of DBMS_REPCAT
81
DBMS_REPCAT_ADMIN
Documentation of DBMS_REPCAT_ADMIN
82
DBMS_REPCAT_INSTANTIATE
Documentation of DBMS_REPCAT_INSTANTIATE
83
DBMS_REPCAT_RGT
Documentation of DBMS_REPCAT_RGT
84
DBMS_REPUTIL
Documentation of DBMS_REPUTIL
85
DBMS_RESOURCE_MANAGER
Using DBMS_RESOURCE_MANAGER
Security Model
Constants
Examples
Summary of DBMS_RESOURCE_MANAGER Subprograms
CLEAR_PENDING_AREA Procedure
CREATE_CONSUMER_GROUP Procedure
CREATE_PENDING_AREA Procedure
CREATE_PLAN Procedure
CREATE_PLAN_DIRECTIVE Procedure
CREATE_SIMPLE_PLAN Procedure
DELETE_CONSUMER_GROUP Procedure
DELETE_PLAN Procedure
DELETE_PLAN_CASCADE Procedure
DELETE_PLAN_DIRECTIVE Procedure
SET_CONSUMER_GROUP_MAPPING Procedure
SET_CONSUMER_GROUP_MAPPING_PRI Procedure
SET_INITIAL_CONSUMER_GROUP Procedure
SUBMIT_PENDING_AREA Procedure
SWITCH_CONSUMER_GROUP_FOR_SESS Procedure
SWITCH_CONSUMER_GROUP_FOR_USER Procedure
SWITCH_PLAN Procedure
UPDATE_CONSUMER_GROUP Procedure
UPDATE_PLAN Procedure
UPDATE_PLAN_DIRECTIVE Procedure
VALIDATE_PENDING_AREA Procedure
86
DBMS_RESOURCE_MANAGER_PRIVS
Summary of DBMS_RESOURCE_MANAGER_PRIVS Subprograms
GRANT_SWITCH_CONSUMER_GROUP Procedure
GRANT_SYSTEM_PRIVILEGE Procedure
REVOKE_SWITCH_CONSUMER_GROUP Procedure
REVOKE_SYSTEM_PRIVILEGE Procedure
87
DBMS_RESUMABLE
Using DBMS_RESUMABLE
Operational Notes
Summary of DBMS_RESUMABLE Subprograms
ABORT Procedure
GET_SESSION_TIMEOUT Function
GET_TIMEOUT Function
SET_SESSION_TIMEOUT Procedure
SET_TIMEOUT Procedure
SPACE_ERROR_INFO Function
88
DBMS_RLMGR
Summary of Rules Manager Subprograms
ADD_ELEMENTARY_ATTRIBUTE Procedures
ADD_EVENT Procedures
ADD_FUNCTIONS Procedure
ADD_RULE Procedure
CONSUME_EVENT Function
CONSUME_PRIM_EVENTS Function
CREATE_EVENT_STRUCTURE Procedure
CREATE_RULE_CLASS Procedure
DELETE_RULE Procedure
DROP_EVENT_STRUCTURE Procedure
DROP_RULE_CLASS Procedure
GRANT_PRIVILEGE Procedure
PROCESS_RULES Procedure
RESET_SESSION Procedure
REVOKE_PRIVILEGE Procedure
89
DBMS_RLS
Using DBMS_RLS
Overview
Security Model
Operational Notes
Summary of DBMS_RLS Subprograms
ADD_GROUPED_POLICY Procedure
ADD_POLICY Procedure
ADD_POLICY_CONTEXT Procedure
CREATE_POLICY_GROUP Procedure
DELETE_POLICY_GROUP Procedure
DISABLE_GROUPED_POLICY Procedure
DROP_GROUPED_POLICY Procedure
DROP_POLICY Procedure
DROP_POLICY_CONTEXT Procedure
ENABLE_GROUPED_POLICY Procedure
ENABLE_POLICY Procedure
REFRESH_GROUPED_POLICY Procedure
REFRESH_POLICY Procedure
90
DBMS_ROWID
Using DBMS_ROWID
Security Model
Types
Extension and Restriction Types
Verification Types
Object Types
Conversion Types
Exceptions
Operational Notes
Examples
Summary of DBMS_ROWID Subprograms
ROWID_BLOCK_NUMBER Function
ROWID_CREATE Function
ROWID_INFO Procedure
ROWID_OBJECT Function
ROWID_RELATIVE_FNO Function
ROWID_ROW_NUMBER Function
ROWID_TO_ABSOLUTE_FNO Function
ROWID_TO_EXTENDED Function
ROWID_TO_RESTRICTED Function
ROWID_TYPE Function
ROWID_VERIFY Function
91
DBMS_RULE
Using DBMS_RULE
Security Model
Summary of DBMS_RULE Subprograms
CLOSE_ITERATOR Procedure
EVALUATE Procedures
GET_NEXT_HIT Function
92
DBMS_RULE_ADM
Using DBMS_RULE_ADM
Security Model
Summary of DBMS_RULE_ADM Subprograms
ADD_RULE Procedure
ALTER_EVALUATION_CONTEXT Procedure
ALTER_RULE Procedure
CREATE_EVALUATION_CONTEXT Procedure
CREATE_RULE Procedure
CREATE_RULE_SET Procedure
DROP_EVALUATION_CONTEXT Procedure
DROP_RULE Procedure
DROP_RULE_SET Procedure
GRANT_OBJECT_PRIVILEGE Procedure
GRANT_SYSTEM_PRIVILEGE Procedure
REMOVE_RULE Procedure
REVOKE_OBJECT_PRIVILEGE Procedure
REVOKE_SYSTEM_PRIVILEGE Procedure
93
DBMS_SCHEDULER
Using DBMS_SCHEDULER
Rules and Limits
Operational Notes
Summary of DBMS_SCHEDULER Subprograms
ADD_EVENT_QUEUE_SUBSCRIBER Procedure
ADD_WINDOW_GROUP_MEMBER Procedure
ALTER_CHAIN Procedure
ALTER_RUNNING_CHAIN Procedure
CLOSE_WINDOW Procedure
COPY_JOB Procedure
CREATE_CHAIN Procedure
CREATE_EVENT_SCHEDULE Procedure
Parameters
Usage Notes
CREATE_JOB Procedures
CREATE_JOB_CLASS Procedure
CREATE_PROGRAM Procedure
CREATE_SCHEDULE Procedure
CREATE_WINDOW Procedures
CREATE_WINDOW_GROUP Procedure
DEFINE_ANYDATA_ARGUMENT Procedure
DEFINE_CHAIN_EVENT_STEP Procedure
DEFINE_CHAIN_RULE Procedure
DEFINE_CHAIN_STEP Procedure
DEFINE_METADATA_ARGUMENT Procedure
DEFINE_PROGRAM_ARGUMENT Procedures
DISABLE Procedure
DROP_CHAIN Procedure
DROP_CHAIN_RULE Procedure
DROP_CHAIN_STEP Procedure
DROP_JOB Procedure
DROP_JOB_CLASS Procedure
DROP_PROGRAM Procedure
DROP_PROGRAM_ARGUMENT Procedures
DROP_SCHEDULE Procedure
DROP_WINDOW Procedure
DROP_WINDOW_GROUP Procedure
ENABLE Procedure
EVALUATE_CALENDAR_STRING Procedure
EVALUATE_RUNNING_CHAIN Procedure
GENERATE_JOB_NAME Function
GET_ATTRIBUTE Procedure
GET_SCHEDULER_ATTRIBUTE Procedure
OPEN_WINDOW Procedure
PURGE_LOG Procedure
REMOVE_EVENT_QUEUE_SUBSCRIBER Procedure
REMOVE_WINDOW_GROUP_MEMBER Procedure
RESET_JOB_ARGUMENT_VALUE Procedures
RUN_CHAIN Procedures
RUN_JOB Procedure
SET_ATTRIBUTE Procedure
SET_ATTRIBUTE_NULL Procedure
SET_JOB_ANYDATA_VALUE Procedures
SET_JOB_ARGUMENT_VALUE Procedures
SET_SCHEDULER_ATTRIBUTE Procedure
STOP_JOB Procedure
94
DBMS_SERVER_ALERT
Using DBMS_SERVER_ALERT
Object Types
Relational Operators
Supported Metrics
Summary of DBMS_SERVER_ALERT Subprograms
EXPAND_MESSAGE Function
GET_THRESHOLD Procedure
SET_THRESHOLD Procedure
95
DBMS_SERVICE
Using DBMS_SERVICE
Overview
Security Model
Constants
Exceptions
Summary of DBMS_SERVICE Subprograms
CREATE_SERVICE Procedure
DELETE_SERVICE Procedure
DISCONNECT_SESSION Procedure
MODIFY_SERVICE Procedure
START_SERVICE Procedure
STOP_SERVICE Procedure
96
DBMS_SESSION
Using DBMS_SESSION
Security Model
Operational Notes
Summary of DBMS_SESSION Subprograms
CLEAR_ALL_CONTEXT Procedure
CLEAR_CONTEXT Procedure
CLEAR_IDENTIFIER Procedure
CLOSE_DATABASE_LINK Procedure
FREE_UNUSED_USER_MEMORY Procedure
IS_ROLE_ENABLED Function
IS_SESSION_ALIVE Function
LIST_CONTEXT Procedures
MODIFY_PACKAGE_STATE Procedure
SESSION _TRACE_DISABLE Procedure
SESSION _TRACE_ENABLE Procedure
RESET_PACKAGE Procedure
SET_CONTEXT Procedure
SET_IDENTIFIER
SET_NLS Procedure
SET_ROLE Procedure
SET_SQL_TRACE Procedure
SWITCH_CURRENT_CONSUMER_GROUP Procedure
UNIQUE_SESSION_ID Function
97
DBMS_SHARED_POOL
Using DBMS_SHARED_POOL
Overview
Operational Notes
Summary of DBMS_SHARED_POOL Subprograms
ABORTED_REQUEST_THRESHOLD Procedure
KEEP Procedure
SIZES Procedure
UNKEEP Procedure
98
DBMS_SPACE
Using DBMS_SPACE
Security Model
Data Structures
ASA_RECO_ROW Record Type
ASA_RECO_ROW_TB Table Type
Summary of DBMS_SPACE Subprograms
ASA_RECOMMENDATIONS Function
CREATE_INDEX_COST Procedure
CREATE_TABLE_COST Procedures
FREE_BLOCKS Procedure
OBJECT_DEPENDENT_SEGMENTS Function
OBJECT_GROWTH_TREND Function
SPACE_USAGE Procedure
UNUSED_SPACE Procedure
99
DBMS_SPACE_ADMIN
Using DBMS_SPACE_ADMIN
Security Model
Constants
Operational Notes
Summary of DBMS_SPACE_ADMIN Subprograms
ASSM_SEGMENT_VERIFY Procedure
ASSM_TABLESPACE_VERIFY Procedure
SEGMENT_CORRUPT Procedure
SEGMENT_DROP_CORRUPT Procedure
SEGMENT_DUMP Procedure
SEGMENT_VERIFY Procedure
TABLESPACE_FIX_BITMAPS Procedure
TABLESPACE_FIX_SEGMENT_STATES Procedure
TABLESPACE_MIGRATE_FROM_LOCAL Procedure
TABLESPACE_MIGRATE_TO_LOCAL Procedure
TABLESPACE_REBUILD_BITMAPS Procedure
TABLESPACE_REBUILD_QUOTAS Procedure
TABLESPACE_RELOCATE_BITMAPS Procedure
TABLESPACE_VERIFY Procedure
100
DBMS_SQL
Using DBMS_SQL
Overview
Security Model
Constants
Types
BFILE_TABLE
BINARY_DOUBLE_TABLE
BINARY_FLOAT_TABLE
BLOB_TABLE
CLOB_TABLE
DATE_TABLE
INTERVAL_DAY_TO_SECOND_TABLE
INTERVAL_YEAR_TO_MONTH_TABLE
DESC_REC, DESC_TAB
NUMBER_TABLE
TIME_TABLE
TIME_WITH_TIME_ZONE_TABLE
TIMESTAMP_TABLE
TIMESTAMP_WITH_LTZ_TABLE
UROWID_TABLE
VARCHAR2_TABLE
VARCHAR2A, DESC_REC2
VARCHAR2S
Exceptions
Operational Notes
Execution Flow
Processing Queries
Processing Updates, Inserts, and Deletes
Locating Errors
Examples
Summary of DBMS_SQL Subprograms
BIND_ARRAY Procedures
BIND_VARIABLE Procedures
CLOSE_CURSOR Procedure
COLUMN_VALUE Procedure
COLUMN_VALUE_LONG Procedure
DEFINE_ARRAY Procedure
DEFINE_COLUMN Procedure
DEFINE_COLUMN_LONG Procedure
DESCRIBE_COLUMNS Procedure
DESCRIBE_COLUMNS2 Procedure
EXECUTE Function
EXECUTE_AND_FETCH Function
FETCH_ROWS Function
IS_OPEN Function
LAST_ERROR_POSITION Function
LAST_ROW_COUNT Function
LAST_ROW_ID Function
LAST_SQL_FUNCTION_CODE Function
OPEN_CURSOR Function
PARSE Procedure
VARIABLE_VALUE Procedures
101
DBMS_SQLTUNE
Using DBMS_SQLTUNE
Overview
Security Model
Data Structures
SQLSET_ROW Object Type
Subprogram Groups
SQL Tuning Advisor Subprograms
SQL Profile Subprograms
SQL Tuning Set Subprograms
Summary of DBMS_SQLTUNE Subprograms
ACCEPT_SQL_PROFILE Procedure and Function
ADD_SQLSET_REFERENCE Function
ALTER_SQL_PROFILE Procedure
CANCEL_TUNING_TASK Procedure
CAPTURE_CURSOR_CACHE_SQLSET Procedure
CREATE_SQLSET Procedure and Function
CREATE_STGTAB_SQLPROF Procedure
CREATE_STGTAB_SQLSET Procedure
CREATE_TUNING_TASK Functions
DELETE_SQLSET Procedure
DROP_SQL_PROFILE Procedure
DROP_SQLSET Procedure
DROP_TUNING_TASK Procedure
EXECUTE_TUNING_TASK Procedure
INTERRUPT_TUNING_TASK Procedure
LOAD_SQLSET Procedure
PACK_STGTAB_SQLPROF Procedure
PACK_STGTAB_SQLSET Procedure
REMAP_STGTAB_SQLPROF Procedure
REMAP_STGTAB_SQLSET Procedure
REMOVE_SQLSET_REFERENCE Procedure
REPORT_TUNING_TASK Function
RESET_TUNING_TASK Procedure
RESUME_TUNING_TASK Procedure
SCRIPT_TUNING_TASK Function
SELECT_CURSOR_CACHE Function
SELECT_SQLSET Function
SELECT_WORKLOAD_REPOSITORY Functions
SQLTEXT_TO_SIGNATURE Function
UNPACK_STGTAB_SQLPROF Procedure
UNPACK_STGTAB_SQLSET Procedure
UPDATE_SQLSET Procedures
102
DBMS_STAT_FUNCS
Summary of DBMS_STAT_FUNCS Subprograms
EXPONENTIAL_DIST_FIT Procedure
NORMAL_DIST_FIT Procedure
POISSON_DIST_FIT Procedure
SUMMARY Procedure
UNIFORM_DIST_FIT Procedure
WEIBULL_DIST_FIT Procedure
103
DBMS_STATS
Using DBMS_STATS
Overview
Types
Constants
Operational Notes
Deprecated Subprograms
Examples
Summary of DBMS_STATS Subprograms
ALTER_DATABASE_TAB_MONITORING Procedure
ALTER_SCHEMA_TAB_MONITORING Procedure
ALTER_STATS_HISTORY_RETENTION Procedure
CONVERT_RAW_VALUE Procedures
CONVERT_RAW_VALUE_NVARCHAR Procedure
CONVERT_RAW_VALUE_ROWID Procedure
CREATE_STAT_TABLE Procedure
DELETE_COLUMN_STATS Procedure
DELETE_DATABASE_STATS Procedure
DELETE_DICTIONARY_STATS Procedure
DELETE_FIXED_OBJECTS_STATS Procedure
DELETE_INDEX_STATS Procedure
DELETE_SCHEMA_STATS Procedure
DELETE_SYSTEM_STATS Procedure
DELETE_TABLE_STATS Procedure
DROP_STAT_TABLE Procedure
EXPORT_COLUMN_STATS Procedure
EXPORT_DATABASE_STATS Procedure
EXPORT_DICTIONARY_STATS Procedure
EXPORT_FIXED_OBJECTS_STATS Procedure
EXPORT_INDEX_STATS Procedure
EXPORT_SCHEMA_STATS Procedure
EXPORT_SYSTEM_STATS Procedure
EXPORT_TABLE_STATS Procedure
FLUSH_DATABASE_MONITORING_INFO Procedure
GATHER_DATABASE_STATS Procedures
GATHER_DICTIONARY_STATS Procedure
GATHER_FIXED_OBJECTS_STATS Procedure
GATHER_INDEX_STATS Procedure
GATHER_SCHEMA_STATS Procedures
GATHER_SYSTEM_STATS Procedure
GATHER_TABLE_STATS Procedure
GENERATE_STATS Procedure
GET_COLUMN_STATS Procedures
GET_INDEX_STATS Procedures
GET_PARAM Function
GET_STATS_HISTORY_AVAILABILITY Function
GET_STATS_HISTORY_RETENTION Function
GET_SYSTEM_STATS Procedure
GET_TABLE_STATS Procedure
IMPORT_COLUMN_STATS Procedure
IMPORT_DATABASE_STATS Procedure
IMPORT_DICTIONARY_STATS Procedure
IMPORT_FIXED_OBJECTS_STATS Procedure
IMPORT_INDEX_STATS Procedure
IMPORT_SCHEMA_STATS Procedure
IMPORT_SYSTEM_STATS Procedure
IMPORT_TABLE_STATS Procedure
LOCK_SCHEMA_STATS Procedure
LOCK_TABLE_STATS Procedure
PREPARE_COLUMN_VALUES Procedures
PREPARE_COLUMN_VALUES_NVARCHAR2 Procedure
PREPARE_COLUMN_VALUES_ROWID Procedure
PURGE_STATS Procedure
RESET_PARAM_DEFAULTS Procedure
RESTORE_DATABASE_STATS Procedure
RESTORE_DICTIONARY_STATS Procedure
RESTORE_FIXED_OBJECTS_STATS Procedure
RESTORE_SCHEMA_STATS Procedure
RESTORE_SYSTEM_STATS Procedure
RESTORE_TABLE_STATS Procedure
SET_COLUMN_STATS Procedures
SET_INDEX_STATS Procedures
SET_PARAM Procedure
SET_SYSTEM_STATS Procedure
SET_TABLE_STATS Procedure
UNLOCK_SCHEMA_STATS Procedure
UNLOCK_TABLE_STATS Procedure
UPGRADE_STAT_TABLE Procedure
104
DBMS_STORAGE_MAP
Using DBMS_STORAGE_MAP
Overview
Operational Notes
Summary of DBMS_STORAGE_MAP Subprograms
DROP_ALL Function
DROP_ELEMENT Function
DROP_FILE Function
Parameters
LOCK_MAP Procedure
MAP_ALL Function
MAP_ELEMENT Function
MAP_FILE Function
MAP_OBJECT Function
RESTORE Function
SAVE Function
UNLOCK_MAP Procedure
105
DBMS_STREAMS
Using DBMS_STREAMS
Security Model
Summary of DBMS_STREAMS Subprograms
COMPATIBLE_10_2 Function
COMPATIBLE_10_1 Function
COMPATIBLE_9_2 Function
CONVERT_ANYDATA_TO_LCR_DDL Function
CONVERT_ANYDATA_TO_LCR_ROW Function
CONVERT_LCR_TO_XML Function
CONVERT_XML_TO_LCR Function
GET_INFORMATION Function
GET_STREAMS_NAME Function
GET_STREAMS_TYPE Function
GET_TAG Function
SET_TAG Procedure
106
DBMS_STREAMS_ADM
Using DBMS_STREAMS_ADM
Overview
Deprecated Subprograms
Security Model
Capture User
Propagation User
Apply User
Messaging Client User
Operational Notes
Procedures That Create Rules and Streams Clients
Procedures That Configure a Streams Replication Environment
Summary of DBMS_STREAMS_ADM Subprograms
ADD_COLUMN Procedure
ADD_GLOBAL_PROPAGATION_RULES Procedure
ADD_GLOBAL_RULES Procedure
ADD_MESSAGE_PROPAGATION_RULE Procedure
ADD_MESSAGE_RULE Procedure
ADD_SCHEMA_PROPAGATION_RULES Procedure
ADD_SCHEMA_RULES Procedure
ADD_SUBSET_PROPAGATION_RULES Procedure
ADD_SUBSET_RULES Procedure
ADD_TABLE_PROPAGATION_RULES Procedure
ADD_TABLE_RULES Procedure
CLEANUP_INSTANTIATION_SETUP Procedure
DELETE_COLUMN Procedure
GET_SCN_MAPPING Procedure
MAINTAIN_GLOBAL Procedure
MAINTAIN_SCHEMAS Procedure
MAINTAIN_SIMPLE_TABLESPACE Procedure
MAINTAIN_SIMPLE_TTS Procedure
MAINTAIN_TABLES Procedure
MAINTAIN_TABLESPACES Procedure
MAINTAIN_TTS Procedure
POST_INSTANTIATION_SETUP Procedure
PRE_INSTANTIATION_SETUP Procedure
PURGE_SOURCE_CATALOG Procedure
RECOVER_OPERATION Procedure
REMOVE_QUEUE Procedure
REMOVE_RULE Procedure
REMOVE_STREAMS_CONFIGURATION Procedure
RENAME_COLUMN Procedure
RENAME_SCHEMA Procedure
RENAME_TABLE Procedure
SET_MESSAGE_NOTIFICATION Procedure
SET_RULE_TRANSFORM_FUNCTION Procedure
SET_UP_QUEUE Procedure
107
DBMS_STREAMS_AUTH
Summary of DBMS_STREAMS_AUTH Subprograms
GRANT_ADMIN_PRIVILEGE Procedure
GRANT_REMOTE_ADMIN_ACCESS Procedure
REVOKE_ADMIN_PRIVILEGE Procedure
REVOKE_REMOTE_ADMIN_ACCESS Procedure
108
DBMS_STREAMS_MESSAGING
Summary of DBMS_STREAMS_MESSAGING Subprograms
DEQUEUE Procedure
ENQUEUE Procedure
109
DBMS_STREAMS_TABLESPACE_ADM
Using DBMS_STREAMS_TABLESPACE_ADM
Overview
Types
DIRECTORY_OBJECT_SET Type
FILE Type
FILE_SET Type
TABLESPACE_SET Type
Summary of DBMS_STREAMS_TABLESPACE_ADM Subprograms
ATTACH_SIMPLE_TABLESPACE Procedure
ATTACH_TABLESPACES Procedure
CLONE_SIMPLE_TABLESPACE Procedure
CLONE_TABLESPACES Procedure
DETACH_SIMPLE_TABLESPACE Procedure
DETACH_TABLESPACES Procedure
PULL_SIMPLE_TABLESPACE Procedure
PULL_TABLESPACES Procedure
110
DBMS_TRACE
Using DBMS_TRACE
Overview
Security Model
Constants
Restrictions
Operational Notes
Controlling Data Volume
Creating Database Tables to Collect DBMS_TRACE Output
Collecting Trace Data
Collected Data
Trace Control
Summary of DBMS_TRACE Subprograms
CLEAR_PLSQL_TRACE Procedure
PLSQL_TRACE_VERSION Procedure
SET_PLSQL_TRACE Procedure
111
DBMS_TRANSACTION
Using DBMS_TRANSACTION
Security Model
Summary of DBMS_TRANSACTION Subprograms
ADVISE_COMMIT Procedure
ADVISE_NOTHING Procedure
ADVISE_ROLLBACK Procedure
BEGIN_DISCRETE_TRANSACTION Procedure
COMMIT Procedure
COMMIT_COMMENT Procedure
COMMIT_FORCE Procedure
LOCAL_TRANSACTION_ID Function
PURGE_LOST_DB_ENTRY Procedure
PURGE_MIXED Procedure
READ_ONLY Procedure
READ_WRITE Procedure
ROLLBACK Procedure
ROLLBACK_FORCE Procedure
ROLLBACK_SAVEPOINT Procedure
SAVEPOINT Procedure
STEP_ID Function
USE_ROLLBACK_SEGMENT Procedure
112
DBMS_TRANSFORM
Summary of DBMS_TRANSFORM Subprograms
CREATE_TRANSFORMATION Procedure
DROP_TRANSFORMATION Procedure
MODIFY_TRANSFORMATION Procedure
113
DBMS_TDB
Using DBMS_TDB
Overview
Security Model
Constants
Views
Operational Notes
Summary of DBMS_TDB Subprograms
CHECK_DB Function
CHECK_EXTERNAL Function
114
DBMS_TTS
Using DBMS_TTS
Security Model
Exceptions
Operational Notes
Summary of DBMS_TTS Subprograms
DOWNGRADE Procedure
TRANSPORT_SET_CHECK Procedure
115
DBMS_TYPES
Using DBMS_TYPES
Constants
Exceptions
116
DBMS_UTILITY
Using DBMS_UTILITY
Security Model
Constants
Types
dblink_array
index_table_type
instance_record
lname_array
name_array
number_array
uncl_array
Deprecated Subprograms
Exceptions
Summary of DBMS_UTILITY Subprograms
ACTIVE_INSTANCES Procedure
ANALYZE_DATABASE Procedure
ANALYZE_PART_OBJECT Procedure
ANALYZE_SCHEMA Procedure
CANONICALIZE Procedure
COMMA_TO_TABLE Procedures
COMPILE_SCHEMA Procedure
CREATE_ALTER_TYPE_ERROR_TABLE Procedure
CURRENT_INSTANCE Function
DATA_BLOCK_ADDRESS_BLOCK Function
DATA_BLOCK_ADDRESS_FILE Function
DB_VERSION Procedure
EXEC_DDL_STATEMENT Procedure
FORMAT_CALL_STACK Function
FORMAT_ERROR_BACKTRACE Function
FORMAT_ERROR_STACK Function
GET_CPU_TIME Function
GET_DEPENDENCY Procedure
GET_HASH_VALUE Function
GET_PARAMETER_VALUE Function
GET_TIME Function
INVALIDATE Procedure
IS_CLUSTER_DATABASE Function
MAKE_DATA_BLOCK_ADDRESS Function
NAME_RESOLVE Procedure
NAME_TOKENIZE Procedure
PORT_STRING Function
TABLE_TO_COMMA Procedures
VALIDATE Procedure
117
DBMS_WARNING
Using DBMS_WARNING
Security Model
Summary of DBMS_WARNING Subprograms
ADD_WARNING_SETTING_CAT Procedure
ADD_WARNING_SETTING_NUM Procedure
GET_CATEGORY Function
GET_WARNING_SETTING_CAT Function
GET_WARNING_SETTING_NUM Function
GET_WARNING_SETTING_STRING Function
SET_WARNING_SETTING_STRING Procedure
118
DBMS_WORKLOAD_CAPTURE
Using DBMS_WORKLOAD_CAPTURE
Overview
Security Model
Summary of DBMS_WORKLOAD_CAPTURE Subprograms
ADD_FILTER Procedures
DELETE_CAPTURE_INFO Procedure
DELETE_FILTER Procedure
EXPORT_AWR Procedure
FINISH_CAPTURE Procedure
GET_CAPTURE_INFO Function
IMPORT_AWR Function
REPORT Function
START_CAPTURE Procedure
119
DBMS_WORKLOAD_REPOSITORY
Using DBMS_WORKLOAD_REPOSITORY
Examples
Summary of DBMS_WORKLOAD_REPOSITORY Subprograms
ASH_REPORT_HTML Function
ASH_REPORT_TEXT Function
AWR_DIFF_REPORT_HTML Function
AWR_DIFF_REPORT_TEXT Function
AWR_REPORT_HTML Function
AWR_REPORT_TEXT Function
AWR_SQL_REPORT_HTML Function
AWR_SQL_REPORT_TEXT Function
CREATE_BASELINE Function and Procedure
CREATE_SNAPSHOT Function and Procedure
DROP_BASELINE Procedure
DROP_SNAPSHOT_RANGE Procedure
MODIFY_SNAPSHOT_SETTINGS Procedures
120
DBMS_WM
Documentation of DBMS_WM
121
DBMS_XDB
Using DBMS_XDB
Overview
Constants
Summary of DBMS_XDB Subprograms
ACLCHECKPRIVILEGES Function
APPENDRESOURCEMETADATA Procedure
CFG_GET Function
CFG_REFRESH Procedure
CFG_UPDATE Procedure
CHANGEPRIVILEGES Function
CHECKPRIVILEGES Function
CREATEFOLDER Function
CREATEOIDPATH Function
CREATERESOURCE Functions
DELETERESOURCE Procedure
DELETERESOURCEMETADATA Procedures
EXISTSRESOURCE Function
GETACLDOCUMENT Function
GETFTPPORT Function
GETHTTPPORT Function
GETLOCKTOKEN Procedure
GETPRIVILEGES Function
GETRESOID Function
GETXDB_TABLESPACE Function
LINK Procedure
LOCKRESOURCE Function
MOVEXDB_TABLESPACE Procedure
PURGERESOURCEMETADATA Procedure
REBUILDHIERARCHICALINDEX Procedure
RENAMERESOURCE Procedure
SETACL Procedure
SETFTPPORT Procedure
SETHTTPPORT Procedure
UPDATERESOURCEMETADATA Procedures
UNLOCKRESOURCE Function
122
DBMS_XDB_VERSION
Summary of DBMS_XDB_VERSION Subprograms
CHECKIN Function
CHECKOUT Procedure
GETCONTENTSBLOBBYRESID Function
GETCONTENTSCLOBBYRESID Function
GETCONTENTSXMLBYRESID Function
GETPREDECESSORS Function
GETPREDSBYRESID Function
GETRESOURCEBYRESID Function
GETSUCCESSORS Function
GETSUCCSBYRESID Function
MAKEVERSIONED Function
UNCHECKOUT Function
123
DBMS_XDBT
Using DBMS_XDBT
Overview
Operational Notes
Summary of DBMS_XDBT Subprograms
CONFIGUREAUTOSYNC Procedure
CREATEDATASTOREPREF Procedure
CREATEFILTERPREF Procedure
CREATEINDEX Procedure
CREATELEXERPREF Procedure
CREATEPREFERENCES Procedure
CREATESECTIONGROUPPREF Procedure
CREATESTOPLISTPREF Procedure
CREATESTORAGEPREF Procedure
CREATEWORLDLISTPREF Procedure
DROPPREFERENCES Procedure
124
DBMS_XDBZ
Using DBMS_XDBZ
Constants
Summary of DBMS_XDBZ Subprograms
DISABLE_HIERARCHY Procedure
ENABLE_HIERARCHY Procedure
GET_ACLOID Function
GET_USERID Function
IS_HIERARCHY_ENABLED Function
PURGELDAPCACHE Function
125
DBMS_XMLDOM
Using DBMS_XMLDOM
Overview
Constants
Types
Exceptions
Subprogram Groups
DOMNode Subprograms
DOMAttr Subprograms
DOMCDataSection Subprograms
DOMCharacterData Subprograms
DOMComment Subprograms
DOMDocument Subprograms
DOMDocumentFragment Subprograms
DOMDocumentType Subprograms
DOMElement Subprograms
DOMEntity Subprograms
DOMEntityReference Subprograms
DOMImplementation Subprograms
DOMNamedNodeMap Subprograms
DOMNodeList Subprograms
DOMNotation Subprograms
DOMProcessingInstruction Subprograms
DOMText Subprograms
Summary of DBMS_XMLDOM Subprograms
ADOPTNODE Function
APPENDCHILD Function
APPENDDATA Procedure
CLONENODE Function
CREATEATTRIBUTE Functions
CREATECDATASECTION Function
CREATECOMMENT Function
CREATEDOCUMENT Function
CREATEDOCUMENTFRAGMENT Function
CREATEELEMENT Functions
CREATEENTITYREFERENCE Function
CREATEPROCESSINGINSTRUCTION Function
CREATETEXTNODE Function
DELETEDATA Procedure
FINDENTITY Function
FINDNOTATION Function
FREEDOCFRAG Procedure
FREEDOCUMENT Procedure
FREENODE Procedure
GETATTRIBUTE Functions
GETATTRIBUTENODE Functions
GETATTRIBUTES Function
GETCHILDNODES Function
GETCHILDRENBYTAGNAME Functions
GETDATA Functions
GETDOCTYPE Function
GETDOCUMENTELEMENT Function
GETELEMENTSBYTAGNAME Functions
GETENTITIES Function
GETEXPANDEDNAME Procedure and Functions
GETFIRSTCHILD Function
GETIMPLEMENTATION Function
GETLASTCHILD Function
GETLENGTH Functions
GETLOCALNAME Procedure and Functions
GETNAME Functions
GETNAMEDITEM Function
GETNAMESPACE Procedure and Functions
GETNEXTSIBLING Function
GETNODENAME Function
GETNODETYPE Function
GETNODEVALUE Function
GETNOTATIONNAME Function
GETNOTATIONS Function
GETTARGET Function
GETOWNERDOCUMENT Function
GETOWNERELEMENT Function
GETPARENTNODE Function
GETPREFIX Function
GETPREVIOUSSIBLING Function
GETPUBLICID Functions
GETQUALIFIEDNAME Functions
GETSCHEMANODE Function
GETSPECIFIED Function
GETSTANDALONE Function
GETSYSTEMID Functions
GETTAGNAME Function
GETVALUE Function
GETVERSION Function
GETXMLTYPE Function
HASATTRIBUTE Functions
HASATTRIBUTES Function
HASCHILDNODES Function
HASFEATURE Function
IMPORTNODE Function
INSERTBEFORE Function
INSERTDATA Procedure
ISNULL Functions
ITEM Functions
MAKEATTR Function
MAKECDATASECTION Function
MAKECHARACTERDATA Function
MAKECOMMENT Function
MAKEDOCUMENT Function
MAKEDOCUMENTFRAGMENT Function
MAKEDOCUMENTTYPE Function
MAKEELEMENT Function
MAKEENTITY Function
MAKEENTITYREFERENCE Function
MAKENODE Functions
MAKENOTATION Function
MAKEPROCESSINGINSTRUCTION Function
MAKETEXT Function
NEWDOMDOCUMENT Functions
NORMALIZE Procedure
REMOVEATTRIBUTE Procedures
REMOVEATTRIBUTENODE Function
REMOVECHILD Function
REMOVENAMEDITEM Function
REPLACECHILD Function
REPLACEDATA Procedure
RESOLVENAMESPACEPREFIX Function
SETATTRIBUTE Procedures
SETATTRIBUTENODE Functions
SETDATA Procedures
SETDOCTYPE Procedure
SETNAMEDITEM Function
SETNODEVALUE Procedure
SETPREFIX Procedure
SETSTANDALONE Procedure
SETVALUE Procedure
SETVERSION Procedure
SPLITTEXT Function
SUBSTRINGDATA Function
WRITETOBUFFER Procedures
WRITETOCLOB Procedures
WRITETOFILE Procedures
126
DBMS_XMLGEN
Summary of DBMS_XMLGEN Subprograms
CLOSECONTEXT Procedure
CONVERT Functions
GETNUMROWSPROCESSED Function
GETXML Functions
GETXMLTYPE Functions
NEWCONTEXT Functions
RESTARTQUERY Procedure
SETCONVERTSPECIALCHARS Procedure
SETMAXROWS Procedure
SETNULLHANDLING Procedure
SETROWSETTAG Procedure
SETROWTAG Procedure
SETSKIPROWS Procedure
USEITEMTAGSFORCOLL Procedure
USENULLATTRIBUTEINDICATOR Procedure
127
DBMS_XMLPARSER
Summary of DBMS_XMLPARSER Subprograms
FREEPARSER
GETDOCTYPE
GETDOCUMENT
GETRELEASEVERSION
GETVALIDATIONMODE
NEWPARSER
PARSE
PARSEBUFFER
PARSECLOB
PARSEDTD
PARSEDTDBUFFER
PARSEDTDCLOB
SETBASEDIR
SETDOCTYPE
SETERRORLOG
SETPRESERVEWHITESPACE
SETVALIDATIONMODE
SHOWWARNINGS
128
DBMS_XMLQUERY
Using DBMS_XMLQUERY
Constants
Types
Summary of DBMS_XMLQUERY Subprograms
CLOSECONTEXT
GETDTD
GETEXCEPTIONCONTENT
GETNUMROWSPROCESSED
GETVERSION
GETXML
NEWCONTEXT
PROPAGATEORIGINALEXCEPTION
REMOVEXSLTPARAM
SETBINDVALUE
SETCOLLIDATTRNAME
SETDATAHEADER
SETDATEFORMAT
SETENCODINGTAG
SETERRORTAG
SETMAXROWS
SETMETAHEADER
SETRAISEEXCEPTION
SETRAISENOROWSEXCEPTION
SETROWIDATTRNAME
SETROWIDATTRVALUE
SETROWSETTAG
SETROWTAG
SETSKIPROWS
SETSQLTOXMLNAMEESCAPING
SETSTYLESHEETHEADER
SETTAGCASE
SETXSLT
SETXSLTPARAM
USENULLATTRIBUTEINDICATOR
USETYPEFORCOLLELEMTAG
129
DBMS_XMLSAVE
Using DBMS_XMLSAVE
Constants
Types
Summary of DBMS_XMLSAVE Subprograms
CLEARKEYCOLUMNLIST
CLEARUPDATECOLUMNLIST
CLOSECONTEXT
DELETEXML
GETEXCEPTIONCONTENT
INSERTXML
NEWCONTEXT
PROPAGATEORIGINALEXCEPTION
REMOVEXSLTPARAM
SETBATCHSIZE
SETCOMMITBATCH
SETDATEFORMAT
SETIGNORECASE
SETKEYCOLUMN
SETPRESERVEWHITESPACE
SETROWTAG
SETSQLTOXMLNAMEESCAPING
SETUPDATECOLUMN
SETXSLT
SETXSLTPARAM
UPDATEXML
130
DBMS_XMLSCHEMA
Using DBMS_XMLSCHEMA
Overview
Constants
Views
Summary of DBMS_XMLSCHEMA Subprograms
COMPILESCHEMA Procedure
COPYEVOLVE Procedure
DELETESCHEMA Procedure
GENERATEBEAN Procedure
GENERATESCHEMA Function
GENERATESCHEMAS Function
REGISTERSCHEMA Procedures
REGISTERURI Procedure
131
DBMS_XMLSTORE
Using DBMS_XMLSTORE
Types
Summary of DBMS_XMLSTORE Subprograms
CLEARKEYCOLUMNLIST
CLEARUPDATECOLUMNLIST
CLOSECONTEXT
DELETEXML
INSERTXML
NEWCONTEXT
SETKEYCOLUMN
SETROWTAG
SETUPDATECOLUMN
UPDATEXML
132
DBMS_XPLAN
Using DBMS_XPLAN
Overview
Security Model
Examples
Summary of DBMS_XPLAN Subprograms
DISPLAY Function
DISPLAY_AWR Function
DISPLAY_CURSOR Function
DISPLAY_SQLSET Function
133
DBMS_XSLPROCESSOR
Using DBMS_XSLPROCESSOR
Overview
Summary of DBMS_XSLPROCESSOR Subprograms
CLOB2FILE Procedure
FREEPROCESSOR Procedure
FREESTYLESHEET Procedure
NEWPROCESSOR Function
NEWSTYLESHEET Functions
PROCESSXSL Functions and Procedures
READ2CLOB Function
REMOVEPARAM Procedure
RESETPARAMS Procedure
SELECTNODES Function
SELECTSINGLENODE Function
SETERRORLOG Procedure
SETPARAM Procedure
SHOWWARNINGS Procedure
TRANSFORMNODE Function
VALUEOF Function and Procedure
134
DEBUG_EXTPROC
Using DEBUG_EXTPROC
Security Model
Operational Notes
Rules and Limits
Summary of DEBUG_EXTPROC Subprograms
STARTUP_EXTPROC_AGENT Procedure
135
HTF
Using HTF
Operational Notes
Rules and Limits
Examples
Summary of Tags
Summary of HTF Subprograms
ADDRESS Function
ANCHOR Function
ANCHOR2 Function
APPLETCLOSE Function
APPLETOPEN Function
AREA Function
BASE Function
BASEFONT Function
BGSOUND Function
BIG Function
BLOCKQUOTECLOSE Function
BLOCKQUOTEOPEN Function
BODYCLOSE Function
BODYOPEN Function
BOLD Function
BR Function
CENTER Function
CENTERCLOSE Function
CENTEROPEN Function
CITE Function
CODE Function
COMMENT Function
DFN Function
DIRLISTCLOSE Function
DIRLISTOPEN Function
DIV Function
DLISTCLOSE Function
DLISTDEF Function
DLISTOPEN Function
DLISTTERM Function
EM Function
EMPHASIS Function
ESCAPE_SC Function
ESCAPE_URL Function
FONTCLOSE Function
FONTOPEN Function
FORMAT_CELL Function
FORMCHECKBOX Function
FORMCLOSE Function
FORMFILE Function
FORMHIDDEN Function
FORMIMAGE Function
FORMOPEN Function
FORMPASSWORD Function
FORMRADIO Function
FORMRESET Function
FORMSELECTCLOSE Function
FORMSELECTOPEN Function
FORMSELECTOPTION Function
FORMSUBMIT Function
FORMTEXT Function
FORMTEXTAREA Function
FORMTEXTAREA2 Function
FORMTEXTAREACLOSE Function
FORMTEXTAREAOPEN Function
FORMTEXTAREAOPEN2 Function
FRAME Function
FRAMESETCLOSE Function
FRAMESETOPEN Function
HEADCLOSE Function
HEADER Function
HEADOPEN Function
HR Function
HTMLCLOSE Function
HTMLOPEN Function
IMG Function
IMG2 Function
ISINDEX Function
ITALIC Function
KBD Function
KEYBOARD Function
LINE Function
LINKREL Function
LINKREV Function
LISTHEADER Function
LISTINGCLOSE Function
LISTINGOPEN Function
LISTITEM Function
MAILTO Function
MAPCLOSE Function
MAPOPEN Function
MENULISTCLOSE Function
MENULISTOPEN Function
META Function
NL Function
NOBR Function
NOFRAMESCLOSE Function
NOFRAMESOPEN Function
OLISTCLOSE Function
OLISTOPEN Function
PARA Function
PARAGRAPH Function
PARAM Function
PLAINTEXT Function
PRECLOSE Function
PREOPEN Function
PRINT Functions
PRN Functions
S Function
SAMPLE Function
SCRIPT Function
SMALL Function
STRIKE Function
STRONG Function
STYLE Function
SUB Function
SUP Function
TABLECAPTION Function
TABLECLOSE Function
TABLEDATA Function
TABLEHEADER Function
TABLEOPEN Function
TABLEROWCLOSE Function
TABLEROWOPEN Function
TELETYPE Function
TITLE Function
ULISTCLOSE Function
ULISTOPEN Function
UNDERLINE Function
VARIABLE Function
WBR Function
136
HTMLDB_CUSTOM_AUTH
Documentation of HTMLDB_CUSTOM_AUTH
137
HTMLDB_APPLICATION
Documentation of HTMLDB_APPLICATION
138
HTMLDB_ITEM
Documentation of HTMLDB_ITEM
139
HTMLDB_UTIL
Documentation of HTMLDB_UTIL
140
HTP
Using HTP
Operational Notes
Rules and Limits
Examples
Summary of Tags
Summary of HTP Subprograms
ADDRESS Procedure
ANCHOR Procedure
ANCHOR2 Procedure
APPLETCLOSE Procedure
APPLETOPEN Procedure
AREA Procedure
BASE Procedure
BASEFONT Procedure
BGSOUND Procedure
BIG Procedure
BLOCKQUOTECLOSE Procedure
BLOCKQUOTEOPEN Procedure
BODYCLOSE Procedure
BODYOPEN Procedure
BOLD Procedure
BR Procedure
CENTER Procedure
CENTERCLOSE Procedure
CENTEROPEN Procedure
CITE Procedure
CODE Procedure
COMMENT Procedure
DFN Procedure
DIRLISTCLOSE Procedure
DIRLISTOPEN Procedure
DIV Procedure
DLISTCLOSE Procedure
DLISTDEF Procedure
DLISTOPEN Procedure
DLISTTERM Procedure
EM Procedure
EMPHASIS Procedure
ESCAPE_SC Procedure
FONTCLOSE Procedure
FONTOPEN Procedure
FORMCHECKBOX Procedure
FORMCLOSE Procedure
FORMOPEN Procedure
FORMFILE Procedure
FORMHIDDEN Procedure
FORMIMAGE Procedure
FORMPASSWORD Procedure
FORMRADIO Procedure
FORMRESET Procedure
FORMSELECTCLOSE Procedure
FORMSELECTOPEN Procedure
FORMSELECTOPTION Procedure
FORMSUBMIT Procedure
FORMTEXT Procedure
FORMTEXTAREA Procedure
FORMTEXTAREA2 Procedure
FORMTEXTAREACLOSE Procedure
FORMTEXTAREAOPEN Procedure
FORMTEXTAREAOPEN2 Procedure
FRAME Procedure
FRAMESETCLOSE Procedure
FRAMESETOPEN Procedure
HEADCLOSE Procedure
HEADER Procedure
HEADOPEN Procedure
HR Procedure
HTMLCLOSE Procedure
HTMLOPEN Procedure
IMG Procedure
IMG2 Procedure
ISINDEX Procedure
ITALIC Procedure
KBD Procedure
KEYBOARD Procedure
LINE Procedure
LINKREL Procedure
LINKREV Procedure
LISTHEADER Procedure
LISTINGCLOSE Procedure
LISTINGOPEN Procedure
LISTITEM Procedure
MAILTO Procedure
MAPCLOSE Procedure
MAPOPEN Procedure
MENULISTCLOSE Procedure
MENULISTOPEN Procedure
META Procedure
NL Procedure
NOBR Procedure
NOFRAMESCLOSE Procedure
NOFRAMESOPEN Procedure
OLISTCLOSE Procedure
OLISTOPEN Procedure
PARA Procedure
PARAGRAPH Procedure
PARAM Procedure
PLAINTEXT Procedure
PRECLOSE Procedure
PREOPEN Procedure
PRINT Procedures
PRINTS Procedure
PRN Procedures
PS Procedure
S Procedure
SAMPLE Procedure
SCRIPT Procedure
SMALL Procedure
STRIKE Procedure
STRONG Procedure
STYLE Procedure
SUB Procedure
SUP Procedure
TABLECAPTION Procedure
TABLECLOSE Procedure
TABLEDATA Procedure
TABLEHEADER Procedure
TABLEOPEN Procedure
TABLEROWCLOSE Procedure
TABLEROWOPEN Procedure
TELETYPE Procedure
TITLE Procedure
ULISTCLOSE Procedure
ULISTOPEN Procedure
UNDERLINE Procedure
VARIABLE Procedure
WBR Procedure
141
OWA_CACHE
Using OWA_CACHE
Constants
Summary of OWA_CACHE Subprograms
DISABLE Procedure
GET_ETAG Function
GET_LEVEL Function
SET_CACHE Procedure
SET_EXPIRES Procedure
SET_NOT_MODIFIED Procedure
SET_SURROGATE_CONTROL Procedure
142
OWA_COOKIE
Using OWA_COOKIE
Overview
Types
Rules and Limits
Summary of OWA_COOKIE Subprograms
GET Function
GET_ALL Procedure
REMOVE Procedure
SEND procedure
143
OWA_CUSTOM
Using OWA_CUSTOM
Constants
Summary of OWA_CUSTOM Subprograms
AUTHORIZE Function
144
OWA_IMAGE
Using OWA_IMAGE
Overview
Types
Variables
Examples
Summary of OWA_IMAGE Subprograms
GET_X Function
GET_Y Function
145
OWA_OPT_LOCK
Using OWA_OPT_LOCK
Overview
Types
Summary of OWA_OPT_LOCK Subprograms
CHECKSUM Functions
GET_ROWID Function
STORE_VALUES Procedure
VERIFY_VALUES Function
146
OWA_PATTERN
Using OWA_PATTERN
Types
Operational Notes
Wildcards
Quantifiers
Flags
Summary of OWA_PATTERN Subprograms
AMATCH Function
CHANGE Functions and Procedures
GETPAT Procedure
MATCH Function
147
OWA_SEC
Using OWA_SEC
Operational Notes
Summary of OWA_SEC Subprograms
GET_CLIENT_HOSTNAME Function
GET_CLIENT_IP Function
GET_PASSWORD Function
GET_USER_ID Function
SET_AUTHORIZATION Procedure
SET_PROTECTION_REALM Procedure
148
OWA_TEXT
Using OWA_TEXT
Types
MULTI_LINE DATA TYPE
ROW_LIST DATA TYPE
VC_ARR DATA TYPE
Summary of OWA_TEXT Subprograms
ADD2MULTI Procedure
NEW_ROW_LIST Function and Procedure
PRINT_MULTI Procedure
PRINT_ROW_LIST Procedure
STREAM2MULTI Procedure
149
OWA_UTIL
Using OWA_UTIL
Overview
Types
DATETYPE Data Type
IDENT_ARR Data Type
IP_ADDRESS Data Type
Summary of OWA_UTIL Subprograms
BIND_VARIABLES Function
CALENDARPRINT Procedures
CELLSPRINT Procedures
CHOOSE_DATE Procedure
GET_CGI_ENV Function
GET_OWA_SERVICE_PATH Function
GET_PROCEDURE Function
HTTP_HEADER_CLOSE Procedure
LISTPRINT Procedure
MIME_HEADER Procedure
PRINT_CGI_ENV Procedure
REDIRECT_URL Procedure
SHOWPAGE Procedure
SHOWSOURCE Procedure
SIGNATURE procedure
STATUS_LINE Procedure
TABLEPRINT Function
TODATE Function
WHO_CALLED_ME Procedure
150
SDO_CS
Documentation of SDO_CS
151
SDO_GCDR
Documentation of SDO_GCDR
152
SDO_GEOM
Documentation of SDO_GEOM
153
SDO_GEOR
Documentation of SDO_GEOR
154
SDO_GEOR_UTL
Documentation of SDO_GEOR_UTL
155
SDO_LRS
Documentation of SDO_LRS
156
SDO_MIGRATE
Documentation of SDO_MIGRATE
157
SDO_NET
Documentation of SDO_NET
158
SDO_NET_MEM
Documentation of SDO_NET_MEM
159
SDO_SAM
Documentation of SDO_SAM
160
SDO_TOPO
Documentation of SDO_TOPO
161
SDO_TOPO_MAP
Documentation of SDO_TOPO_MAP
162
SDO_TUNE
Documentation of SDO_TUNE
163
SDO_UTIL
Documentation of SDO_UTIL
164
UTL_COLL
Summary of UTL_COLL Subprograms
IS_LOCATOR Function
Examples
165
UTL_COMPRESS
Using UTL_COMPRESS
Constants
Exceptions
Operational Notes
Summary of UTL_COMPRESS Subprograms
ISOPEN Function
Return Values
Examples
LZ_COMPRESS Functions and Procedures
LZ_COMPRESS_ADD Procedure
Exceptions
LZ_COMPRESS_CLOSE
Exceptions
LZ_COMPRESS_OPEN
Return Values
Exceptions
Usage Notes
LZ_UNCOMPRESS Functions and Procedures
LZ_UNCOMPRESS_EXTRACT Procedure
Exceptions
LZ_UNCOMPRESS_OPEN Function
Return Values
Exceptions
Usage Notes
LZ_UNCOMPRESS_CLOSE Procedure
Exceptions
166
UTL_DBWS
Using UTL_DBWS
Supported Keys and Default Settings for Standard Call Properties
Summary of UTL_DBWS Subprograms
CREATE_CALL Function
CREATE_SERVICE Function
GET_IN_PARAMETER_TYPES Function
GET_OUT_PARAMETER_TYPES Function
GET_OUTPUT_VALUES Function
GET_PORTS Function
GET_PROPERTY Function
GET_RETURN_TYPE Function
GET_SERVICES Function
INVOKE Function
RELEASE_ALL_SERVICES Procedure
RELEASE_CALL Procedure
RELEASE_SERVICE Procedure
REMOVE_PROPERTY Procedure
SET_PROPERTY Procedure
167
UTL_ENCODE
Summary of UTL_ENCODE Subprograms
BASE64_DECODE Function
BASE64_ENCODE Function
MIMEHEADER_DECODE Function
MIMEHEADER_ENCODE Function
QUOTED_PRINTABLE_DECODE Function
QUOTED_PRINTABLE_ENCODE Function
TEXT_DECODE Function
TEXT_ENCODE Function
UUDECODE Function
UUENCODE Function
168
UTL_FILE
Using UTL_FILE
Security Model
Types
Operational Notes
Rules and Limits
Exceptions
Examples
Summary of UTL_FILE Subprograms
FCLOSE Procedure
FCLOSE_ALL Procedure
FCOPY Procedure
FFLUSH Procedure
FGETATTR Procedure
FGETPOS Function
FOPEN Function
FOPEN_NCHAR Function
FREMOVE Procedure
FRENAME Procedure
FSEEK Procedure
GET_LINE Procedure
GET_LINE_NCHAR Procedure
GET_RAW Function
IS_OPEN Function
NEW_LINE Procedure
PUT Procedure
PUT_LINE Procedure
PUT_LINE_NCHAR Procedure
PUT_NCHAR Procedure
PUTF Procedure
PUTF_NCHAR Procedure
PUT_RAW Function
169
UTL_HTTP
Using UTL_HTTP
Overview
Constants
Datatypes
REQ Type
RESP Type
COOKIE and COOKIE_TABLE Types
CONNECTION Type
Operational Notes
Operational Flow
Simple HTTP Fetches
Session Settings
HTTP Requests
HTTP Responses
HTTP Cookies
HTTP Persistent Connections
Error Conditions
Exceptions
Examples
General Usage
Handling HTTP Authentication
Retrieving and Restoring Cookies
Subprogram Groups
Simple HTTP Fetches in a Single Call Subprograms
Session Settings Subprograms
HTTP Requests Subprograms
HTTP Responses Subprograms
HTTP Cookies Subprograms
HTTP Persistent Connections Subprograms
Error Conditions Subprograms
Summary of UTL_HTTP Subprograms
ADD_COOKIES Procedure
BEGIN_REQUEST Function
CLEAR_COOKIES Procedure
CLOSE_PERSISTENT_CONN Procedure
CLOSE_PERSISTENT_CONNS Procedure
END_REQUEST Procedure
END_RESPONSE Procedure
GET_AUTHENTICATION Procedure
GET_BODY_CHARSET Procedure
GET_COOKIE_COUNT Function
GET_COOKIE_SUPPORT Procedure
GET_COOKIES Function
GET_DETAILED_EXCP_SUPPORT Procedure
GET_DETAILED_SQLCODE Function
GET_DETAILED_SQLERRM Function
GET_FOLLOW_REDIRECT Procedure
GET_HEADER Procedure
GET_HEADER_BY_NAME Procedure
GET_HEADER_COUNT Function
GET_PERSISTENT_CONN_COUNT Function
GET_PERSISTENT_CONN_SUPPORT Procedure
GET_PERSISTENT_CONNS Procedure
GET_PROXY Procedure
GET_RESPONSE Function
GET_RESPONSE_ERROR_CHECK Procedure
GET_TRANSFER_TIMEOUT Procedure
READ_LINE Procedure
READ_RAW Procedure
READ_TEXT Procedure
REQUEST Function
REQUEST_PIECES Function
SET_AUTHENTICATION Procedure
SET_BODY_CHARSET Procedures
SET_COOKIE_SUPPORT Procedures
SET_DETAILED_EXCP_SUPPORT Procedure
SET_FOLLOW_REDIRECT Procedures
SET_HEADER Procedure
SET_PERSISTENT_CONN_SUPPORT Procedure
SET_PROXY Procedure
SET_RESPONSE_ERROR_CHECK Procedure
SET_TRANSFER_TIMEOUT Procedure
SET_WALLET Procedure
WRITE_LINE Procedure
WRITE_RAW Procedure
WRITE_TEXT Procedure
170
UTL_I18N
Using UTL_I18N
Overview
Constants
Summary of UTL_I18N Subprograms
ESCAPE_REFERENCE Function
GET_COMMON_TIME_ZONES Function
GET_DEFAULT_CHARSET Function
GET_DEFAULT_ISO_CURRENCY Function
GET_DEFAULT_LINGUISTIC_SORT Function
GET_LOCAL_LANGUAGES Function
GET_LOCAL_LINGUISTIC_SORTS Function
GET_LOCAL_TERRITORIES Function
GET_LOCAL_TIME_ZONES Function
GET_TRANSLATION Function
MAP_CHARSET Function
MAP_FROM_SHORT_LANGUAGE Function
MAP_LANGUAGE_FROM_ISO Function
MAP_LOCALE_TO_ISO Function
MAP_TERRITORY_FROM_ISO Function
MAP_TO_SHORT_LANGUAGE Function
RAW_TO_CHAR Functions
RAW_TO_NCHAR Functions
STRING_TO_RAW Function
TRANSLITERATE Function
UNESCAPE_REFERENCE Function
171
UTL_INADDR
Using UTL_INADDR
Exceptions
Examples
Summary of UTL_INADDR Subprograms
GET_HOST_ADDRESS Function
GET_HOST_NAME Function
172
UTL_LMS
Using UTL_LMS
Security Model
Summary of UTL_LMS Subprograms
FORMAT_MESSAGE Function
GET_MESSAGE Function
173
UTL_MAIL
Using UTL_MAIL
Security Model
Operational Notes
Summary of UTL_MAIL Subprograms
SEND Procedure
SEND_ATTACH_RAW Procedure
SEND_ATTACH_VARCHAR2 Procedure
174
UTL_NLA
Using UTL_NLA
Overview
Rules and Limits
Subprogram Groups
BLAS Level 1 (Vector-Vector Operations) Subprograms
BLAS Level 2 (Matrix-Vector Operations) Subprograms
BLAS Level 3 (Matrix-Matrix Operations) Subprograms
LAPACK Driver Routines (Linear Equations) Subprograms
LAPACK Driver Routines (LLS and Eigenvalue Problems) Subprograms
Summary of UTL_NLA Subprograms
BLAS_ASUM Functions
BLAS_AXPY Procedures
BLAS_COPY Procedures
BLAS_DOT Functions
BLAS_GBMV Procedures
BLAS_GEMM Procedures
BLAS_GEMV Procedures
BLAS_GER Procedures
BLAS_IAMAX Functions
BLAS_NRM2 Functions
BLAS_ROT Procedures
BLAS_ROTG Procedures
BLAS_SCAL Procedures
BLAS_SPMV Procedures
BLAS_SPR Procedures
BLAS_SPR2 Procedures
BLAS_SBMV Procedures
BLAS_SWAP Procedures
BLAS_SYMM Procedures
BLAS_SYMV Procedures
BLAS_SYR Procedures
BLAS_SYR2 Procedures
BLAS_SYR2K Procedures
BLAS_SYRK Procedures
BLAS_TBMV Procedures
BLAS_TBSV Procedures
BLAS_TPMV Procedures
BLAS_TPSV Procedures
BLAS_TRMM Procedures
BLAS_TRMV Procedures
BLAS_TRSM Procedures
BLAS_TRSV Procedures
LAPACK_GBSV Procedures
LAPACK_GEES Procedures
LAPACK_GELS Procedures
LAPACK_GESDD Procedures
LAPACK_GESV Procedures
LAPACK_GESVD Procedures
LAPACK_GEEV Procedures
LAPACK_GTSV Procedures
LAPACK_PBSV Procedures
LAPACK_POSV Procedures
LAPACK_PPSV Procedures
LAPACK_PTSV Procedures
LAPACK_SBEV Procedures
LAPACK_SBEVD Procedures
LAPACK_SPEV Procedures
LAPACK_SPEVD Procedures
LAPACK_SPSV Procedures
LAPACK_STEV Procedures
LAPACK_STEVD Procedures
LAPACK_SYEV Procedures
LAPACK_SYEVD Procedures
LAPACK_SYSV Procedures
175
UTL_RAW
Using UTL_RAW
Overview
Operational Notes
Summary of UTL_RAW Subprograms
BIT_AND Function
BIT_COMPLEMENT Function
BIT_OR Function
BIT_XOR Function
CAST_FROM_BINARY_DOUBLE Function
CAST_FROM_BINARY_FLOAT Function
CAST_FROM_BINARY_INTEGER Function
CAST_FROM_NUMBER Function
CAST_TO_BINARY_DOUBLE Function
CAST_TO_BINARY_FLOAT Function
CAST_TO_BINARY_INTEGER Function
CAST_TO_NUMBER Function
CAST_TO_RAW Function
CAST_TO_VARCHAR2 Function
CAST_TO_NVARCHAR2 Function
COMPARE Function
CONCAT Function
CONVERT Function
COPIES Function
LENGTH Function
OVERLAY Function
REVERSE Function
SUBSTR Function
TRANSLATE Function
TRANSLITERATE Function
XRANGE Function
176
UTL_RECOMP
Using UTL_RECOMP
Overview
Operational Notes
Examples
Summary of UTL_RECOMP Subprograms
RECOMP_PARALLEL Procedure
RECOMP_SERIAL Procedure
177
UTL_REF
Using UTL_REF
Overview
Security Model
Types
Exceptions
Summary of UTL_REF Subprograms
DELETE_OBJECT Procedure
LOCK_OBJECT Procedure
SELECT_OBJECT Procedure
UPDATE_OBJECT Procedure
178
UTL_SMTP
Using UTL_SMTP
Overview
Types
CONNECTION Record Type
REPLY, REPLIES Record Types
Reply Codes
Exceptions
Rules and Limits
Examples
Summary of UTL_SMTP Subprograms
CLOSE_DATA Function and Procedure
COMMAND Function and Procedure
COMMAND_REPLIES Function
DATA Function and Procedure
EHLO Function and Procedure
HELO Function and Procedure
HELP Function
MAIL Function and Procedure
NOOP Function and Procedure
OPEN_CONNECTION Functions
OPEN_DATA Function and Procedure
QUIT Function and Procedure
RCPT Function
RSET Function and Procedure
VRFY Function
WRITE_DATA Procedure
WRITE_RAW_DATA Procedure
179
UTL_TCP
Using UTL_TCP
Overview
Types
CONNECTION Type
CRLF
Exceptions
Rules and Limits
Examples
Summary of UTL_TCP Subprograms
AVAILABLE Function
CLOSE_ALL_CONNECTIONS Procedure
CLOSE_CONNECTION Procedure
FLUSH Procedure
GET_LINE Function
GET_RAW Function
GET_TEXT Function
OPEN_CONNECTION Function
READ_LINE Function
READ_RAW Function
READ_TEXT Function
WRITE_LINE Function
WRITE_RAW Function
WRITE_TEXT Function
180
UTL_URL
Using UTL_URL
Overview
Exceptions
Examples
Summary of UTL_URL Subprograms
ESCAPE Function
UNESCAPE Function
181
WPG_DOCLOAD
Using WPG_DOCLOAD
Constants
NAME_COL_LEN
MIMET_COL_LEN
MAX_DOCTABLE_NAME_LEN
Summary of WPG_DOCLOAD Subprograms
DOWNLOAD_FILE Procedures
182
ANYDATA TYPE
Using ANYDATA TYPE
Restrictions
Operational Notes
Construction
Access
Summary of ANYDATA Subprograms
BEGINCREATE Static Procedure
ENDCREATE Member Procedure
GET* Member Functions
GETTYPE Member Function
GETTYPENAME Member Function
PIECEWISE Member Procedure
SET* Member Procedures
183
ANYDATASET TYPE
Construction
Summary of ANYDATASET TYPE Subprograms
ADDINSTANCE Member Procedure
BEGINCREATE Static Procedure
ENDCREATE Member Procedure
GET* Member Functions
GETCOUNT Member Function
GETINSTANCE Member Function
GETTYPE Member Function
GETTYPENAME Member Function
PIECEWISE Member Procedure
SET* Member Procedures
184
ANYTYPE TYPE
Summary of ANYTYPE Subprograms
BEGINCREATE Static Procedure
SETINFO Member Procedure
ADDATTR Member Procedure
ENDCREATE Member Procedure
GETPERSISTENT Static Function
GETINFO Member Function
GETATTRELEMINFO Member Function
185
Oracle Streams AQ TYPEs
Summary of Types
AQ$_AGENT Type
AQ$_AGENT_LIST_T Type
AQ$_DESCRIPTOR Type
AQ$_NTFN_DESCRIPTOR Type
AQ$_POST_INFO Type
AQ$_POST_INFO_LIST Type
AQ$_PURGE_OPTIONS_T Type
AQ$_RECIPIENT_LIST_T Type
AQ$_REG_INFO Type
AQ$_REG_INFO_LIST Type
AQ$_SUBSCRIBER_LIST_T Type
DEQUEUE_OPTIONS_T Type
ENQUEUE_OPTIONS_T Type
SYS.MSG_PROP_T Type
MESSAGE_PROPERTIES_T Type
MESSAGE_PROPERTIES_ARRAY_T Type
MSGID_ARRAY_T Type
186
Database URI TYPEs
Summary of URITYPE Supertype Subprograms
GETBLOB
GETCLOB
GETCONTENTTYPE
GETEXTERNALURL
GETURL
GETXML
Summary of HTTPURITYPE Subtype Subprograms
CREATEURI
GETBLOB
GETCLOB
GETCONTENTTYPE
GETEXTERNALURL
GETURL
GETXML
HTTPURITYPE
Summary of DBURITYPE Subtype Subprogams
CREATEURI
DBURITYPE
GETBLOB
GETCLOB
GETCONTENTTYPE
GETEXTERNALURL
GETURL
GETXML
Summary of XDBURITYPE Subtype Subprograms
CREATEURI
GETBLOB
GETCLOB
GETCONTENTTYPE
GETEXTERNALURL
GETURL
GETXML
XDBURITYPE
Summary of URIFACTORY Package Subprograms
GETURI
ESCAPEURI
UNESCAPEURI
REGISTERURLHANDLER
UNREGISTERURLHANDLER
187
Expression Filter Types
Summary of Expression FilterTypes
EXF$ATTRIBUTE
EXF$ATTRIBUTE_LIST
EXF$INDEXOPER
EXF$TABLE_ALIAS
EXF$XPATH_TAG
EXF$XPATH_TAGS
188
JMS Types
Using JMS Types
Overview
Java Versus PL/SQL Data Types
New JMS Support in Oracle Database 10
g
More on Bytes, Stream and Map Messages
Using Java Stored Procedures to Encode and Decode Oracle Streams AQ Messages
Initialize the Jserv Static Variable
Get the Payload Data Back to PL/SQL
Garbage Collect the Static Variable
Use a Message Store: A Static Variable Collection
Typical Calling Sequences
Read-Only and Write-Only Modes Enforced for Stream and Bytes Messages
Differences Between Bytes and Stream Messages
Getting and Setting Bytes, Map, and Stream Messages as RAW Bytes
Upcasting and Downcasting Between General and Specific Messages
JMS Types Error Reporting
Oracle JMS Type Constants
CONVERT_JMS_SELECTOR
Convert with Minimal Specification
Convert with Destination Payload Type Specified
Convert with Destination Payload Type and Compliant Mode Specified
Summary of JMS Types
SYS.AQ$_JMS_MESSAGE Type
CONSTRUCT Static Functions
Cast Methods
JMS Header Methods
System Properties Methods
User Properties Methods
Payload Methods
SYS.AQ$_JMS_TEXT_MESSAGE Type
CONSTRUCT Function
JMS Header Methods
System Properties Methods
User Properties Methods
Payload Methods
SYS.AQ$_JMS_BYTES_MESSAGE Type
CONSTRUCT Function
JMS Header Methods
System Properties Methods
User Properties Methods
Payload Methods
SYS.AQ$_JMS_MAP_MESSAGE Type
CONSTRUCT Function
JMS Header Methods
System Properties Methods
User Properties Methods
Payload Methods
SYS.AQ$_JMS_STREAM_MESSAGE Type
CONSTRUCT Function
JMS Header Methods
System Properties Methods
User Properties Methods
Payload Methods
SYS.AQ$_JMS_OBJECT_MESSAGE Type
SYS.AQ$_JMS_NAMESARRAY Type
SYS.AQ$_JMS_VALUE Type
SYS.AQ$_JMS_EXCEPTION Type
189
Logical Change Record TYPEs
Summary of Logical Change Record Types
LCR$_DDL_RECORD Type
LCR$_DDL_RECORD Constructor
Summary of LCR$_DDL_RECORD Subprograms
LCR$_ROW_RECORD Type
LCR$_ROW_RECORD Constructor
Summary of LCR$_ROW_RECORD Subprograms
Common Subprograms for LCR$_DDL_RECORD and LCR$_ROW_RECORD
LCR$_ROW_LIST Type
LCR$_ROW_UNIT Type
190
inter
Media ORDAudio TYPE
Documentation of ORDAudio
191
inter
Media ORDDoc TYPE
Documentation of ORDDoc
192
inter
Media ORDImage TYPE
Documentation of ORDImage
193
inter
Media ORDImageSignature TYPE
Documentation of ORDImageSignature
194
inter
Media SQL/MM Still Image TYPE
Documentation of SQL/MM Still Image
195
inter
Media ORDVideo TYPE
Documentation of ORDVideo
196
Rules Manager Types
Summary of Rule Manager Types
RLM$EVENTIDS Object Type
197
Rule TYPEs
Summary of Rule Types
RE$ATTRIBUTE_VALUE Type
RE$ATTRIBUTE_VALUE_LIST Type
RE$COLUMN_VALUE Type
RE$COLUMN_VALUE_LIST Type
RE$NAME_ARRAY Type
RE$NV_ARRAY Type
Syntax
RE$NV_LIST Type
RE$NV_NODE Type
RE$RULE_HIT Type
RE$RULE_HIT_LIST Type
RE$TABLE_ALIAS Type
RE$TABLE_ALIAS_LIST Type
RE$TABLE_VALUE Type
RE$TABLE_VALUE_LIST Type
RE$VARIABLE_TYPE Type
RE$VARIABLE_TYPE_LIST Type
RE$VARIABLE_VALUE Type
RE$VARIABLE_VALUE_LIST Type
198
XMLTYPE
Summary of XMLType Subprograms
CREATENONSCHEMABASEDXML
CREATESCHEMABASEDXML
CREATEXML
EXISTSNODE
EXTRACT
GETBLOBVAL
GETCLOBVAL
GETNAMESPACE
GETNUMBERVAL
GETROOTELEMENT
GETSCHEMAURL
GETSTRINGVAL
ISFRAGMENT
ISSCHEMABASED
ISSCHEMAVALID
ISSCHEMAVALIDATED
SCHEMAVALIDATE
SETSCHEMAVALIDATED
TOOBJECT
TRANSFORM
XMLTYPE
Index
Scripting on this page enhances content navigation, but does not change the content in any way.