Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 1 (11.1)

Part Number B28419-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to next page
Next
View PDF

Contents

Title and Copyright Information

Preface

Audience
Documentation Accessibility
Related Documents
Conventions

What's New in PL/SQL Packages and Types Reference?

Oracle Database 11g Release 1 (11.1)

1 Introduction to Oracle Supplied PL/SQL Packages & Types

Package Overview
Package Components
Using Oracle Supplied Packages
Creating New Packages
Referencing Package Contents
Summary of Oracle Supplied PL/SQL Packages and Types

2 APEX_CUSTOM_AUTH

Documentation of APEX_CUSTOM_AUTH

3 APEX_APPLICATION

Documentation of APEX_APPLICATION

4 APEX_ITEM

Documentation of APEX_ITEM

5 APEX_UTIL

Documentation of APEX_UTIL

6 CTX_ADM

Documentation of CTX_ADM

7 CTX_CLS

Documentation of CTX_CLS

8 CTX_DDL

Documentation of CTX_DDL

9 CTX_DOC

Documentation of CTX_DOC

10 CTX_OUTPUT

Documentation of CTX_OUTPUT

11 CTX_QUERY

Documentation of CTX_QUERY

12 CTX_REPORT

Documentation of CTX_REPORT

13 CTX_THES

Documentation of CTX_THES

14 CTX_ULEXER

Documentation of CTX_ULEXER

15 DBMS_ADDM

Using DBMS_ADDM
Security Model
Summary of DBMS_ADDM Subprograms
ANALYZE_DB Procedure
ANALYZE_INST Procedure
ANALYZE_PARTIAL Procedure
DELETE Procedure
DELETE_FINDING_DIRECTIVE Procedure
DELETE_PARAMETER_DIRECTIVE Procedure
DELETE_SEGMENT_DIRECTIVE Procedure
DELETE_SQL_DIRECTIVE Procedure
GET_REPORT Function
INSERT_FINDING_DIRECTIVE Procedure
INSERT_PARAMETER_DIRECTIVE Procedure
INSERT_SEGMENT_DIRECTIVE Procedure
INSERT_SQL_DIRECTIVE Procedure

16 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

17 DBMS_ADVISOR

Using DBMS_ADVISOR
Security Model
Summary of DBMS_ADVISOR Subprograms
ADD_SQLWKLD_REF Procedure
ADD_SQLWKLD_STATEMENT Procedure
ADD_STS_REF Procedure
CANCEL_TASK Procedure
COPY_SQLWKLD_TO_STS Procedure
CREATE_FILE Procedure
CREATE_OBJECT Procedure
CREATE_SQLWKLD Procedure
CREATE_TASK Procedures
DELETE_SQLWKLD Procedure
DELETE_SQLWKLD_REF Procedure
DELETE_SQLWKLD_STATEMENT Procedures
DELETE_STS_REF 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 Procedures
SET_DEFAULT_TASK_PARAMETER Procedures
SET_SQLWKLD_PARAMETER Procedures
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

18 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

19 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

20 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 Procedure
EXECUTE_ALL_ERRORS Procedure
EXECUTE_ERROR Procedure
GET_ERROR_MESSAGE Function
SET_DML_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

21 DBMS_AQ

Using DBMS_AQ
Constants
Data Structures
Operational Notes
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

22 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

23 DBMS_AQELM

Summary of DBMS_AQELM Subprograms
SET_MAILHOST Procedure
SET_MAILPORT Procedure
SET_SENDFROM Procedure

24 DBMS_AQIN

Using DBMS_AQIN
Overview

25 DBMS_ASSERT

Using DBMS_ASSERT
Operational Notes
Summary of DBMS_ASSERT Subprograms
ENQUOTE_LITERAL Function
ENQUOTE_NAME Function
NOOP Functions
QUALIFIED_SQL_NAME Function
SCHEMA_NAME Function
SIMPLE_SQL_NAME Function
SQL_OBJECT_NAME Function

26 DBMS_AUTO_TASK_ADMIN

Using DBMS_AUTO_TASK_ADMIN
Constants
Summary of DBMS_AUTO_TASK_ADMIN Subprograms
DISABLE Procedures
ENABLE Procedures
GET_CLIENT_ATTRIBUTES Procedure
GET_P1_RESOURCES Procedure
OVERRIDE_PRIORITY Procedures
SET_CLIENT_SERVICE Procedure
SET_P1_RESOURCES Procedure

27 DBMS_AW_STATS

Using DBMS_AW_STATS
Summary of DBMS_AW_STATS Subprograms
ANALYZE Procedure

28 DBMS_CAPTURE_ADM

Summary of DBMS_CAPTURE_ADM Subprograms
ABORT_GLOBAL_INSTANTIATION Procedure
ABORT_SCHEMA_INSTANTIATION Procedure
ABORT_SYNC_INSTANTIATION Procedure
ABORT_TABLE_INSTANTIATION Procedure
ALTER_CAPTURE Procedure
ALTER_SYNC_CAPTURE Procedure
BUILD Procedure
CREATE_CAPTURE Procedure
CREATE_SYNC_CAPTURE Procedure
DROP_CAPTURE Procedure
INCLUDE_EXTRA_ATTRIBUTE Procedure
PREPARE_GLOBAL_INSTANTIATION Procedure
PREPARE_SCHEMA_INSTANTIATION Procedure
PREPARE_SYNC_INSTANTIATION Function
PREPARE_TABLE_INSTANTIATION Procedure
SET_PARAMETER Procedure
START_CAPTURE Procedure
STOP_CAPTURE Procedure

29 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
GET_DDLOPER Function
PURGE Procedure
PURGE_CHANGE_SET Procedure
PURGE_CHANGE_TABLE Procedure

30 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

31 DBMS_COMPARISON

Using DBMS_COMPARISON
Overview
Security Model
Constants
Views
Operational Notes
Data Structures
COMPARISON_TYPE Record Type
Summary of DBMS_COMPARISON Subprograms
COMPARE Function
CONVERGE Procedure
CREATE_COMPARISON Procedure
DROP_COMPARISON Procedure
PURGE_COMPARISON Procedure
RECHECK Function

32 DBMS_CONNECTION_POOL

Summary of DBMS_CONNECTION_POOL Subprograms
ALTER_PARAM Procedure
CONFIGURE_POOL Procedure
START_POOL Procedure
STOP_POOL Procedure
RESTORE_DEFAULTS Procedure

33 DBMS_CQ_NOTIFICATION

Using DBMS_CQ_NOTIFICATION
Overview
Security Model
Constants
Operational Notes
Examples
Data Structures
CQ_NOTIFICATION$_DESCRIPTOR Object Type
CQ_NOTIFICATION$_QUERY Object Type
CQ_NOTIFICATION$_QUERY_ARRAY Object (Array) Type
CQ_NOTIFICATION$_TABLE Object Type
CQ_NOTIFICATION$_TABLE_ARRAY Object (Array) Type
CQ_NOTIFICATION$_ROW Object Type
CQ_NOTIFICATION$_ROW_ARRAY Object (Array) Type
CQ_NOTIFICATION$_REG_INFO Object Type
Summary of DBMS_CQ_NOTIFICATION Subprograms
CQ_NOTIFICATION_QUERYID Function
DEREGISTER Procedure
ENABLE_REG Procedure
NEW_REG_START Function
REG_END Procedure

34 DBMS_CRYPTO

Using the DBMS_CRYPTO Subprograms
Overview
Security Model
Types
Algorithms
Restrictions
Exceptions
Operational Notes
Examples
Summary of DBMS_CRYPTO Subprograms
DECRYPT Function
DECRYPT Procedures
ENCRYPT Function
ENCRYPT Procedures
HASH Function
MAC Function
RANDOMBYTES Function
RANDOMINTEGER Function
RANDOMNUMBER Function

35 DBMS_CSX_ADMIN

Using DBMS_CSX_ADMIN
Overview
Constants
Examples
Summary of DBMS_CSX_ADMIN
COPYDEFAULTTOKENTABLESET Procedure
GETTOKENTABLEINFO Procedure & Function
GETTOKENTABLEINFOBYTABLESPACE Procedure
NAMESPACEIDTABLE Function
PATHIDTABLE Function
QNAMEIDTABLE Function
REGISTERTOKENTABLESET Procedure

36 DBMS_CUBE

Using DBMS_CUBE
Summary of DBMS_CUBE Subprograms
BUILD Procedure
IMPORT_XML Procedure
VALIDATE_XML Procedure

37 DBMS_CUBE_ADVISE

Summary of DBMS_CUBE_ADVISE Subprograms
MV_CUBE_ADVICE Function
SET_CNS_EXCEPTION_LOG Procedure
TRACE Procedure

38 DBMS_DATA_MINING

Using DBMS_DATA_MINING
Overview
Mining Model Objects
Deprecated Subprograms
Mining Function Constants
Settings Table
Data Types
Summary of DBMS_DATA_MINING Subprograms
ADD_COST_MATRIX Procedure
ALTER_REVERSE_EXPRESSION Procedure
APPLY Procedure
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_COST_MATRIX Function
GET_MODEL_DETAILS_ABN Function
GET_MODEL_DETAILS_AI Function
GET_MODEL_DETAILS_GLM Function
GET_MODEL_DETAILS_GLOBAL 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
GET_MODEL_TRANSFORMATIONS Function
GET_TRANSFORM_LIST Procedure
IMPORT_MODEL Procedure
RANK_APPLY Procedure
REMOVE_COST_MATRIX Procedure
RENAME_MODEL Procedure

39 DBMS_DATA_MINING_TRANSFORM

Using DBMS_DATA_MINING_TRANSFORM
Data Transformation with Oracle Data Mining
Types of Transformations
The DBMS_DATA_MINING_TRANSFORM Framework
Data Types
Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
CREATE_BIN_CAT Procedure
CREATE_BIN_NUM Procedure
CREATE_CLIP Procedure
CREATE_COL_REM Procedure
CREATE_MISS_CAT Procedure
CREATE_MISS_NUM Procedure
CREATE_NORM_LIN Procedure
DESCRIBE_STACK Procedure
GET_EXPRESSION Function
INSERT_AUTOBIN_NUM_EQWIDTH Procedure
INSERT_BIN_CAT_FREQ Procedure
INSERT_BIN_NUM_EQWIDTH Procedure
INSERT_BIN_NUM_QTILE Procedure
INSERT_BIN_SUPER 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
SET_EXPRESSION Procedure
SET_TRANSFORM Procedure
STACK_BIN_CAT Procedure
STACK_BIN_NUM Procedure
STACK_CLIP Procedure
STACK_COL_REM Procedure
STACK_MISS_CAT Procedure
STACK_MISS_NUM Procedure
STACK_NORM_LIN Procedure
XFORM_BIN_CAT Procedure
XFORM_BIN_NUM Procedure
XFORM_CLIP Procedure
XFORM_COL_REM Procedure
XFORM_EXPR_NUM Procedure
XFORM_EXPR_STR Procedure
XFORM_MISS_CAT Procedure
XFORM_MISS_NUM Procedure
XFORM_NORM_LIN Procedure
XFORM_STACK Procedure

40 DBMS_DATAPUMP

Using DBMS_DATAPUMP
Overview
Security Model
Constants
Data Structures
Data Structures - Object Types
Summary of DBMS_DATAPUMP Subprograms
ADD_FILE Procedure
ATTACH Function
DATA_FILTER Procedures
DATA_REMAP Procedure
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

41 DBMS_DB_VERSION

Using DBMS_DB_VERSION
Overview
Constants
Examples

42 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

43 DBMS_DEBUG

Using DBMS_DEBUG
Overview
Constants
Variables
Exceptions
Operational Notes
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
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

44 DBMS_DEFER

Documentation of DBMS_DEFER

45 DBMS_DEFER_QUERY

Documentation of DBMS_DEFER_QUERY

46 DBMS_DEFER_SYS

Documentation of DBMS_DEFER_SYS

47 DBMS_DESCRIBE

Using DBMS_DESCRIBE
Overview
Security Model
Types
Exceptions
Examples
Summary of DBMS_DESCRIBE Subprograms
DESCRIBE_PROCEDURE Procedure

48 DBMS_DG

Using DBMS_DG
Summary of the DBMS_DG Subprogram
INITIATE_FS_FAILOVER Procedure

49 DBMS_DIMENSION

Using DBMS_DIMENSION
Security Model
Summary of DBMS_DIMENSION Subprograms
DESCRIBE_DIMENSION Procedure
VALIDATE_DIMENSION Procedure

50 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

51 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

52 DBMS_ERRLOG

Using DBMS_ERRLOG
Security Model
Summary of DBMS_ERRLOG Subprograms
CREATE_ERROR_LOG Procedure

53 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
SYNC_TEXT_INDEXES Procedure
UNASSIGN_ATTRIBUTE_SET Procedure
VALIDATE_EXPRESSIONS Procedure
XPINDEX_PARAMETERS Procedure

54 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

55 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

56 DBMS_FILE_TRANSFER

Using DBMS_FILE_TRANSFER
Operating Notes
Summary of DBMS_FILE_TRANSFER Subprograms
COPY_FILE Procedure
GET_FILE Procedure
PUT_FILE Procedure

57 DBMS_FLASHBACK

Using DBMS_FLASHBACK
Overview
Security Model
Types
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
TRANSACTION_BACKOUT Procedures

58 DBMS_FREQUENT_ITEMSET

Summary of DBMS_FREQUENT_ITEMSET Subprograms
FI_HORIZONTAL Function
FI_TRANSACTIONAL Function

59 DBMS_HM

Using DBMS_HM
Security Model
Summary of DBMS_HM Subprograms
GET_RUN_REPORT Function
RUN_CHECK Procedure

60 DBMS_HPROF

Summary of DBMS_HPROF Subprograms
ANALYZE Function
START_PROFILING Procedure
STOP_PROFILING Procedure

61 DBMS_HS_PARALLEL

LOAD_TABLE
Using LOAD_TABLE
CREATE_TABLE_TEMPLATE
CREATE_OR_REPLACE_VIEW
Using CREATE_OR_REPLACE_VIEW
DROP_VIEW

62 DBMS_HS_PASSTHROUGH

Summary of DBMS_HS_PASSTHROUGH Subprograms
BIND_INOUT_VARIABLE Procedure
BIND_INOUT_VARIABLE_RAW Procedure
BIND_OUT_VARIABLE Procedure
BIND_OUT_VARIABLE_RAW Procedure
BIND_VARIABLE Procedure
BIND_VARIABLE_RAW Procedure
CLOSE_CURSOR Procedure
EXECUTE_IMMEDIATE Procedure
EXECUTE_NON_QUERY Function
FETCH_ROW Function
GET_VALUE Procedure
GET_VALUE_RAW Procedure
OPEN_CURSOR Function
PARSE Procedure

63 DBMS_JAVA

Documentation of DBMS_JAVA

64 DBMS_IOT

Summary of DBMS_IOT Subprograms
BUILD_CHAIN_ROWS_TABLE Procedure
BUILD_EXCEPTIONS_TABLE Procedure

65 DBMS_JOB

Using DBMS_JOB
Security Model
Operational Notes
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

66 DBMS_LDAP

Documentation of DBMS_LDAP

67 DBMS_LDAP_UTL

Documentation of DBMS_LDAP_UTL

68 DBMS_LIBCACHE

Using DBMS_LIBCACHE
Overview
Security Model
Summary of DBMS_LIBCACHE Subprograms
COMPILE_FROM_REMOTE Procedure

69 DBMS_LOB

Using DBMS_LOB
Overview
Security Model
Constants
Datatypes
Rules and Limits
Operational Notes
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
FRAGMENT_DELETE Procedure
FRAGMENT_INSERT Procedures
FRAGMENT_MOVE Procedure
FRAGMENT_REPLACE Procedures
FREETEMPORARY Procedures
GET_STORAGE_LIMIT Function
GETCHUNKSIZE Functions
GETLENGTH Functions
GETOPTIONS Functions
INSTR Functions
ISOPEN Functions
ISTEMPORARY Functions
LOADBLOBFROMFILE Procedure
LOADCLOBFROMFILE Procedure
LOADFROMFILE Procedure
OPEN Procedures
READ Procedures
SETOPTIONS Procedures
SUBSTR Functions
TRIM Procedures
WRITE Procedures
WRITEAPPEND Procedures

70 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

71 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

72 DBMS_LOGMNR_D

Using DBMS_LOGMNR_D
Overview
Security Model
Summary of DBMS_LOGMNR_D Subprograms
BUILD Procedure
SET_TABLESPACE Procedure

73 DBMS_LOGSTDBY

Using DBMS_LOGSTDBY
Overview
Operational Notes
Summary of DBMS_LOGSTDBY Subprograms
APPLY_SET Procedure
APPLY_UNSET Procedure
BUILD Procedure
INSTANTIATE_TABLE Procedure
MAP_PRIMARY_SCN Function
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

74 DBMS_METADATA

Using DBMS_METADATA
Overview
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

75 DBMS_MGD_ID_UTL

Using DBMS_MGD_ID_UTL
Constants
Exceptions
Summary of DBMS_MGD_ID_UTL Subprograms
ADD_SCHEME Procedure
CREATE_CATEGORY Function
EPC_TO_ORACLE_SCHEME Function
GET_CATEGORY_ID Function
GET_COMPONENTS Function
GET_ENCODINGS Function
GET_JAVA_LOGGING_LEVEL Function
GET_PLSQL_LOGGING_LEVEL Function
GET_SCHEME_NAMES Function
GET_TDT_XML Function
GET_VALIDATOR Function
REFRESH_CATEGORY Function
REMOVE_CATEGORY Procedure
REMOVE_PROXY Procedure
REMOVE_SCHEME Procedure
SET_JAVA_LOGGING_LEVEL Procedure
SET_PLSQL_LOGGING_LEVEL Procedure
SET_PROXY Procedure
VALIDATE_SCHEME Function

76 DBMS_MGWADM

Using DBMS_MGWADM
Deprecated Subprograms
Constants
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 Procedures
ALTER_JOB Procedure
ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous
ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ
ALTER_PROPAGATION_SCHEDULE Procedure
ALTER_SUBSCRIBER Procedure
CLEANUP_GATEWAY Procedures
CREATE_AGENT Procedure
CREATE_JOB Procedure
CREATE_MSGSYSTEM_LINK Procedures for TIB/Rendezvous
CREATE_MSGSYSTEM_LINK Procedures for WebSphere MQ
DB_CONNECT_INFO Procedure
DISABLE_JOB Procedure
DISABLE_PROPAGATION_SCHEDULE Procedure
ENABLE_JOB Procedure
ENABLE_PROPAGATION_SCHEDULE Procedure
REGISTER_FOREIGN_QUEUE Procedure
REMOVE_AGENT Procedure
REMOVE_JOB Procedure
REMOVE_MSGSYSTEM_LINK Procedure
REMOVE_OPTION Procedure
REMOVE_SUBSCRIBER Procedure
RESET_JOB Procedure
RESET_SUBSCRIBER Procedure
SCHEDULE_PROPAGATION Procedure
SET_LOG_LEVEL Procedures
SET_OPTION Procedure
SHUTDOWN Procedures
STARTUP Procedures
UNREGISTER_FOREIGN_QUEUE Procedure
UNSCHEDULE_PROPAGATION Procedure

77 DBMS_MGWMSG

Using DBMS_MGWMSG
Security Model
Constants
Types
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

78 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

79 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

80 DBMS_NETWORK_ACL_ADMIN

Using DBMS_NETWORK_ACL_ADMIN
Examples
Summary of DBMS_NETWORK_ACL_ADMIN Subprograms
ADD_PRIVILEGE Procedure
ASSIGN_ACL Procedure
CHECK_PRIVILEGE Function
CHECK_PRIVILEGE_ACLID Function
CREATE_ACL Procedure
DELETE_PRIVILEGE Procedure
DROP_ACL Procedure
UNASSIGN_ACL Procedure

81 DBMS_NETWORK_ACL_UTILITY

Using DBMS_NETWORK_ACL_UTILITY
Examples
Summary of DBMS_NETWORK_ACL_UTILITY Subprograms
DOMAIN_LEVEL Function
DOMAINS Function

82 DBMS_OBFUSCATION_TOOLKIT

Using DBMS_OBFUSCATION_TOOLKIT
Overview
Security Model
Operational Notes
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

83 DBMS_ODCI

Summary of DBMS_ODCI Subprograms
ESTIMATE_CPU_UNITS Function

84 DBMS_OFFLINE_OG

Documentation of DBMS_OFFLINE_OG

85 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

86 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

87 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

88 DBMS_PCLXUTIL

Using DBMS_PCLXUTIL
Overview
Operational Notes
Rules and Limits
Summary of DBMS_PCLXUTIL Subprograms
BUILD_PART_INDEX Procedure

89 DBMS_PIPE

Using DBMS_PIPE
Overview
Security Model
Constants
Operational Notes
Exceptions
Examples
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

90 DBMS_PREDICTIVE_ANALYTICS

Using DBMS_PREDICTIVE_ANALYTICS
Overview
Summary of DBMS_PREDICTIVE_ANALYTICS Subprograms
EXPLAIN Procedure
PREDICT Procedure
PROFILE Procedure

91 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

92 DBMS_PROFILER

Using DBMS_PROFILER
Overview
Security Model
Operational Notes
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

93 DBMS_PROPAGATION_ADM

Summary of DBMS_PROPAGATION_ADM Subprograms
ALTER_PROPAGATION Procedure
CREATE_PROPAGATION Procedure
DROP_PROPAGATION Procedure
START_PROPAGATION Procedure
STOP_PROPAGATION Procedure

94 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

95 DBMS_RECTIFIER_DIFF

Documentation of DBMS_RECTIFIER_DIFF

96 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

97 DBMS_REFRESH

Documentation of DBMS_REFRESH

98 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

99 DBMS_REPCAT

Documentation of DBMS_REPCAT

100 DBMS_REPCAT_ADMIN

Documentation of DBMS_REPCAT_ADMIN

101 DBMS_REPCAT_INSTANTIATE

Documentation of DBMS_REPCAT_INSTANTIATE

102 DBMS_REPCAT_RGT

Documentation of DBMS_REPCAT_RGT

103 DBMS_REPUTIL

Documentation of DBMS_REPUTIL

104 DBMS_RESCONFIG

Using DBMS_RESCONFIG
Overview
Summary of DBMS_RESCONFIG Subprograms
ADDREPOSITORYRESCONFIG Procedure
ADDRESCONFIG Procedure
APPENDRESCONFIG Procedure
DELETEREPOSITORYRESCONFIG Procedure
DELETERESCONFIG Procedures
GETLISTENERS Function
GETREPOSITORYRESCONFIG Function
GETREPOSITORYRESCONFIGPATHS Function
GETRESCONFIG Function
GETRESCONFIGPATHS Function

105 DBMS_RESOURCE_MANAGER

Using DBMS_RESOURCE_MANAGER
Deprecated Subprograms
Security Model
Constants
Summary of DBMS_RESOURCE_MANAGER Subprograms
CALIBRATE_IO Procedure
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

106 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

107 DBMS_RESULT_CACHE

Using DBMS_RESULT_CACHE
Constants
Summary of DBMS_RESULT_CACHE Subprograms
BYPASS Procedure
FLUSH Function & Procedure
INVALIDATE Functions & Procedures
INVALIDATE_OBJECT Functions & Procedures
MEMORY_REPORT Procedure
STATUS Function

108 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

109 DBMS_RLMGR

Summary of Rules Manager Subprograms
ADD_ELEMENTARY_ATTRIBUTE Procedures
ADD_EVENT Procedures
ADD_FUNCTIONS Procedure
ADD_RULE Procedure
CONDITION_REF Function
CONSUME_EVENT Function
CONSUME_PRIM_EVENTS Function
CREATE_CONDITIONS_TABLE Procedure
CREATE_EVENT_STRUCT Procedure
CREATE_EXPFIL_INDEXES Procedure
CREATE_INTERFACE Procedure
CREATE_RULE_CLASS Procedure
DELETE_RULE Procedure
DROP_CONDITIONS_TABLE Procedure
DROP_EVENT_STRUCT Procedure
DROP_EXPFIL_INDEXES Procedure
DROP_INTERFACE Procedure
DROP_RULE_CLASS Procedure
EXTEND_EVENT_STRUCT Procedure
GET_AGGREGATE_VALUE Function
GRANT_PRIVILEGE Procedure
PROCESS_RULES Procedure
PURGE_EVENTS Procedure
RESET_SESSION Procedure
REVOKE_PRIVILEGE Procedure
SYNC_TEXT_INDEXES Procedure

110 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

111 DBMS_ROWID

Using DBMS_ROWID
Security Model
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

112 DBMS_RULE

Using DBMS_RULE
Security Model
Summary of DBMS_RULE Subprograms
CLOSE_ITERATOR Procedure
EVALUATE Procedures
GET_NEXT_HIT Function

113 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

114 DBMS_SCHEDULER

Data Structures
JOBARG Object Type
JOBARG_ARRAY Table Type
JOB Object Type
JOB_ARRAY Table Type
JOBATTR Object Type
JOBATTR_ARRAY Table Type
SCHEDULER$_STEP_TYPE Object Type
SCHEDULER$_STEP_TYPE_LIST Table Type
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_CREDENTIAL Procedure
CREATE_EVENT_SCHEDULE Procedure
CREATE_JOB Procedures
CREATE_JOB_CLASS Procedure
CREATE_JOBS 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_CREDENTIAL 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_FILE Procedure
GET_SCHEDULER_ATTRIBUTE Procedure
OPEN_WINDOW Procedure
PURGE_LOG Procedure
PUT_FILE Procedure
REMOVE_EVENT_QUEUE_SUBSCRIBER Procedure
REMOVE_WINDOW_GROUP_MEMBER Procedure
RESET_JOB_ARGUMENT_VALUE Procedures
RUN_CHAIN Procedures
RUN_JOB Procedure
SET_AGENT_REGISTRATION_PASS Procedure
SET_ATTRIBUTE Procedure
SET_ATTRIBUTE_NULL Procedure
SET_JOB_ANYDATA_VALUE Procedures
SET_JOB_ARGUMENT_VALUE Procedures
SET_JOB_ATTRIBUTES Procedure
SET_SCHEDULER_ATTRIBUTE Procedure
STOP_JOB Procedure

115 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

116 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

117 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

118 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

119 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 Procedures
UNUSED_SPACE Procedure

120 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

121 DBMS_SPM

Using DBMS_SPM
Security Model
Summary of DBMS_SPM Subprograms
ALTER_SQL_PLAN_BASELINE Function
CONFIGURE Procedure
CREATE_STGTAB_BASELINE Procedure
DROP_SQL_PLAN_BASELINE Function
EVOLVE_SQL_PLAN_BASELINE Function
LOAD_PLANS_FROM_CURSOR_CACHE Functions
LOAD_PLANS_FROM_SQLSET Function
PACK_STGTAB_BASELINE Function
UNPACK_STGTAB_BASELINE Function

122 DBMS_SQL

Using DBMS_SQL
Overview
Security Model
Constants
Exceptions
Operational Notes
Examples
Data Structures
DESC_REC Record Type
DESC_REC2 Record Type
DESC_REC3 Record Type
BFILE_TABLE Table Type
BINARY_DOUBLE_TABLE Table Type
BINARY_FLOAT_TABLE Table Type
BLOB_TABLE Table Type
CLOB_TABLE Table Type
DATE_TABLE Table Type
DESC_TAB Table Type
DESC_TAB2 Table Type
DESC_TAB3 Table Type
INTERVAL_DAY_TO_SECOND_TABLE
INTERVAL_YEAR_TO_MONTH_TABLE Table Type
NUMBER_TABLE Table Type
TIME_TABLE Table Type
TIME_WITH_TIME_ZONE_TABLE Table Type
TIMESTAMP_TABLE Table Type
TIMESTAMP_WITH_LTZ_TABLE Table Type
TIMESTAMP_WITH_TIME_ZONE_TABLE Table Type
UROWID_TABLE Table Type
VARCHAR2_TABLE Table Type
VARCHAR2A Table Type
VARCHAR2S Table Type
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
DESCRIBE_COLUMNS3 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 Procedures
TO_CURSOR_NUMBER Function
TO_REFCURSOR Function
VARIABLE_VALUE Procedures

123 DBMS_SQLDIAG

Using DBMS_SQLDIAG
Overview
Constants
Examples
Summary of DBMS_SQLDIAG Subprograms
ACCEPT_SQL_PATCH Function & Procedure
ALTER_SQL_PATCH Procedure
CANCEL_DIAGNOSIS_TASK Procedure
CREATE_DIAGNOSIS_TASK Functions
CREATE_STGTAB_SQLPATCH Procedure
DROP_DIAGNOSIS_TASK Procedure
DROP_SQL_PATCH Procedure
EXECUTE_DIAGNOSIS_TASK Procedure
EXPLAIN_SQL_TESTCASE Function
EXPORT_SQL_TESTCASE Procedures
EXPORT_SQL_TESTCASE_DIR_BY_INC Function
EXPORT_SQL_TESTCASE_DIR_BY_TXT Function
GET_SQL Function
INCIDENTID_2_SQL Procedure
INTERRUPT_DIAGNOSIS_TASK Procedure
PACK_STGTAB_SQLPATCH Procedure
REPORT_DIAGNOSIS_TASK Function
RESET_DIAGNOSIS_TASK Procedure
RESUME_DIAGNOSIS_TASK Procedure
SET_DIAGNOSIS_TASK_PARAMETER Procedure
UNPACK_STGTAB_SQLPATCH Procedure

124 DBMS_SQLPA

Using DBMS_SQLPA
Overview
Security Model
Summary of DBMS_SQLPA Subprograms
CANCEL_ANALYSIS_TASK Procedure
CREATE_ANALYSIS_TASK Functions
DROP_ANALYSIS_TASK Procedure
EXECUTE_ANALYSIS_TASK Function & Procedure
INTERRUPT_ANALYSIS_TASK Procedure
REPORT_ANALYSIS_TASK Function
RESET_ANALYSIS_TASK Procedure
RESUME_ANALYSIS_TASK Procedure
SET_ANALYSIS_TASK_PARAMETER Procedures
SET_ANALYSIS_DEFAULT_PARAMETER Procedures

125 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
Real-time SQL Monitoring 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 Function & Procedure
IMPLEMENT_TUNING_TASK Function
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_AUTO_TUNING_TASK Function
REPORT_SQL_MONITOR Function
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
SET_TUNING_TASK_PARAMETER Procedures
SQLTEXT_TO_SIGNATURE Function
UNPACK_STGTAB_SQLPROF Procedure
UNPACK_STGTAB_SQLSET Procedure
UPDATE_SQLSET Procedures

126 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

127 DBMS_STATS

Using DBMS_STATS
Overview
Types
Constants
Operational Notes
Deprecated Subprograms
Examples
Summary of DBMS_STATS Subprograms
ALTER_STATS_HISTORY_RETENTION Procedure
CONVERT_RAW_VALUE Procedures
CONVERT_RAW_VALUE_NVARCHAR Procedure
CONVERT_RAW_VALUE_ROWID Procedure
COPY_TABLE_STATS Procedure
CREATE_EXTENDED_STATS Function
CREATE_STAT_TABLE Procedure
DELETE_COLUMN_STATS Procedure
DELETE_DATABASE_PREFS Procedure
DELETE_DATABASE_STATS Procedure
DELETE_DICTIONARY_STATS Procedure
DELETE_FIXED_OBJECTS_STATS Procedure
DELETE_INDEX_STATS Procedure
DELETE_PENDING_STATS Procedure
DELETE_SCHEMA_PREFS Procedure
DELETE_SCHEMA_STATS Procedure
DELETE_SYSTEM_STATS Procedure
DELETE_TABLE_PREFS Procedure
DELETE_TABLE_STATS Procedure
DIFF_TABLE_STATS_IN_HISTORY Function
DIFF_TABLE_STATS_IN_PENDING Function
DIFF_TABLE_STATS_IN_STATTAB Function
DROP_EXTENDED_STATS Procedure
DROP_STAT_TABLE Procedure
EXPORT_COLUMN_STATS Procedure
EXPORT_DATABASE_PREFS Procedure
EXPORT_DATABASE_STATS Procedure
EXPORT_DICTIONARY_STATS Procedure
EXPORT_FIXED_OBJECTS_STATS Procedure
EXPORT_INDEX_STATS Procedure
EXPORT_PENDING_STATS Procedure
EXPORT_SCHEMA_PREFS Procedure
EXPORT_SCHEMA_STATS Procedure
EXPORT_SYSTEM_STATS Procedure
EXPORT_TABLE_PREFS 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_PREFS 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_PREFS Procedure
IMPORT_DATABASE_STATS Procedure
IMPORT_DICTIONARY_STATS Procedure
IMPORT_FIXED_OBJECTS_STATS Procedure
IMPORT_INDEX_STATS Procedure
IMPORT_SCHEMA_PREFS Procedure
IMPORT_SCHEMA_STATS Procedure
IMPORT_SYSTEM_STATS Procedure
IMPORT_TABLE_PREFS Procedure
IMPORT_TABLE_STATS Procedure
LOCK_PARTITION_STATS Procedure
LOCK_SCHEMA_STATS Procedure
LOCK_TABLE_STATS Procedure
PREPARE_COLUMN_VALUES Procedures
PREPARE_COLUMN_VALUES_NVARCHAR2 Procedure
PREPARE_COLUMN_VALUES_ROWID Procedure
PUBLISH_PENDING_STATS Procedure
PURGE_STATS Procedure
RESET_GLOBAL_PREFS_DEFAULTS 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_DATABASE_PREFS Procedure
SET_GLOBAL_PREFS Procedure
SET_INDEX_STATS Procedures
SET_PARAM Procedure
SET_SCHEMA_PREFS Procedure
SET_SYSTEM_STATS Procedure
SET_TABLE_PREFS Procedure
SET_TABLE_STATS Procedure
SHOW_EXTENDED_STATS_NAME Function
UNLOCK_PARTITION_STATS Procedure
UNLOCK_SCHEMA_STATS Procedure
UNLOCK_TABLE_STATS Procedure
UPGRADE_STAT_TABLE Procedure

128 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
LOCK_MAP Procedure
MAP_ALL Function
MAP_ELEMENT Function
MAP_FILE Function
MAP_OBJECT Function
RESTORE Function
SAVE Function
UNLOCK_MAP Procedure

129 DBMS_STREAMS

Using DBMS_STREAMS
Security Model
Summary of DBMS_STREAMS Subprograms
COMPATIBLE_11_1 Function
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

130 DBMS_STREAMS_ADM

Using DBMS_STREAMS_ADM
Overview
Deprecated Subprograms
Security Model
Operational Notes
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_MESSAGE_TRACKING Function
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
MERGE_STREAMS Procedure
MERGE_STREAMS_JOB 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_MESSAGE_TRACKING Procedure
SET_RULE_TRANSFORM_FUNCTION Procedure
SET_UP_QUEUE Procedure
SPLIT_STREAMS Procedure

131 DBMS_STREAMS_ADVISOR_ADM

Using DBMS_STREAMS_ADVISOR_ADM
Overview
Constants
Views
Operational Notes
Summary of DBMS_STREAMS_ADVISOR_ADM Subprograms
ANALYZE_CURRENT_PERFORMANCE Procedure

132 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

133 DBMS_STREAMS_MESSAGING

Summary of DBMS_STREAMS_MESSAGING Subprograms
DEQUEUE Procedure
ENQUEUE Procedure

134 DBMS_STREAMS_TABLESPACE_ADM

Using DBMS_STREAMS_TABLESPACE_ADM
Overview
Data Structures
DIRECTORY_OBJECT_SET Table Type
FILE Record Type
FILE_SET Table Type
TABLESPACE_SET Table 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

135 DBMS_TDB

Using DBMS_TDB
Overview
Security Model
Constants
Views
Operational Notes
Summary of DBMS_TDB Subprograms
CHECK_DB Function
CHECK_EXTERNAL Function

136 DBMS_TRACE

Using DBMS_TRACE
Overview
Security Model
Constants
Restrictions
Operational Notes
Summary of DBMS_TRACE Subprograms
CLEAR_PLSQL_TRACE Procedure
GET_PLSQL_TRACE_LEVEL Function
PLSQL_TRACE_VERSION Procedure
SET_PLSQL_TRACE Procedure

137 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

138 DBMS_TRANSFORM

Summary of DBMS_TRANSFORM Subprograms
CREATE_TRANSFORMATION Procedure
DROP_TRANSFORMATION Procedure
MODIFY_TRANSFORMATION Procedure

139 DBMS_TTS

Using DBMS_TTS
Security Model
Exceptions
Operational Notes
Summary of DBMS_TTS Subprograms
DOWNGRADE Procedure
TRANSPORT_SET_CHECK Procedure

140 DBMS_TYPES

Using DBMS_TYPES
Constants
Exceptions

141 DBMS_UTILITY

Using DBMS_UTILITY
Security Model
Constants
Types
Exceptions
Summary of DBMS_UTILITY Subprograms
ACTIVE_INSTANCES Procedure
ANALYZE_PART_OBJECT 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

142 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

143 DBMS_WM

Documentation of DBMS_WM

144 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

145 DBMS_WORKLOAD_REPLAY

Using DBMS_WORKLOAD_REPLAY
Security Model
Summary of DBMS_WORKLOAD_REPLAY Subprograms
CALIBRATE Function
CANCEL_REPLAY Procedure
DELETE_REPLAY_INFO Procedure
EXPORT_AWR Procedure
GET_REPLAY_INFO Function
IMPORT_AWR Function
INITIALIZE_REPLAY Procedure
PREPARE_REPLAY Procedure
PROCESS_CAPTURE Procedure
REMAP_CONNECTION Procedure
REPORT Function
START_REPLAY Procedure

146 DBMS_WORKLOAD_REPOSITORY

Using DBMS_WORKLOAD_REPOSITORY
Examples
Data Structures
AWR_BASELINE_METRIC_TYPE Object Type
AWR_BASELINE_METRIC_TYPE_TABLE Table Type
Summary of DBMS_WORKLOAD_REPOSITORY Subprograms
ADD_COLORED_SQL Procedure
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 Functions & Procedures
CREATE_BASELINE_TEMPLATE Procedures
CREATE_SNAPSHOT Function and Procedure
DROP_BASELINE Procedure
DROP_BASELINE_TEMPLATE Procedure
DROP_SNAPSHOT_RANGE Procedure
MODIFY_SNAPSHOT_SETTINGS Procedures
MODIFY_BASELINE_WINDOW_SIZE Procedure
REMOVE_COLORED_SQL Procedure
RENAME_BASELINE Procedure
SELECT_BASELINE_METRICS Function

147 DBMS_XA

Using DBMS_XA
Overview
Security Model
Constants
Operational Notes
Data Structures
DBMS_XA_XID Object Type
DBMS_XA_XID_ARRAY Table Type
Summary of DBMS_XA Subprograms
DIST_TXN_SYNC Procedure
XA_COMMIT Function
XA_END Function
XA_FORGET Function
XA_GETLASTOER Function
XA_PREPARE Function
XA_RECOVER Function
XA_ROLLBACK Function
XA_SETTIMEOUT Function
XA_START Function

148 DBMS_XDB

Using DBMS_XDB
Overview
Constants
Summary of DBMS_XDB Subprograms
ACLCHECKPRIVILEGES Function
ADDMIMEMAPPING Procedure
ADDSCHEMALOCMAPPING Procedure
ADDSERVLET Procedure
ADDSERVLETMAPPING Procedure
ADDSERVLETSECROLE Procedure
ADDXMLEXTENSION Procedure
APPENDPATH Procedure
APPENDRESOURCEMETADATA Procedure
CFG_GET Function
CFG_REFRESH Procedure
CFG_UPDATE Procedure
CHANGEOWNER Procedure
CHANGEPRIVILEGES Function
CHECKPRIVILEGES Function
COPYRESOURCE Procedure
CREATEFOLDER Function
CREATEOIDPATH Function
CREATERESOURCE Functions
DELETEMIMEMAPPING Procedure
DELETERESOURCE Procedure
DELETERESOURCEMETADATA Procedures
DELETESCHEMALOCMAPPING Procedure
DELETESERVLET Procedure
DELETESERVLETMAPPING Procedure
DELETESERVLETSECROLE Procedure
DELETEXMLEXTENSION Procedure
EXISTSRESOURCE Function
GETACLDOCUMENT Function
GETCHILDRESPATHS Function
GETCONTENTBLOB Function
GETCONTENTCLOB Function
GETCONTENTVARCHAR2 Function
GETCONTENTXMLREF Function
GETCONTENTXMLTYPE Function
GETFTPPORT Function
GETHTTPPORT Function
GETLISTENERENDPOINT Procedure
GETLOCKTOKEN Procedure
GETPRIVILEGES Function
GETRESOID Function
GETXDB_TABLESPACE Function
HASBLOBCONTENT Function
HASCHARCONTENT Function
HASXMLCONTENT Function
HASXMLREFERENCE Function
ISFOLDER Function
LINK Procedures
LOCKRESOURCE Function
MOVEXDB_TABLESPACE Procedure
PROCESSLINKS Procedure
PURGERESOURCEMETADATA Procedure
REBUILDHIERARCHICALINDEX Procedure
RENAMERESOURCE Procedure
SETACL Procedure
SETCONTENT Procedures
SETFTPPORT Procedure
SETHTTPPORT Procedure
SETLISTENERENDPOINT Procedure
SETLISTENERLOCALACCESS Procedure
SPLITPATH Procedure
TOUCHRESOURCE Procedure
UPDATERESOURCEMETADATA Procedures
UNLOCKRESOURCE Function

149 DBMS_XDB_ADMIN

Summary of DBMS_XDB_ADMIN Subprograms
CREATEREPOSITORYXMLINDEX Procedure
DROPREPOSITORYXMLINDEX Procedure
XMLINDEXADDPATH Procedure
XMLINDEXREMOVEPATH Procedure

150 DBMS_XDBRESOURCE

Using DBMS_XDBRESOURCE
Overview
Summary of DBMS_XDBRESOURCE Subprograms
FREERESOURCE Procedure
GETACL Function
GETACLDOCFROMRES Function
GETAUTHOR Function
GETCHARACTERSET Function
GETCOMMENT Function
GETCONTENTBLOB Function
GETCONTENTCLOB Function
GETCONTENTREF Function
GETCONTENTTYPE Function
GETCONTENTXML Function
GETCONTENTVARCHAR2 Function
GETCREATIONDATE Function
GETCREATOR Function
GETCUSTOMMETADATA Function
GETDISPLAYNAME Function
GETLANGUAGE Function
GETLASTMODIFIER Function
GETMODIFICATIONDATE Function
GETOWNER Function
GETREFCOUNT Function
GETVERSIONID Function
HASACLCHANGED Function
HASAUTHORCHANGED Function
HASCHANGED Function
HASCHARACTERSETCHANGED Function
HASCOMMENTCHANGED Function
HASCONTENTCHANGED Function
HASCONTENTTYPECHANGED Function
HASCREATIONDATECHANGED Function
HASCREATORCHANGED Function
HASCUSTOMMETADATACHANGED Function
HASDISPLAYNAMECHANGED Function
HASLANGUAGECHANGED Function
HASLASTMODIFIERCHANGED Function
HASMODIFICATIONDATECHANGED Function
HASOWNERCHANGED Function
HASREFCOUNTCHANGED Function
HASVERSIONIDCHANGED Function
ISFOLDER Function
ISNULL Function
MAKEDOCUMENT Function
SAVE Procedure
SETACL Procedure
SETAUTHOR Procedure
SETCHARACTERSET Procedure
SETCOMMENT Procedure
SETCONTENT Procedures
SETCONTENTTYPE Procedure
SETCUSTOMMETADATA Procedure
SETDISPLAYNAME Procedure
SETLANGUAGE Procedure
SETOWNER Procedure

151 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

152 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

153 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

154 DBMS_XEVENT

Using DBMS_XEVENT
Constants
Subprogram Groups
XDBEvent Type Subprograms
XDBRepositoryEvent Type Subprograms
XDBHandlerList Type Subprograms
XDBHandler Type Subprograms
XDBPath Type Subprograms
XDBLink Type Subprograms
Summary of DBMS_XEVENT Subprograms
CLEAR Procedure
GETAPPLICATIONDATA Function
GETCHILDOID Function
GETCURRENTUSER Function
GETEVENT Function
GETFIRST Function
GETHANDLERLIST Function
GETINTERFACE Function
GETLANGUAGE Function
GETLINK Function
GETLINKNAME Function
GETLOCK Function
GETLANGUAGE Function
GETNAME Function
GETNEXT Function
GETOLDRESOURCE Function
GETOPENACCESSMODE Function
GETOPENDENYMODE Function
GETOUTPUTSTREAM Function
GETPARAMETER Function
GETPARENT Function
GETPARENTNAME Function
GETPARENTOID Function
GETPARENTPATH Function
GETPATH Function
GETRESOURCE Function
GETSCHEMA Function
GETSOURCE Function
GETUPDATEBYTECOUNT Function
GETUPDATEBYTEOFFSET Function
GETXDBEVENT Function
ISNULL Functions
REMOVE Procedure
SETRENDERPATH Procedure
SETRENDERSTREAM Procedure

155 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
GETNODETYPE Function
GETNODENAME Function
GETNODEVALUE Function
GETNODEVALUEASBINARYSTREAM Function & Procedure
GETNODEVALUEASCHARACTERSTREAM Function & Procedure
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
SETNODEVALUEASBINARYSTREAM Function & Procedure
SETNODEVALUEASCHARACTERSTREAM Function & Procedure
SETPREFIX Procedure
SETSTANDALONE Procedure
SETVALUE Procedure
SETVERSION Procedure
SPLITTEXT Function
SUBSTRINGDATA Function
USEBINARYSTREAM Function
WRITETOBUFFER Procedures
WRITETOCLOB Procedures
WRITETOFILE Procedures

156 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

157 DBMS_XMLINDEX

Using DBMS_XMLINDEX
Overview
Summary of DBMS_XMLINDEX Subprograms
CREATEDATEINDEX Procedure
CREATENUMBERINDEX Procedure
SYNCINDEX Procedure

158 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

159 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

160 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

161 DBMS_XMLSCHEMA

Using DBMS_XMLSCHEMA
Overview
Constants
Views
Operational Notes
Summary of DBMS_XMLSCHEMA Subprograms
COMPILESCHEMA Procedure
COPYEVOLVE Procedure
DELETESCHEMA Procedure
GENERATEBEAN Procedure
GENERATESCHEMA Function
GENERATESCHEMAS Function
INPLACEEVOLVE Procedure
PURGESCHEMA Procedure
REGISTERSCHEMA Procedures
REGISTERURI Procedure

162 DBMS_XMLSTORE

Using DBMS_XMLSTORE
Types
Summary of DBMS_XMLSTORE Subprograms
CLEARKEYCOLUMNLIST
CLEARUPDATECOLUMNLIST
CLOSECONTEXT
DELETEXML
INSERTXML
NEWCONTEXT
SETKEYCOLUMN
SETROWTAG
SETUPDATECOLUMN
UPDATEXML

163 DBMS_XMLTRANSLATIONS

Summary of DBMS_XMLTRANSLATIONS Subprograms
DISABLETRANSLATION Procedure
ENABLETRANSLATION Procedure
EXTRACTXLIFF Function & Procedure
GETBASEDOCUMENT Function
MERGEXLIFF Functions
SETSOURCELANG Function
TRANSLATEXML Function
UPDATETRANSLATION Function

164 DBMS_XPLAN

Using DBMS_XPLAN
Overview
Security Model
Examples
Summary of DBMS_XPLAN Subprograms
DISPLAY Function
DISPLAY_AWR Function
DISPLAY_CURSOR Function
DISPLAY_SQL_PLAN_BASELINE Function
DISPLAY_SQLSET Function

165 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

166 DEBUG_EXTPROC

Using DEBUG_EXTPROC
Security Model
Operational Notes
Rules and Limits
Summary of DEBUG_EXTPROC Subprograms
STARTUP_EXTPROC_AGENT Procedure

167 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

168 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

169 ORD_DICOM

Documentation of ORD_DICOM

170 ORD_DICOM_ADMIN

Documentation of ORD_DICOM_ADMIN

171 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

172 OWA_COOKIE

Using OWA_COOKIE
Overview
Types
Rules and Limits
Summary of OWA_COOKIE Subprograms
GET Function
GET_ALL Procedure
REMOVE Procedure
SEND procedure

173 OWA_CUSTOM

Using OWA_CUSTOM
Constants
Summary of OWA_CUSTOM Subprograms
AUTHORIZE Function

174 OWA_IMAGE

Using OWA_IMAGE
Overview
Types
Variables
Examples
Summary of OWA_IMAGE Subprograms
GET_X Function
GET_Y Function

175 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

176 OWA_PATTERN

Using OWA_PATTERN
Types
Operational Notes
Summary of OWA_PATTERN Subprograms
AMATCH Function
CHANGE Functions and Procedures
GETPAT Procedure
MATCH Function

177 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

178 OWA_TEXT

Using OWA_TEXT
Types
Summary of OWA_TEXT Subprograms
ADD2MULTI Procedure
NEW_ROW_LIST Function and Procedure
PRINT_MULTI Procedure
PRINT_ROW_LIST Procedure
STREAM2MULTI Procedure

179 OWA_UTIL

Using OWA_UTIL
Overview
Types
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

180 SDO_CS

Documentation of SDO_CS

181 SDO_CSW_PROCESS

Documentation of SDO_CSW_PROCESS

182 SDO_GCDR

Documentation of SDO_GCDR

183 SDO_GEOM

Documentation of SDO_GEOM

184 SDO_GEOR

Documentation of SDO_GEOR

185 SDO_GEOR_ADMIN

Documentation of SDO_GEOR_ADMIN

186 SDO_GEOR_UTL

Documentation of SDO_GEOR_UTL

187 SDO_LRS

Documentation of SDO_LRS

188 SDO_MIGRATE

Documentation of SDO_MIGRATE

189 SDO_NET

Documentation of SDO_NET

190 SDO_NET_MEM

Documentation of SDO_NET_MEM

191 SDO_OLS

Documentation of SDO_OLS

192 SDO_PC_PKG

Documentation of SDO_PC_PKG

193 SDO_SAM

Documentation of SDO_SAM

194 SDO_TIN_PKG

Documentation of SDO_TIN_PKG

195 SDO_TOPO

Documentation of SDO_TOPO

196 SDO_TOPO_MAP

Documentation of SDO_TOPO_MAP

197 SDO_TUNE

Documentation of SDO_TUNE

198 SDO_UTIL

Documentation of SDO_UTIL

199 SDO_WFS_LOCK

Documentation of SDO_WFS_LOCK

200 SDO_WFS_PROCESS

Documentation of SDO_WFS_PROCESS

201 SEM_APIS

Documentation of SEM_APIS

202 SEM_PERF

Documentation of SEM_PERF

203 UTL_COLL

Summary of UTL_COLL Subprograms
IS_LOCATOR Function

204 UTL_COMPRESS

Using UTL_COMPRESS
Constants
Exceptions
Operational Notes
Summary of UTL_COMPRESS Subprograms
ISOPEN Function
LZ_COMPRESS Functions and Procedures
LZ_COMPRESS_ADD Procedure
LZ_COMPRESS_CLOSE
LZ_COMPRESS_OPEN
LZ_UNCOMPRESS Functions and Procedures
LZ_UNCOMPRESS_EXTRACT Procedure
LZ_UNCOMPRESS_OPEN Function
LZ_UNCOMPRESS_CLOSE Procedure

205 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

206 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

207 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

208 UTL_HTTP

Using UTL_HTTP
Overview
Security Model
Constants
Datatypes
Operational Notes
Exceptions
Examples
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

209 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

210 UTL_INADDR

Using UTL_INADDR
Exceptions
Examples
Summary of UTL_INADDR Subprograms
GET_HOST_ADDRESS Function
GET_HOST_NAME Function

211 UTL_LMS

Using UTL_LMS
Security Model
Summary of UTL_LMS Subprograms
FORMAT_MESSAGE Function
GET_MESSAGE Function

212 UTL_MAIL

Using UTL_MAIL
Security Model
Operational Notes
Rules and Limits
Summary of UTL_MAIL Subprograms
SEND Procedure
SEND_ATTACH_RAW Procedure
SEND_ATTACH_VARCHAR2 Procedure

213 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

214 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

215 UTL_RECOMP

Using UTL_RECOMP
Overview
Operational Notes
Examples
Summary of UTL_RECOMP Subprograms
RECOMP_PARALLEL Procedure
RECOMP_SERIAL Procedure

216 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

217 UTL_SMTP

Using UTL_SMTP
Overview
Security Model
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

218 UTL_SPADV

Summary of UTL_SPADV Subprograms
COLLECT_STATS Procedure
SHOW_STATS Procedure

219 UTL_TCP

Using UTL_TCP
Overview
Security Model
Types
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_LINE_NCHAR Function
GET_RAW Function
GET_TEXT Function
GET_TEXT_NCHAR Function
OPEN_CONNECTION Function
READ_LINE Function
READ_RAW Function
READ_TEXT Function
WRITE_LINE Function
WRITE_RAW Function
WRITE_TEXT Function

220 UTL_URL

Using UTL_URL
Overview
Exceptions
Examples
Summary of UTL_URL Subprograms
ESCAPE Function
UNESCAPE Function

221 WPG_DOCLOAD

Using WPG_DOCLOAD
Constants
Summary of WPG_DOCLOAD Subprograms
DOWNLOAD_FILE Procedures

222 ANYDATA TYPE

Using ANYDATA TYPE
Restrictions
Operational Notes
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

223 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

224 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

225 Oracle Streams AQ TYPEs

Summary of Types
AQ$_AGENT Type
AQ$_AGENT_LIST_T Type
AQ$_DESCRIPTOR Type
AQ$_NTFN_DESCRIPTOR Type
AQ$_NTFN_MSGID_ARRAY 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

226 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

227 Expression Filter Types

Summary of Expression Filter Types
EXF$ATTRIBUTE
EXF$ATTRIBUTE_LIST
EXF$INDEXOPER
EXF$TABLE_ALIAS
EXF$TEXT
EXF$XPATH_TAG
EXF$XPATH_TAGS

228 JMS Types

Using JMS Types
Overview
Java Versus PL/SQL Data Types
More on Bytes, Stream and Map Messages
Upcasting and Downcasting Between General and Specific Messages
JMS Types Error Reporting
Oracle JMS Type Constants
CONVERT_JMS_SELECTOR
Summary of JMS Types
SYS.AQ$_JMS_MESSAGE Type
SYS.AQ$_JMS_TEXT_MESSAGE Type
SYS.AQ$_JMS_BYTES_MESSAGE Type
SYS.AQ$_JMS_MAP_MESSAGE Type
SYS.AQ$_JMS_STREAM_MESSAGE Type
SYS.AQ$_JMS_OBJECT_MESSAGE Type
SYS.AQ$_JMS_NAMESARRAY Type
SYS.AQ$_JMS_VALUE Type
SYS.AQ$_JMS_EXCEPTION Type

229 Logical Change Record TYPEs

Summary of Logical Change Record Types
LCR$_DDL_RECORD Type
LCR$_ROW_RECORD Type
Common Subprograms for LCR$_DDL_RECORD and LCR$_ROW_RECORD
LCR$_ROW_LIST Type
LCR$_ROW_UNIT Type

230 Oracle Multimedia ORDAudio TYPE

Documentation of ORDAudio

231 Oracle Multimedia ORDDicom TYPE

Documentation of ORDDicom

232 Oracle Multimedia ORDDoc TYPE

Documentation of ORDDoc

233 Oracle Multimedia ORDImage TYPE

Documentation of ORDImage

234 Oracle Multimedia SQL/MM Still Image TYPE

Documentation of SQL/MM Still Image

235 Oracle Multimedia ORDVideo TYPE

Documentation of ORDVideo

236 MGD_ID Package Types

Summary of Types
MGD_ID_COMPONENT Object Type
MGD_ID_COMPONENT_VARRAY Object Type
MGD_ID Object Type
Summary of MGD_ID Subprograms
MGD_ID Constructor Function
FORMAT Function
GET_COMPONENT Function
TO_STRING Function
TRANSLATE Function

237 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
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

238 Rules Manager Types

Summary of Rule Manager Types
RLM$EVENTIDS Object Type

239 UTL Streams Types

Summary of UTL Binary Streams Types
UTL_BINARYINPUTSTREAM Type
UTL_BINARYOUTPUTSTREAM Type
UTL_CHARACTERINPUTSTREAM Type
UTL_CHARACTEROUTPUTSTREAM Type

240 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