Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
10g Release 2 (10.2)

Part Number B14258-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

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 10g Release 1 (10.1) New Features

1 Introduction

Package Overview
Package Components
Using Oracle Supplied Packages
Creating New Packages
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
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
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

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
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
New Functionality
Model Names
Constants
Data Types
Exceptions
User Views
Summary of DBMS_DATA_MINING Subprograms
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_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
RENAME_MODEL Procedure

26 DBMS_DATA_MINING_TRANSFORM

Using DBMS_DATA_MINING_TRANSFORM
Overview
Types
Transformation Methods
Steps in Defining a Transformation
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
Constants
Data Structures
Data Structures - Object 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
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

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

46 DBMS_IOT

Summary of DBMS_IOT Subprograms
BUILD_CHAIN_ROWS_TABLE Procedure
BUILD_EXCEPTIONS_TABLE Procedure

47 DBMS_JAVA

Documentation of DBMS_JAVA

48 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

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

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
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
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
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
Exceptions
Operational Notes
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
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
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_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
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
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
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_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

119 DBMS_WM

Documentation of DBMS_WM

120 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

121 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

122 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

123 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

124 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

125 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

126 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

127 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

128 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

129 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

130 DBMS_XMLSTORE

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

131 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

132 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

133 DEBUG_EXTPROC

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

134 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

135 HTMLDB_CUSTOM_AUTH

Documentation of HTMLDB_CUSTOM_AUTH

136 HTMLDB_APPLICATION

Documentation of HTMLDB_APPLICATION

137 HTMLDB_ITEM

Documentation of HTMLDB_ITEM

138 HTMLDB_UTIL

Documentation of HTMLDB_UTIL

139 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

140 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

141 OWA_COOKIE

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

142 OWA_CUSTOM

Using OWA_CUSTOM
Constants
Summary of OWA_CUSTOM Subprograms
AUTHORIZE Function

143 OWA_IMAGE

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

144 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

145 OWA_PATTERN

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

146 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

147 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

148 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

149 SDO_CS

Documentation of SDO_CS

150 SDO_GCDR

Documentation of SDO_GCDR

151 SDO_GEOM

Documentation of SDO_GEOM

152 SDO_GEOR

Documentation of SDO_GEOR

153 SDO_GEOR_UTL

Documentation of SDO_GEOR_UTL

154 SDO_LRS

Documentation of SDO_LRS

155 SDO_MIGRATE

Documentation of SDO_MIGRATE

156 SDO_NET

Documentation of SDO_NET

157 SDO_NET_MEM

Documentation of SDO_NET_MEM

158 SDO_SAM

Documentation of SDO_SAM

159 SDO_TOPO

Documentation of SDO_TOPO

160 SDO_TOPO_MAP

Documentation of SDO_TOPO_MAP

161 SDO_TUNE

Documentation of SDO_TUNE

162 SDO_UTIL

Documentation of SDO_UTIL

163 UTL_COLL

Summary of UTL_COLL Subprograms
IS_LOCATOR Function

164 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

165 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

166 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

167 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

168 UTL_HTTP

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

169 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

170 UTL_INADDR

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

171 UTL_LMS

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

172 UTL_MAIL

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

173 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

174 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

175 UTL_RECOMP

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

176 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

177 UTL_SMTP

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

178 UTL_TCP

Using UTL_TCP
Overview
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_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

179 UTL_URL

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

180 WPG_DOCLOAD

Using WPG_DOCLOAD
Constants
Summary of WPG_DOCLOAD Subprograms
DOWNLOAD_FILE Procedures

181 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

182 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

183 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

184 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

185 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

186 Expression Filter Types

Summary of Expression FilterTypes
EXF$ATTRIBUTE
EXF$ATTRIBUTE_LIST
EXF$INDEXOPER
EXF$TABLE_ALIAS
EXF$XPATH_TAG
EXF$XPATH_TAGS

187 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

188 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

189 interMedia ORDAudio TYPE

Documentation of ORDAudio

190 interMedia ORDDoc TYPE

Documentation of ORDDoc

191 interMedia ORDImage TYPE

Documentation of ORDImage

192 interMedia ORDImageSignature TYPE

Documentation of ORDImageSignature

193 interMedia SQL/MM Still Image TYPE

Documentation of SQL/MM Still Image

194 interMedia ORDVideo TYPE

Documentation of ORDVideo

195 Rules Manager Types

Summary of Rule Manager Types
RLM$EVENTIDS Object Type

196 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

197 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