1/206

Contents

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Documentation Accessibility
• Structure
• Related Documents
• Conventions

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

• Oracle Database 10g Release 2 (10.2) New Features
• Oracle Database 10g Release 1 (10.1) New Features

1 Introduction

• Package Overview
  • Package Components
  • Using Oracle Supplied Packages
  • Creating New Packages
    • Separating the Specification and Body
  • Referencing Package Contents
• Summary of Oracle Supplied PL/SQL Packages

2 CTX_ADM

• Documentation of CTX_ADM

3 CTX_CLS

• Documentation of CTX_CLS

4 CTX_DDL

• Documentation of CTX_DDL

5 CTX_DOC

• Documentation of CTX_DOC

6 CTX_OUTPUT

• Documentation of CTX_OUTPUT

7 CTX_QUERY

• Documentation of CTX_QUERY

8 CTX_REPORT

• Documentation of CTX_REPORT

9 CTX_THES

• Documentation of CTX_THES

10 CTX_ULEXER

• Documentation of CTX_ULEXER

11 DBMS_ADVANCED_REWRITE

• Using DBMS_ADVANCED_REWRITE
  • Security Model
• Summary of DBMS_ADVANCED_REWRITE Subprograms
  • ALTER_REWRITE_EQUIVALENCE Procedure
  • BUILD_SAFE_REWRITE_EQUIVALENCE Procedure
  • DECLARE_REWRITE_EQUIVALENCE Procedures
  • DROP_REWRITE_EQUIVALENCE Procedure
  • VALIDATE_REWRITE_EQUIVALENCE Procedure

12 DBMS_ADVISOR

• Using DBMS_ADVISOR
  • Security Model
• Summary of DBMS_ADVISOR Subprograms
  • ADD_SQLWKLD_REF Procedure
  • ADD_SQLWKLD_STATEMENT Procedure
  • CANCEL_TASK Procedure
  • CREATE_FILE Procedure
  • CREATE_OBJECT Procedure
  • CREATE_SQLWKLD Procedure
  • CREATE_TASK Procedures
  • DELETE_SQLWKLD Procedure
  • DELETE_SQLWKLD_REF Procedure
  • DELETE_SQLWKLD_STATEMENT Procedure
  • DELETE_TASK Procedure
  • EXECUTE_TASK Procedure
  • GET_REC_ATTRIBUTES Procedure
  • GET_TASK_REPORT Function
  • GET_TASK_SCRIPT Function
  • IMPLEMENT_TASK Procedure
  • IMPORT_SQLWKLD_SCHEMA Procedure
  • IMPORT_SQLWKLD_SQLCACHE Procedure
  • IMPORT_SQLWKLD_STS Procedure
  • IMPORT_SQLWKLD_SUMADV Procedure
  • IMPORT_SQLWKLD_USER Procedure
  • INTERRUPT_TASK Procedure
  • MARK_RECOMMENDATION Procedure
  • QUICK_TUNE Procedure
  • RESET_SQLWKLD Procedure
  • RESET_TASK Procedure
  • SET_DEFAULT_SQLWKLD_PARAMETER Procedure
  • SET_DEFAULT_TASK_PARAMETER Procedures
  • SET_SQLWKLD_PARAMETER Procedure
  • SET_TASK_PARAMETER Procedure
  • TUNE_MVIEW Procedure
  • UPDATE_OBJECT Procedure
  • UPDATE_REC_ATTRIBUTES Procedure
  • UPDATE_SQLWKLD_ATTRIBUTES Procedure
  • UPDATE_SQLWKLD_STATEMENT Procedure
  • UPDATE_TASK_ATTRIBUTES Procedure

13 DBMS_ALERT

• Using DBMS_ALERT
  • Overview
  • Security Model
  • Constants
  • Restrictions
  • Exceptions
  • Operational Notes
  • Examples
• Summary of DBMS_ALERT Subprograms
  • REGISTER Procedure
  • REMOVE Procedure
  • REMOVEALL Procedure
  • SET_DEFAULTS Procedure
  • SIGNAL Procedure
  • WAITANY Procedure
  • WAITONE Procedure

14 DBMS_APPLICATION_INFO

• Using DBMS_APPLICATION_INFO
  • Overview
  • Security Model
  • Operational Notes
• Summary of DBMS_APPLICATION_INFO Subprograms
  • READ_CLIENT_INFO Procedure
  • READ_MODULE Procedure
  • SET_ACTION Procedure
  • SET_CLIENT_INFO Procedure
  • SET_MODULE Procedure
  • SET_SESSION_LONGOPS Procedure

15 DBMS_APPLY_ADM

• Summary of DBMS_APPLY_ADM Subprograms
  • ALTER_APPLY Procedure
  • COMPARE_OLD_VALUES Procedure
  • CREATE_APPLY Procedure
  • CREATE_OBJECT_DEPENDENCY Procedure
  • DELETE_ALL_ERRORS Procedure
  • DELETE_ERROR Procedure
  • DROP_APPLY Procedure
  • DROP_OBJECT_DEPENDENCY
  • EXECUTE_ALL_ERRORS Procedure
  • EXECUTE_ERROR Procedure
  • GET_ERROR_MESSAGE Function
  • SET_DML_HANDLER Procedure
    • Signature of a DML Handler Procedure
    • Signature of an Error Handler Procedure
  • SET_ENQUEUE_DESTINATION Procedure
  • SET_EXECUTE Procedure
  • SET_GLOBAL_INSTANTIATION_SCN Procedure
  • SET_KEY_COLUMNS Procedures
  • SET_PARAMETER Procedure
  • SET_SCHEMA_INSTANTIATION_SCN Procedure
  • SET_TABLE_INSTANTIATION_SCN Procedure
  • SET_UPDATE_CONFLICT_HANDLER Procedure
  • SET_VALUE_DEPENDENCY Procedure
  • START_APPLY Procedure
  • STOP_APPLY Procedure

16 DBMS_AQ

• Using DBMS_AQ
  • Constants
  • Data Structures
    • Object Name
    • Type Name
    • Oracle Streams AQ PL/SQL Callback
  • Operational Notes
    • DBMS_AQ and DBMS_AQADM Java Classes
• Summary of DBMS_AQ Subprograms
  • BIND_AGENT Procedure
  • DEQUEUE Procedure
  • DEQUEUE_ARRAY Function
  • ENQUEUE Procedure
  • ENQUEUE_ARRAY Function
  • LISTEN Procedures
  • POST Procedure
  • REGISTER Procedure
  • UNBIND_AGENT Procedure
  • UNREGISTER Procedure

17 DBMS_AQADM

• Using DBMS_AQADM
  • Constants
• Subprogram Groups
  • Queue Table Subprograms
  • Privilege Subprograms
  • Queue Subprograms
  • Subscriber Subprograms
  • Notification Subprograms
  • Propagation Subprograms
  • Oracle Streams AQ Agent Subprograms
  • Alias Subprograms
• Summary of DBMS_AQADM Subprograms
  • ADD_ALIAS_TO_LDAP Procedure
  • ADD_SUBSCRIBER Procedure
  • ALTER_AQ_AGENT Procedure
  • ALTER_PROPAGATION_SCHEDULE Procedure
  • ALTER_QUEUE Procedure
  • ALTER_QUEUE_TABLE Procedure
  • ALTER_SUBSCRIBER Procedure
  • CREATE_AQ_AGENT Procedure
  • CREATE_NP_QUEUE Procedure
  • CREATE_QUEUE Procedure
  • CREATE_QUEUE_TABLE Procedure
  • DEL_ALIAS_FROM_LDAP Procedure
  • DISABLE_DB_ACCESS Procedure
  • DISABLE_PROPAGATION_SCHEDULE Procedure
  • DROP_AQ_AGENT Procedure
  • DROP_QUEUE Procedure
  • DROP_QUEUE_TABLE Procedure
  • ENABLE_DB_ACCESS Procedure
  • ENABLE_JMS_TYPES Procedure
  • ENABLE_PROPAGATION_SCHEDULE Procedure
  • GET_WATERMARK Procedure
  • GRANT_QUEUE_PRIVILEGE Procedure
  • GRANT_SYSTEM_PRIVILEGE Procedure
  • MIGRATE_QUEUE_TABLE Procedure
  • PURGE_QUEUE_TABLE Procedure
  • QUEUE_SUBSCRIBERS Function
  • REMOVE_SUBSCRIBER Procedure
  • REVOKE_QUEUE_PRIVILEGE Procedure
  • REVOKE_SYSTEM_PRIVILEGE Procedure
  • SCHEDULE_PROPAGATION Procedure
  • SET_WATERMARK Procedure
  • START_QUEUE Procedure
  • STOP_QUEUE Procedure
  • UNSCHEDULE_PROPAGATION Procedure
  • VERIFY_QUEUE_TYPES Procedure

18 DBMS_AQELM

• Summary of DBMS_AQELM Subprograms
  • SET_MAILHOST Procedure
  • SET_MAILPORT Procedure
  • SET_SENDFROM Procedure

19 DBMS_AQIN

• Using DBMS_AQIN
  • Overview

20 DBMS_CAPTURE_ADM

• Summary of DBMS_CAPTURE_ADM Subprograms
  • ABORT_GLOBAL_INSTANTIATION Procedure
  • ABORT_SCHEMA_INSTANTIATION Procedure
  • ABORT_TABLE_INSTANTIATION Procedure
  • ALTER_CAPTURE Procedure
  • BUILD Procedure
  • CREATE_CAPTURE Procedure
  • DROP_CAPTURE Procedure
  • INCLUDE_EXTRA_ATTRIBUTE Procedure
  • PREPARE_GLOBAL_INSTANTIATION Procedure
  • PREPARE_SCHEMA_INSTANTIATION Procedure
  • PREPARE_TABLE_INSTANTIATION Procedure
  • SET_PARAMETER Procedure
  • START_CAPTURE Procedure
  • STOP_CAPTURE Procedure

21 DBMS_CDC_PUBLISH

• Using DBMS_CDC_PUBLISH
  • Overview
  • Deprecated Subprograms
  • Security Model
  • Views
• Summary of DBMS_CDC_PUBLISH Subprograms
  • ALTER_AUTOLOG_CHANGE_SOURCE Procedure
  • ALTER_CHANGE_SET Procedure
  • ALTER_CHANGE_TABLE Procedure
  • ALTER_HOTLOG_CHANGE_SOURCE Procedure
  • CREATE_AUTOLOG_CHANGE_SOURCE Procedure
  • CREATE_CHANGE_SET Procedure
  • CREATE_CHANGE_TABLE Procedure
  • CREATE_HOTLOG_CHANGE_SOURCE Procedure
  • DROP_CHANGE_SET Procedure
  • DROP_CHANGE_SOURCE Procedure
  • DROP_CHANGE_TABLE Procedure
  • DROP_SUBSCRIPTION Procedure
  • PURGE Procedure
  • PURGE_CHANGE_SET Procedure
  • PURGE_CHANGE_TABLE Procedure

22 DBMS_CDC_SUBSCRIBE

• Using DBMS_CDC_SUBSCRIBE
  • Overview
  • Deprecated Subprograms
  • Security Model
  • Views
• Summary of DBMS_CDC_SUBSCRIBE Subprograms
  • ACTIVATE_SUBSCRIPTION Procedure
  • CREATE_SUBSCRIPTION Procedure
  • DROP_SUBSCRIPTION Procedure
  • EXTEND_WINDOW Procedure
  • PURGE_WINDOW Procedure
  • SUBSCRIBE Procedure

23 DBMS_CHANGE_NOTIFICATION

• Using DBMS_CHANGE_NOTIFICATION
  • Overview
  • Security Model
  • Constants
  • Operational Notes
  • Examples
• Data Structures
  • SYS.CHNF$_DESC Object Type
  • SYS.CHNF$_TDESC Object Type
  • SYS.CHNF$_TDESC_ARRAY Object (Array) Type
  • SYS.CHNF$_RDESC Object Type
  • SYS.CHNF$_RDESC_ARRAY Object (Array) Type
  • SYS.CHNF$_REG_INFO Object Type
• Summary of DBMS_CHANGE_NOTIFICATION Subprograms
  • DEREGISTER Procedure
  • ENABLE_REG Procedure
  • NEW_REG_START Function
  • REG_END Procedure

24 DBMS_CRYPTO

• Using the DBMS_CRYPTO Subprograms
  • Overview
  • Security Model
  • Types
  • Algorithms
  • Restrictions
  • Exceptions
  • Operational Notes
    • When to Use Encrypt and Decrypt Procedures or Functions
    • When to Use Hash or Message Authentication Code (MAC) Functions
    • About Generating and Storing Encryption Keys
    • Conversion Rules
  • Examples
• Summary of DBMS_CRYPTO Subprograms
  • DECRYPT Function
  • DECRYPT Procedures
  • ENCRYPT Function
  • ENCRYPT Procedures
  • HASH Function
  • MAC Function
  • RANDOMBYTES Function
  • RANDOMINTEGER Function
  • RANDOMNUMBER Function

25 DBMS_DATA_MINING

• Using DBMS_DATA_MINING
  • Overview
    • Oracle Data Mining Concepts
    • Oracle Data Mining APIs
  • New Functionality
  • Model Names
  • Constants
    • Constants that Specify the Mining Function
    • Constants that Specify Information About Mining Functions
    • Constants that Specify Information About Algorithms
  • Data Types
  • Exceptions
  • User Views
• Summary of DBMS_DATA_MINING Subprograms
  • APPLY Procedure
    • Classification Algorithms
    • One-Class SVM (Anomaly Detection)
    • Regression using SVM
    • Clustering using k-Means and O-Cluster
    • Feature Extraction using NMF
  • COMPUTE_CONFUSION_MATRIX Procedure
  • COMPUTE_LIFT Procedure
  • COMPUTE_ROC Procedure
  • CREATE_MODEL Procedure
  • DROP_MODEL Procedure
  • EXPORT_MODEL Procedure
  • GET_ASSOCIATION_RULES Function
  • GET_DEFAULT_SETTINGS Function
  • GET_FREQUENT_ITEMSETS Function
  • GET_MODEL_DETAILS_ABN Function
  • GET_MODEL_DETAILS_AI Function
  • GET_MODEL_DETAILS_KM Function
  • GET_MODEL_DETAILS_NB Function
  • GET_MODEL_DETAILS_NMF Function
  • GET_MODEL_DETAILS_OC Function
  • GET_MODEL_DETAILS_SVM Function
  • GET_MODEL_DETAILS_XML Function
  • GET_MODEL_SETTINGS Function
  • GET_MODEL_SIGNATURE Function
  • IMPORT_MODEL Procedure
  • RANK_APPLY Procedure
    • Classification Models — NB, ABN, SVM
    • Clustering using k-Means or O-Cluster
    • Feature Extraction using NMF
  • RENAME_MODEL Procedure

26 DBMS_DATA_MINING_TRANSFORM

• Using DBMS_DATA_MINING_TRANSFORM
  • Overview
  • Types
  • Transformation Methods
    • Binning
    • Normalization
    • Winsorizing and Trimming (Clipping)
    • Missing Value Treatment
  • Steps in Defining a Transformation
    • Creating a Transformation Definition Table
    • Defining a Transformation
    • Generating the Query for a Transform
  • Sample Transformation
• Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
  • CREATE_BIN_CAT Procedure
  • CREATE_BIN_NUM Procedure
  • CREATE_CLIP Procedure
  • CREATE_MISS_CAT Procedure
  • CREATE_MISS_NUM Procedure
  • CREATE_NORM_LIN Procedure
  • INSERT_AUTOBIN_NUM_EQWIDTH Procedure
  • INSERT_BIN_CAT_FREQ Procedure
  • INSERT_BIN_NUM_EQWIDTH Procedure
  • INSERT_BIN_NUM_QTILE Procedure
  • INSERT_CLIP_TRIM_TAIL Procedure
  • INSERT_CLIP_WINSOR_TAIL Procedure
  • INSERT_MISS_CAT_MODE Procedure
  • INSERT_MISS_NUM_MEAN Procedure
  • INSERT_NORM_LIN_MINMAX Procedure
  • INSERT_NORM_LIN_SCALE Procedure
  • INSERT_NORM_LIN_ZSCORE Procedure
  • XFORM_BIN_CAT Procedure
  • XFORM_BIN_NUM Procedure
  • XFORM_CLIP Procedure
  • XFORM_MISS_CAT Procedure
  • XFORM_MISS_NUM Procedure
  • XFORM_NORM_LIN Procedure

27 DBMS_DATAPUMP

• Using DBMS_DATAPUMP
  • Overview
  • Security Model
    • Roles
  • Constants
    • Mask Bit Definitions
    • Dump File Type Definitions
• Data Structures
  • Data Structures - Object Types
    • Worker Status Types
    • Log Entry and Error Types
    • Job Status Types
    • Job Description Types
    • Status Types
• Summary of DBMS_DATAPUMP Subprograms
  • ADD_FILE Procedure
  • ATTACH Function
  • DATA_FILTER Procedures
  • DETACH Procedure
  • GET_DUMPFILE_INFO Procedure
  • GET_STATUS Procedure
  • LOG_ENTRY Procedure
  • METADATA_FILTER Procedure
  • METADATA_REMAP Procedure
  • METADATA_TRANSFORM Procedure
  • OPEN Function
  • SET_PARALLEL Procedure
  • SET_PARAMETER Procedures
  • START_JOB Procedure
  • STOP_JOB Procedure
  • WAIT_FOR_JOB Procedure

28 DBMS_DB_VERSION

• Using DBMS_DB_VERSION
  • Overview
  • Constants
  • Examples

29 DBMS_DDL

• Using DBMS_DDL
  • Deprecated Subprograms
  • Security Model
  • Operational Notes
• Summary of DBMS_DDL Subprograms
  • ALTER_COMPILE Procedure
  • ALTER_TABLE_NOT_REFERENCEABLE Procedure
  • ALTER_TABLE_REFERENCEABLE Procedure
  • CREATE_WRAPPED Procedures
  • IS_TRIGGER_FIRE_ONCE Function
  • SET_TRIGGER_FIRING_PROPERTY Procedure
  • WRAP Functions

30 DBMS_DEBUG

• Using DBMS_DEBUG
  • Overview
  • Constants
  • Variables
  • Exceptions
  • Operational Notes
    • Control of the Interpreter
    • Session Termination
    • Deferred Operations
    • Diagnostic Output
    • Common and Debug Session Sections
    • OER Breakpoints
    • Namespaces
    • Libunit Types
    • Breakflags
    • Information Flags
    • Reasons for Suspension
• Data Structures
  • BREAKPOINT_INFO Record Type
  • PROGRAM_INFO Record Type
  • RUNTIME_INFO Record Type
  • BACKTRACE_TABLE Table Type
  • BREAKPOINT_TABLE Table Type
  • INDEX_TABLE Table Type
  • VC2_TABLE Table Type
• Summary of DBMS_DEBUG Subprograms
  • ATTACH_SESSION Procedure
  • CONTINUE Function
  • DEBUG_OFF Procedure
  • DEBUG_ON Procedure
  • DELETE_BREAKPOINT Function
  • DELETE_OER_BREAKPOINT Function
  • DETACH_SESSION Procedure
  • DISABLE_BREAKPOINT Function
  • ENABLE_BREAKPOINT Function
  • EXECUTE Procedure
  • GET_INDEXES Function
  • GET_MORE_SOURCE Procedure
  • GET_LINE_MAP Function
  • GET_RUNTIME_INFO Function
  • GET_TIMEOUT_BEHAVIOUR Function
  • GET_VALUE Function
  • INITIALIZE Function
  • PING Procedure
  • PRINT_BACKTRACE Procedure
    • Parameters
  • PRINT_INSTANTIATIONS Procedure
  • PROBE_VERSION Procedure
  • SELF_CHECK Procedure
  • SET_BREAKPOINT Function
  • SET_OER_BREAKPOINT Function
  • SET_TIMEOUT Function
  • SET_TIMEOUT_BEHAVIOUR Procedure
  • SET_VALUE Function
  • SHOW_BREAKPOINTS Procedures
  • SHOW_FRAME_SOURCE Procedure
  • SHOW_SOURCE Procedures
  • SYNCHRONIZE Function
  • TARGET_PROGRAM_RUNNING Procedure

31 DBMS_DEFER

• Documentation of DBMS_DEFER

32 DBMS_DEFER_QUERY

• Documentation of DBMS_DEFER_QUERY

33 DBMS_DEFER_SYS

• Documentation of DBMS_DEFER_SYS

34 DBMS_DESCRIBE

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

35 DBMS_DIMENSION

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

36 DBMS_DISTRIBUTED_TRUST_ADMIN

• Using DBMS_DISTRIBUTED_TRUST_ADMIN
  • Overview
  • Security Model
  • Examples
• Summary of DBMS_DISTRIBUTED_TRUST_ADMIN Subprograms
  • ALLOW_ALL Procedure
  • ALLOW_SERVER Procedure
  • DENY_ALL Procedure
  • DENY_SERVER Procedure

37 DBMS_EPG

• Using DBMS_EPG
  • Overview
  • Security Model
  • Exceptions
• Data Structures
• Subprogram Groups
  • Configuration Subprograms
  • Authorization Subprograms
• Summary of DBMS_EPG Subprograms
  • AUTHORIZE_DAD Procedure
  • CREATE_DAD Procedure
  • DEAUTHORIZE_DAD Procedure
  • DELETE_DAD_ATTRIBUTE Procedure
  • DELETE_GLOBAL_ATTRIBUTE Procedure
  • DROP_DAD Procedure
  • GET_ALL_DAD_ATTRIBUTES Procedure
  • GET_ALL_DAD_MAPPINGS Procedure
  • GET_ALL_GLOBAL_ATTRIBUTES Procedure
  • GET_DAD_ATTRIBUTE Function
  • GET_DAD_LIST Procedure
  • GET_GLOBAL_ATTRIBUTE Function
  • MAP_DAD Procedure
  • SET_DAD_ATTRIBUTE Procedure
  • SET_GLOBAL_ATTRIBUTE Procedure
  • UNMAP_DAD Procedure

38 DBMS_ERRLOG

• Using DBMS_ERRLOG
  • Security Model
• Summary of DBMS_ERRLOG Subprograms
  • CREATE_ERROR_LOG Procedure

39 DBMS_EXPFIL

• Summary of Expression Filter Subprograms
  • ADD_ELEMENTARY_ATTRIBUTE Procedures
  • ADD_FUNCTIONS Procedure
  • ASSIGN_ATTRIBUTE_SET Procedure
  • BUILD_EXCEPTIONS_TABLE Procedure
  • CLEAR_EXPRSET_STATS Procedure
  • COPY_ATTRIBUTE_SET Procedure
  • CREATE_ATTRIBUTE_SET Procedure
  • DEFAULT_INDEX_PARAMETERS Procedure
  • DEFAULT_XPINDEX_PARAMETERS Procedure
  • DEFRAG_INDEX Procedure
  • DROP_ATTRIBUTE_SET Procedure
  • GET_EXPRSET_STATS Procedure
  • GRANT_PRIVILEGE Procedure
  • INDEX_PARAMETERS Procedure
  • MODIFY_OPERATOR_LIST Procedure
  • REVOKE_PRIVILEGE Procedure
  • UNASSIGN_ATTRIBUTE_SET Procedure
  • VALIDATE_EXPRESSIONS Procedure
  • XPINDEX_PARAMETERS Procedure

40 DBMS_FGA

• Using DBMS_FGA
  • Security Model
  • Operational Notes
• Summary of DBMS_FGA Subprograms
  • ADD_POLICY Procedure
  • DISABLE_POLICY Procedure
  • DROP_POLICY Procedure
  • ENABLE_POLICY Procedure

41 DBMS_FILE_GROUP

• Using DBMS_FILE_GROUP
  • Overview
  • Constants
• Summary of DBMS_FILE_GROUP Subprograms
  • ADD_FILE Procedure
  • ALTER_FILE Procedure
  • ALTER_FILE_GROUP Procedure
  • ALTER_VERSION Procedure
  • CREATE_FILE_GROUP Procedure
  • CREATE_VERSION Procedure
  • DROP_FILE_GROUP Procedure
  • DROP_VERSION Procedure
  • GRANT_OBJECT_PRIVILEGE Procedure
  • GRANT_SYSTEM_PRIVILEGE Procedure
  • PURGE_FILE_GROUP Procedure
  • REMOVE_FILE Procedure
  • REVOKE_OBJECT_PRIVILEGE Procedure
  • REVOKE_SYSTEM_PRIVILEGE Procedure

42 DBMS_FILE_TRANSFER

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

43 DBMS_FLASHBACK

• Using DBMS_FLASHBACK
  • Overview
  • Security Model
  • Exceptions
  • Operational Notes
  • Examples
• Summary of DBMS_FLASHBACK Subprograms
  • DISABLE Procedure
  • ENABLE_AT_SYSTEM_CHANGE_NUMBER Procedure
  • ENABLE_AT_TIME Procedure
  • GET_SYSTEM_CHANGE_NUMBER Function
  • SCN_TO_TIMESTAMP Function
  • TIMESTAMP_TO_SCN Function

44 DBMS_FREQUENT_ITEMSET

• Summary of DBMS_FREQUENT_ITEMSET Subprograms
  • FI_HORIZONTAL Function
  • FI_TRANSACTIONAL Function

45 DBMS_HS_PASSTHROUGH

• Summary of DBMS_HS_PASSTHROUGH Subprograms
  • BIND_INOUT_VARIABLE Procedure
    • Syntax
    • Parameters
    • Exceptions
    • Pragmas
  • BIND_INOUT_VARIABLE_RAW Procedure
    • Syntax
    • Parameters
    • Exceptions
    • Pragmas
  • BIND_OUT_VARIABLE Procedure
    • Syntax
    • Parameters
    • Exceptions
    • Pragmas
  • BIND_OUT_VARIABLE_RAW Procedure
    • Syntax
    • Parameters
    • Exceptions
    • Pragmas
  • BIND_VARIABLE Procedure
    • Syntax
    • Parameters
    • Exceptions
    • Pragmas
  • BIND_VARIABLE_RAW Procedure
    • Syntax
    • Parameters
    • Exceptions
    • Pragmas
  • CLOSE_CURSOR Procedure
    • Syntax
    • Parameters
    • Exceptions
    • Pragmas
  • EXECUTE_IMMEDIATE Procedure
    • Syntax
    • Parameters
    • Return Values
    • Exceptions
  • EXECUTE_NON_QUERY Function
    • Syntax
    • Parameters
    • Return Values
    • Exceptions
  • FETCH_ROW Function
    • Syntax
    • Parameters
    • Return Values
    • Exceptions
    • Pragmas
  • GET_VALUE Procedure
    • Syntax
    • Parameters
    • Exceptions
    • Pragmas
  • GET_VALUE_RAW Procedure
    • Syntax
    • Parameters
    • Exceptions
    • Pragmas
  • OPEN_CURSOR Function
    • Syntax
    • Return Values
    • Exceptions
    • Pragmas
  • PARSE Procedure
    • Syntax
    • Parameters
    • Exceptions
    • Pragmas

46 DBMS_IOT

• Summary of DBMS_IOT Subprograms
  • BUILD_CHAIN_ROWS_TABLE Procedure
    • Syntax
    • Parameters
    • Usage Notes
    • Examples
  • BUILD_EXCEPTIONS_TABLE Procedure
    • Syntax
    • Parameters
    • Usage Notes
    • Examples

47 DBMS_JAVA

• Documentation of DBMS_JAVA

48 DBMS_JOB

• Using DBMS_JOB
  • Security Model
  • Operational Notes
    • Working with Real Application Clusters
    • Stopping a Job
• Summary of DBMS_JOB Subprograms
  • BROKEN Procedure
  • CHANGE Procedure
  • INSTANCE Procedure
  • INTERVAL Procedure
  • NEXT_DATE Procedure
  • REMOVE Procedure
  • RUN Procedure
  • SUBMIT Procedure
  • USER_EXPORT Procedures
  • WHAT Procedure

49 DBMS_LDAP

• Documentation of DBMS_LDAP

50 DBMS_LDAP_UTL

• Documentation of DBMS_LDAP_UTL

51 DBMS_LIBCACHE

• Using DBMS_LIBCACHE
  • Overview
  • Security Model
• Summary of DBMS_LIBCACHE Subprograms
  • COMPILE_FROM_REMOTE Procedure

52 DBMS_LOB

• Using DBMS_LOB
  • Overview
  • Security Model
  • Constants
  • Datatypes
  • Rules and Limits
    • General Rules and Limits
    • Rules and Limits Specific to External Files (BFILEs)
    • Maximum LOB Size
    • Maximum Buffer Size
  • Operational Notes
    • Internal LOBs
    • External LOBs
    • Temporary LOBs
  • Exceptions
• Summary of DBMS_LOB Subprograms
  • APPEND Procedures
  • CLOSE Procedure
  • COMPARE Functions
  • CONVERTTOBLOB Procedure
  • CONVERTTOCLOB Procedure
  • COPY Procedures
  • CREATETEMPORARY Procedures
  • ERASE Procedures
  • FILECLOSE Procedure
  • FILECLOSEALL Procedure
  • FILEEXISTS Function
  • FILEGETNAME Procedure
  • FILEISOPEN Function
  • FILEOPEN Procedure
  • FREETEMPORARY Procedures
  • GET_STORAGE_LIMIT
  • GETCHUNKSIZE Functions
  • GETLENGTH Functions
  • INSTR Functions
  • ISOPEN Functions
  • ISTEMPORARY Functions
  • LOADBLOBFROMFILE Procedure
  • LOADCLOBFROMFILE Procedure
  • LOADFROMFILE Procedure
  • OPEN Procedures
  • READ Procedures
  • SUBSTR Functions
  • TRIM Procedures
  • WRITE Procedures
  • WRITEAPPEND Procedures

53 DBMS_LOCK

• Using DBMS_LOCK
  • Overview
  • Security Model
  • Constants
  • Rules and Limits
  • Operational Notes
• Summary of DBMS_LOCK Subprograms
  • ALLOCATE_UNIQUE Procedure
  • CONVERT Function
  • RELEASE Function
  • REQUEST Function
  • SLEEP Procedure

54 DBMS_LOGMNR

• Using DBMS_LOGMNR
  • Overview
  • Security Model
  • Constants
  • Views
  • Operational Notes
• Summary of DBMS_LOGMNR Subprograms
  • ADD_LOGFILE Procedure
  • COLUMN_PRESENT Function
  • END_LOGMNR Procedure
  • MINE_VALUE Function
  • REMOVE_LOGFILE Procedure
  • START_LOGMNR Procedure

55 DBMS_LOGMNR_D

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

56 DBMS_LOGSTDBY

• Using DBMS_LOGSTDBY
  • Overview
  • Operational Notes
  • Deprecated Subprograms
• Summary of DBMS_LOGSTDBY Subprograms
  • APPLY_SET Procedure
  • APPLY_UNSET Procedure
  • BUILD Procedure
  • INSTANTIATE_TABLE Procedure
  • PREPARE_FOR_NEW_PRIMARY Procedure
  • PURGE_SESSION Procedure
  • REBUILD Procedure
  • SET_TABLESPACE Procedure
  • SKIP Procedure
  • SKIP_ERROR Procedure
  • SKIP_TRANSACTION Procedure
  • UNSKIP Procedure
  • UNSKIP_ERROR Procedure
  • UNSKIP_TRANSACTION Procedure

57 DBMS_METADATA

• Using DBMS_METADATA
  • Overview
    • Retrieving Metadata
    • Submitting XML
  • Security Model
  • Rules and Limits
• Data Structures - Object and Table Types
• Subprogram Groupings
  • Subprograms for Retrieving Multiple Objects From the Database
  • Subprograms for Submitting XML to the Database
• Summary of All DBMS_METADATA Subprograms
  • ADD_TRANSFORM Function
  • CLOSE Procedure
  • CONVERT Functions and Procedures
  • FETCH_xxx Functions and Procedures
  • GET_xxx Functions
  • GET_QUERY Function
  • OPEN Function
  • OPENW Function
  • PUT Function
  • SET_COUNT Procedure
  • SET_FILTER Procedure
  • SET_PARSE_ITEM Procedure
  • SET_TRANSFORM_PARAM and SET_REMAP_PARAM Procedures

58 DBMS_MGWADM

• Using DBMS_MGWADM
  • Constants
  • Views
    • MGW_GATEWAY View
    • MGW_LINKS View
    • MGW_MQSERIES_LINKS View
    • MGW_TIBRV_LINKS View
    • MGW_FOREIGN_QUEUES View
    • MGW_SUBSCRIBERS View
    • MGW_SCHEDULES View
• Data Structures
  • SYS.MGW_MQSERIES_PROPERTIES Object Type
  • SYS.MGW_PROPERTIES Object Type
  • SYS.MGW_PROPERTY Object Type
  • SYS.MGW_TIBRV_PROPERTIES Object Type
• Summary of DBMS_MGWADM Subprograms
  • ADD_SUBSCRIBER Procedure
  • ALTER_AGENT Procedure
  • ALTER_MSGSYSTEM_LINK Procedure for TIB/Rendezvous
  • ALTER_MSGSYSTEM_LINK Procedure for WebSphere MQ
  • ALTER_PROPAGATION_SCHEDULE Procedure
  • ALTER_SUBSCRIBER Procedure
  • CLEANUP_GATEWAY Procedure
  • CREATE_MSGSYSTEM_LINK Procedure for TIB/Rendezvous
  • CREATE_MSGSYSTEM_LINK Procedure for WebSphere MQ
  • DB_CONNECT_INFO Procedure
  • DISABLE_PROPAGATION_SCHEDULE Procedure
  • ENABLE_PROPAGATION_SCHEDULE Procedure
  • REGISTER_FOREIGN_QUEUE Procedure
  • REMOVE_MSGSYSTEM_LINK Procedure
  • REMOVE_SUBSCRIBER Procedure
  • RESET_SUBSCRIBER Procedure
  • SCHEDULE_PROPAGATION Procedure
  • SET_LOG_LEVEL Procedure
  • SHUTDOWN Procedure
  • STARTUP Procedure
  • UNREGISTER_FOREIGN_QUEUE Procedure
  • UNSCHEDULE_PROPAGATION Procedure

59 DBMS_MGWMSG

• Using DBMS_MGWMSG
  • Security Model
  • Constants
  • Types
    • SYS.MGW_NAME_VALUE_T Type
    • SYS.MGW_NAME_TYPE_ARRAY_T Type
    • SYS.MGW_TEXT_VALUE_T Type
    • SYS.MGW_RAW_VALUE_T Type
    • SYS.MGW_BASIC_MSG_T Type
    • SYS.MGW_NUMBER_ARRAY_T Type
    • SYS.MGW_TIBRV_FIELD_T Type
    • SYS.MGW_TIBRV_MSG_T Type
• Summary of DBMS_MGWMSG Subprograms
  • LCR_TO_XML Function
  • NVARRAY_ADD Procedure
  • NVARRAY_FIND_NAME Function
  • NVARRAY_FIND_NAME_TYPE Function
  • NVARRAY_GET Function
  • NVARRAY_GET_BOOLEAN Function
  • NVARRAY_GET_BYTE Function
  • NVARRAY_GET_DATE Function
  • NVARRAY_GET_DOUBLE Function
  • NVARRAY_GET_FLOAT Function
  • NVARRAY_GET_INTEGER Function
  • NVARRAY_GET_LONG Function
  • NVARRAY_GET_RAW Function
  • NVARRAY_GET_SHORT Function
  • NVARRAY_GET_TEXT Function
  • XML_TO_LCR Function

60 DBMS_MONITOR

• Summary of DBMS_MONITOR Subprograms
  • CLIENT_ID_STAT_DISABLE Procedure
  • CLIENT_ID_STAT_ENABLE Procedure
  • CLIENT_ID_TRACE_DISABLE Procedure
  • CLIENT_ID_TRACE_ENABLE Procedure
  • DATABASE_TRACE_DISABLE Procedure
  • DATABASE_TRACE_ENABLE Procedure
  • SERV_MOD_ACT_STAT_DISABLE Procedure
  • SERV_MOD_ACT_STAT_ENABLE Procedure
  • SERV_MOD_ACT_TRACE_DISABLE Procedure
  • SERV_MOD_ACT_TRACE_ENABLE Procedure
  • SESSION_TRACE_DISABLE Procedure
  • SESSION_TRACE_ENABLE Procedure

61 DBMS_MVIEW

• Using DBMS_MVIEW
  • Operational Notes
  • Rules and Limits
• Summary of DBMS_MVIEW Subprograms
  • BEGIN_TABLE_REORGANIZATION Procedure
  • END_TABLE_REORGANIZATION Procedure
  • ESTIMATE_MVIEW_SIZE Procedure
  • EXPLAIN_MVIEW Procedure
  • EXPLAIN_REWRITE Procedure
  • I_AM_A_REFRESH Function
  • PMARKER Function
  • PURGE_DIRECT_LOAD_LOG Procedure
  • PURGE_LOG Procedure
  • PURGE_MVIEW_FROM_LOG Procedure
  • REFRESH Procedures
  • REFRESH_ALL_MVIEWS Procedure
  • REFRESH_DEPENDENT Procedures
  • REGISTER_MVIEW Procedure
  • UNREGISTER_MVIEW Procedure

62 DBMS_OBFUSCATION_TOOLKIT

• Using DBMS_OBFUSCATION_TOOLKIT
  • Overview
  • Security Model
  • Operational Notes
    • Key Management
    • Storing the Key in the Database
    • Storing the Key in the Operating System
    • User-Supplied Keys
• Summary of DBMS_OBFUSCATION Subprograms
  • DES3DECRYPT Procedures and Functions
  • DES3ENCRYPT Procedures and Functions
  • DES3GETKEY Procedures and Functions
  • DESDECRYPT Procedures and Functions
  • DESENCRYPT Procedures and Functions
  • DESGETKEY Procedures and Functions
  • MD5 Procedures and Functions

63 DBMS_ODCI

• Summary of DBMS_ODCI Subprograms
  • ESTIMATE_CPU_UNITS Function

64 DBMS_OFFLINE_OG

• Documentation of DBMS_OFFLINE_OG

65 DBMS_OLAP

• Using DBMS_OLAP
  • Overview
  • Views
    • SYSTEM.MVIEW_EVALUATIONS
    • SYSTEM.MVIEW_EXCEPTIONS
    • SYSTEM.MVIEW_FILTER
    • SYSTEM.MVIEW_FILTERINSTANCE
    • SYSTEM.MVIEW_LOG
    • SYSTEM.MVIEW_RECOMMENDATIONS
    • SYSTEM.MVIEW_WORKLOAD
  • Deprecated Subprograms
• Summary of DBMS_OLAP Subprograms
  • ADD_FILTER_ITEM Procedure
  • CREATE_ID Procedure
  • ESTIMATE_MVIEW_SIZE Procedure
  • EVALUATE_MVIEW_STRATEGY Procedure
  • GENERATE_MVIEW_REPORT Procedure
  • GENERATE_MVIEW_SCRIPT Procedure
  • LOAD_WORKLOAD_CACHE Procedure
  • LOAD_WORKLOAD_TRACE Procedure
  • LOAD_WORKLOAD_USER Procedure
  • PURGE_FILTER Procedure
  • PURGE_RESULTS Procedure
  • PURGE_WORKLOAD Procedure
  • RECOMMEND_MVIEW_STRATEGY Procedure
  • SET_CANCELLED Procedure
  • VALIDATE_DIMENSION Procedure
  • VALIDATE_WORKLOAD_CACHE Procedure
  • VALIDATE_WORKLOAD_TRACE Procedure
  • VALIDATE_WORKLOAD_USER Procedure

66 DBMS_OUTLN

• Using DBMS_OUTLN
  • Overview
  • Security Model
• Summary of DBMS_OUTLN Subprograms
  • CLEAR_USED Procedure
  • CREATE_OUTLINE Procedure
  • DROP_BY_CAT Procedure
  • DROP_UNUSED Procedure
  • EXACT_TEXT_SIGNATURES Procedure
  • UPDATE_BY_CAT Procedure
  • UPDATE_SIGNATURES Procedure

67 DBMS_OUTLN_EDIT

• Summary of DBMS_OUTLN_EDIT Subprograms
  • CHANGE_JOIN_POS Procedure
  • CREATE_EDIT_TABLES Procedure
  • DROP_EDIT_TABLES Procedure
  • GENERATE_SIGNATURE Procedure
  • REFRESH_PRIVATE_OUTLINE Procedure

68 DBMS_OUTPUT

• Using DBMS_OUTPUT
  • Overview
  • Security Model
  • Operational Notes
  • Exceptions
  • Rules and Limits
  • Examples
• Data Structures
  • CHARARR Table Type
  • DBMSOUTPUT_LINESARRAY Object Type
• Summary of DBMS_OUTPUT Subprograms
  • DISABLE Procedure
  • ENABLE Procedure
  • GET_LINE Procedure
  • GET_LINES Procedure
  • NEW_LINE Procedure
  • PUT Procedure
  • PUT_LINE Procedure

69 DBMS_PCLXUTIL

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

70 DBMS_PIPE

• Using DBMS_PIPE
  • Overview
  • Security Model
  • Constants
  • Operational Notes
    • Public Pipes
    • Writing and Reading Pipes
    • Private Pipes
  • Exceptions
  • Examples
    • Example 1: Debugging - PL/SQL
    • Example 2: Debugging - Pro*C
    • Example 3: Execute System Commands
    • Example 4: External Service Interface
• Summary of DBMS_PIPE Subprograms
  • CREATE_PIPE Function
  • NEXT_ITEM_TYPE Function
  • PACK_MESSAGE Procedures
  • PURGE Procedure
  • RECEIVE_MESSAGE Function
  • RESET_BUFFER Procedure
  • REMOVE_PIPE Function
  • SEND_MESSAGE Function
  • UNIQUE_SESSION_NAME Function
  • UNPACK_MESSAGE Procedures

71 DBMS_PREPROCESSOR

• Using DBMS_PREPROCESSOR
  • Overview
  • Operating Notes
• Data Structures
  • SOURCE_LINES_T Table Type
• Summary of DBMS_PREPROCESSOR Subprograms
  • GET_POST_PROCESSED_SOURCE Functions
  • PRINT_POST_PROCESSED_SOURCE Procedures

72 DBMS_PREDICTIVE_ANALYTICS

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

73 DBMS_PROFILER

• Using DBMS_PROFILER
  • Overview
  • Security Model
  • Operational Notes
    • Typical Run
    • Two Methods of Exception Generation
  • Exceptions
• Summary of DBMS_PROFILER Subprograms
  • FLUSH_DATA Function and Procedure
  • GET_VERSION Procedure
  • INTERNAL_VERSION_CHECK Function
  • PAUSE_PROFILER Function and Procedure
  • RESUME_PROFILER Function and Procedure
  • START_PROFILER Functions and Procedures
  • STOP_PROFILER Function and Procedure

74 DBMS_PROPAGATION_ADM

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

75 DBMS_RANDOM

• Using DBMS_RANDOM
  • Security Model
  • Operational Notes
• Summary of DBMS_RANDOM Subprograms
  • INITIALIZE Procedure
  • NORMAL Function
  • RANDOM Procedure
  • SEED Procedures
  • STRING Function
  • TERMINATE Procedure
  • VALUE Functions

76 DBMS_RECTIFIER_DIFF

• Documentation of DBMS_RECTIFIER_DIFF

77 DBMS_REDEFINITION

• Using DBMS_REDEFINITION
  • Overview
  • Constants
  • Operational Notes
  • Rules and Limits
• Summary of DBMS_REDEFINITION Subprograms
  • ABORT_REDEF_TABLE Procedure
  • CAN_REDEF_TABLE Procedure
  • COPY_TABLE_DEPENDENTS Procedure
  • FINISH_REDEF_TABLE Procedure
  • REGISTER_DEPENDENT_OBJECT Procedure
  • START_REDEF_TABLE Procedure
  • SYNC_INTERIM_TABLE Procedure
  • UNREGISTER_DEPENDENT_OBJECT Procedure

78 DBMS_REFRESH

• Documentation of DBMS_REFRESH

79 DBMS_REPAIR

• Using DBMS_REPAIR
  • Overview
  • Security Model
  • Constants
  • Operating Notes
  • Exceptions
  • Examples
• Summary of DBMS_REPAIR Subprograms
  • ADMIN_TABLES Procedure
  • CHECK_OBJECT Procedure
  • DUMP_ORPHAN_KEYS Procedure
  • FIX_CORRUPT_BLOCKS Procedure
  • ONLINE_INDEX_CLEAN Function
  • REBUILD_FREELISTS Procedure
  • SEGMENT_FIX_STATUS Procedure
  • SKIP_CORRUPT_BLOCKS Procedure

80 DBMS_REPCAT

• Documentation of DBMS_REPCAT

81 DBMS_REPCAT_ADMIN

• Documentation of DBMS_REPCAT_ADMIN

82 DBMS_REPCAT_INSTANTIATE

• Documentation of DBMS_REPCAT_INSTANTIATE

83 DBMS_REPCAT_RGT

• Documentation of DBMS_REPCAT_RGT

84 DBMS_REPUTIL

• Documentation of DBMS_REPUTIL

85 DBMS_RESOURCE_MANAGER

• Using DBMS_RESOURCE_MANAGER
  • Security Model
  • Constants
  • Examples
• Summary of DBMS_RESOURCE_MANAGER Subprograms
  • CLEAR_PENDING_AREA Procedure
  • CREATE_CONSUMER_GROUP Procedure
  • CREATE_PENDING_AREA Procedure
  • CREATE_PLAN Procedure
  • CREATE_PLAN_DIRECTIVE Procedure
  • CREATE_SIMPLE_PLAN Procedure
  • DELETE_CONSUMER_GROUP Procedure
  • DELETE_PLAN Procedure
  • DELETE_PLAN_CASCADE Procedure
  • DELETE_PLAN_DIRECTIVE Procedure
  • SET_CONSUMER_GROUP_MAPPING Procedure
  • SET_CONSUMER_GROUP_MAPPING_PRI Procedure
  • SET_INITIAL_CONSUMER_GROUP Procedure
  • SUBMIT_PENDING_AREA Procedure
  • SWITCH_CONSUMER_GROUP_FOR_SESS Procedure
  • SWITCH_CONSUMER_GROUP_FOR_USER Procedure
  • SWITCH_PLAN Procedure
  • UPDATE_CONSUMER_GROUP Procedure
  • UPDATE_PLAN Procedure
  • UPDATE_PLAN_DIRECTIVE Procedure
  • VALIDATE_PENDING_AREA Procedure

86 DBMS_RESOURCE_MANAGER_PRIVS

• Summary of DBMS_RESOURCE_MANAGER_PRIVS Subprograms
  • GRANT_SWITCH_CONSUMER_GROUP Procedure
  • GRANT_SYSTEM_PRIVILEGE Procedure
  • REVOKE_SWITCH_CONSUMER_GROUP Procedure
  • REVOKE_SYSTEM_PRIVILEGE Procedure

87 DBMS_RESUMABLE

• Using DBMS_RESUMABLE
  • Operational Notes
• Summary of DBMS_RESUMABLE Subprograms
  • ABORT Procedure
  • GET_SESSION_TIMEOUT Function
  • GET_TIMEOUT Function
  • SET_SESSION_TIMEOUT Procedure
  • SET_TIMEOUT Procedure
  • SPACE_ERROR_INFO Function

88 DBMS_RLMGR

• Summary of Rules Manager Subprograms
  • ADD_ELEMENTARY_ATTRIBUTE Procedures
  • ADD_EVENT Procedures
  • ADD_FUNCTIONS Procedure
  • ADD_RULE Procedure
  • CONSUME_EVENT Function
  • CONSUME_PRIM_EVENTS Function
  • CREATE_EVENT_STRUCTURE Procedure
  • CREATE_RULE_CLASS Procedure
  • DELETE_RULE Procedure
  • DROP_EVENT_STRUCTURE Procedure
  • DROP_RULE_CLASS Procedure
  • GRANT_PRIVILEGE Procedure
  • PROCESS_RULES Procedure
  • RESET_SESSION Procedure
  • REVOKE_PRIVILEGE Procedure

89 DBMS_RLS

• Using DBMS_RLS
  • Overview
  • Security Model
  • Operational Notes
• Summary of DBMS_RLS Subprograms
  • ADD_GROUPED_POLICY Procedure
  • ADD_POLICY Procedure
  • ADD_POLICY_CONTEXT Procedure
  • CREATE_POLICY_GROUP Procedure
  • DELETE_POLICY_GROUP Procedure
  • DISABLE_GROUPED_POLICY Procedure
  • DROP_GROUPED_POLICY Procedure
  • DROP_POLICY Procedure
  • DROP_POLICY_CONTEXT Procedure
  • ENABLE_GROUPED_POLICY Procedure
  • ENABLE_POLICY Procedure
  • REFRESH_GROUPED_POLICY Procedure
  • REFRESH_POLICY Procedure

90 DBMS_ROWID

• Using DBMS_ROWID
  • Security Model
  • Types
    • Extension and Restriction Types
    • Verification Types
    • Object Types
    • Conversion Types
  • Exceptions
  • Operational Notes
  • Examples
• Summary of DBMS_ROWID Subprograms
  • ROWID_BLOCK_NUMBER Function
  • ROWID_CREATE Function
  • ROWID_INFO Procedure
  • ROWID_OBJECT Function
  • ROWID_RELATIVE_FNO Function
  • ROWID_ROW_NUMBER Function
  • ROWID_TO_ABSOLUTE_FNO Function
  • ROWID_TO_EXTENDED Function
  • ROWID_TO_RESTRICTED Function
  • ROWID_TYPE Function
  • ROWID_VERIFY Function

91 DBMS_RULE

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

92 DBMS_RULE_ADM

• Using DBMS_RULE_ADM
  • Security Model
• Summary of DBMS_RULE_ADM Subprograms
  • ADD_RULE Procedure
  • ALTER_EVALUATION_CONTEXT Procedure
  • ALTER_RULE Procedure
  • CREATE_EVALUATION_CONTEXT Procedure
  • CREATE_RULE Procedure
  • CREATE_RULE_SET Procedure
  • DROP_EVALUATION_CONTEXT Procedure
  • DROP_RULE Procedure
  • DROP_RULE_SET Procedure
  • GRANT_OBJECT_PRIVILEGE Procedure
  • GRANT_SYSTEM_PRIVILEGE Procedure
  • REMOVE_RULE Procedure
  • REVOKE_OBJECT_PRIVILEGE Procedure
  • REVOKE_SYSTEM_PRIVILEGE Procedure

93 DBMS_SCHEDULER

• Using DBMS_SCHEDULER
  • Rules and Limits
  • Operational Notes
• Summary of DBMS_SCHEDULER Subprograms
  • ADD_EVENT_QUEUE_SUBSCRIBER Procedure
  • ADD_WINDOW_GROUP_MEMBER Procedure
  • ALTER_CHAIN Procedure
  • ALTER_RUNNING_CHAIN Procedure
  • CLOSE_WINDOW Procedure
  • COPY_JOB Procedure
  • CREATE_CHAIN Procedure
  • CREATE_EVENT_SCHEDULE Procedure
    • Parameters
    • Usage Notes
  • CREATE_JOB Procedures
  • CREATE_JOB_CLASS Procedure
  • CREATE_PROGRAM Procedure
  • CREATE_SCHEDULE Procedure
  • CREATE_WINDOW Procedures
  • CREATE_WINDOW_GROUP Procedure
  • DEFINE_ANYDATA_ARGUMENT Procedure
  • DEFINE_CHAIN_EVENT_STEP Procedure
  • DEFINE_CHAIN_RULE Procedure
  • DEFINE_CHAIN_STEP Procedure
  • DEFINE_METADATA_ARGUMENT Procedure
  • DEFINE_PROGRAM_ARGUMENT Procedures
  • DISABLE Procedure
  • DROP_CHAIN Procedure
  • DROP_CHAIN_RULE Procedure
  • DROP_CHAIN_STEP Procedure
  • DROP_JOB Procedure
  • DROP_JOB_CLASS Procedure
  • DROP_PROGRAM Procedure
  • DROP_PROGRAM_ARGUMENT Procedures
  • DROP_SCHEDULE Procedure
  • DROP_WINDOW Procedure
  • DROP_WINDOW_GROUP Procedure
  • ENABLE Procedure
  • EVALUATE_CALENDAR_STRING Procedure
  • EVALUATE_RUNNING_CHAIN Procedure
  • GENERATE_JOB_NAME Function
  • GET_ATTRIBUTE Procedure
  • GET_SCHEDULER_ATTRIBUTE Procedure
  • OPEN_WINDOW Procedure
  • PURGE_LOG Procedure
  • REMOVE_EVENT_QUEUE_SUBSCRIBER Procedure
  • REMOVE_WINDOW_GROUP_MEMBER Procedure
  • RESET_JOB_ARGUMENT_VALUE Procedures
  • RUN_CHAIN Procedures
  • RUN_JOB Procedure
  • SET_ATTRIBUTE Procedure
  • SET_ATTRIBUTE_NULL Procedure
  • SET_JOB_ANYDATA_VALUE Procedures
  • SET_JOB_ARGUMENT_VALUE Procedures
  • SET_SCHEDULER_ATTRIBUTE Procedure
  • STOP_JOB Procedure

94 DBMS_SERVER_ALERT

• Using DBMS_SERVER_ALERT
  • Object Types
  • Relational Operators
  • Supported Metrics
• Summary of DBMS_SERVER_ALERT Subprograms
  • EXPAND_MESSAGE Function
  • GET_THRESHOLD Procedure
  • SET_THRESHOLD Procedure

95 DBMS_SERVICE

• Using DBMS_SERVICE
  • Overview
  • Security Model
  • Constants
  • Exceptions
• Summary of DBMS_SERVICE Subprograms
  • CREATE_SERVICE Procedure
  • DELETE_SERVICE Procedure
  • DISCONNECT_SESSION Procedure
  • MODIFY_SERVICE Procedure
  • START_SERVICE Procedure
  • STOP_SERVICE Procedure

96 DBMS_SESSION

• Using DBMS_SESSION
  • Security Model
  • Operational Notes
• Summary of DBMS_SESSION Subprograms
  • CLEAR_ALL_CONTEXT Procedure
  • CLEAR_CONTEXT Procedure
  • CLEAR_IDENTIFIER Procedure
  • CLOSE_DATABASE_LINK Procedure
  • FREE_UNUSED_USER_MEMORY Procedure
  • IS_ROLE_ENABLED Function
  • IS_SESSION_ALIVE Function
  • LIST_CONTEXT Procedures
  • MODIFY_PACKAGE_STATE Procedure
  • SESSION _TRACE_DISABLE Procedure
  • SESSION _TRACE_ENABLE Procedure
  • RESET_PACKAGE Procedure
  • SET_CONTEXT Procedure
  • SET_IDENTIFIER
  • SET_NLS Procedure
  • SET_ROLE Procedure
  • SET_SQL_TRACE Procedure
  • SWITCH_CURRENT_CONSUMER_GROUP Procedure
  • UNIQUE_SESSION_ID Function

97 DBMS_SHARED_POOL

• Using DBMS_SHARED_POOL
  • Overview
  • Operational Notes
• Summary of DBMS_SHARED_POOL Subprograms
  • ABORTED_REQUEST_THRESHOLD Procedure
  • KEEP Procedure
  • SIZES Procedure
  • UNKEEP Procedure

98 DBMS_SPACE

• Using DBMS_SPACE
  • Security Model
• Data Structures
  • ASA_RECO_ROW Record Type
  • ASA_RECO_ROW_TB Table Type
• Summary of DBMS_SPACE Subprograms
  • ASA_RECOMMENDATIONS Function
  • CREATE_INDEX_COST Procedure
  • CREATE_TABLE_COST Procedures
  • FREE_BLOCKS Procedure
  • OBJECT_DEPENDENT_SEGMENTS Function
  • OBJECT_GROWTH_TREND Function
  • SPACE_USAGE Procedure
  • UNUSED_SPACE Procedure

99 DBMS_SPACE_ADMIN

• Using DBMS_SPACE_ADMIN
  • Security Model
  • Constants
  • Operational Notes
• Summary of DBMS_SPACE_ADMIN Subprograms
  • ASSM_SEGMENT_VERIFY Procedure
  • ASSM_TABLESPACE_VERIFY Procedure
  • SEGMENT_CORRUPT Procedure
  • SEGMENT_DROP_CORRUPT Procedure
  • SEGMENT_DUMP Procedure
  • SEGMENT_VERIFY Procedure
  • TABLESPACE_FIX_BITMAPS Procedure
  • TABLESPACE_FIX_SEGMENT_STATES Procedure
  • TABLESPACE_MIGRATE_FROM_LOCAL Procedure
  • TABLESPACE_MIGRATE_TO_LOCAL Procedure
  • TABLESPACE_REBUILD_BITMAPS Procedure
  • TABLESPACE_REBUILD_QUOTAS Procedure
  • TABLESPACE_RELOCATE_BITMAPS Procedure
  • TABLESPACE_VERIFY Procedure

100 DBMS_SQL

• Using DBMS_SQL
  • Overview
  • Security Model
  • Constants
  • Types
    • BFILE_TABLE
    • BINARY_DOUBLE_TABLE
    • BINARY_FLOAT_TABLE
    • BLOB_TABLE
    • CLOB_TABLE
    • DATE_TABLE
    • INTERVAL_DAY_TO_SECOND_TABLE
    • INTERVAL_YEAR_TO_MONTH_TABLE
    • DESC_REC, DESC_TAB
    • NUMBER_TABLE
    • TIME_TABLE
    • TIME_WITH_TIME_ZONE_TABLE
    • TIMESTAMP_TABLE
    • TIMESTAMP_WITH_LTZ_TABLE
    • UROWID_TABLE
    • VARCHAR2_TABLE
    • VARCHAR2A, DESC_REC2
    • VARCHAR2S
  • Exceptions
  • Operational Notes
    • Execution Flow
    • Processing Queries
    • Processing Updates, Inserts, and Deletes
    • Locating Errors
  • Examples
• Summary of DBMS_SQL Subprograms
  • BIND_ARRAY Procedures
  • BIND_VARIABLE Procedures
  • CLOSE_CURSOR Procedure
  • COLUMN_VALUE Procedure
  • COLUMN_VALUE_LONG Procedure
  • DEFINE_ARRAY Procedure
  • DEFINE_COLUMN Procedure
  • DEFINE_COLUMN_LONG Procedure
  • DESCRIBE_COLUMNS Procedure
  • DESCRIBE_COLUMNS2 Procedure
  • EXECUTE Function
  • EXECUTE_AND_FETCH Function
  • FETCH_ROWS Function
  • IS_OPEN Function
  • LAST_ERROR_POSITION Function
  • LAST_ROW_COUNT Function
  • LAST_ROW_ID Function
  • LAST_SQL_FUNCTION_CODE Function
  • OPEN_CURSOR Function
  • PARSE Procedure
  • VARIABLE_VALUE Procedures

101 DBMS_SQLTUNE

• Using DBMS_SQLTUNE
  • Overview
  • Security Model
• Data Structures
  • SQLSET_ROW Object Type
• Subprogram Groups
  • SQL Tuning Advisor Subprograms
  • SQL Profile Subprograms
  • SQL Tuning Set Subprograms
• Summary of DBMS_SQLTUNE Subprograms
  • ACCEPT_SQL_PROFILE Procedure and Function
  • ADD_SQLSET_REFERENCE Function
  • ALTER_SQL_PROFILE Procedure
  • CANCEL_TUNING_TASK Procedure
  • CAPTURE_CURSOR_CACHE_SQLSET Procedure
  • CREATE_SQLSET Procedure and Function
  • CREATE_STGTAB_SQLPROF Procedure
  • CREATE_STGTAB_SQLSET Procedure
  • CREATE_TUNING_TASK Functions
  • DELETE_SQLSET Procedure
  • DROP_SQL_PROFILE Procedure
  • DROP_SQLSET Procedure
  • DROP_TUNING_TASK Procedure
  • EXECUTE_TUNING_TASK Procedure
  • INTERRUPT_TUNING_TASK Procedure
  • LOAD_SQLSET Procedure
  • PACK_STGTAB_SQLPROF Procedure
  • PACK_STGTAB_SQLSET Procedure
  • REMAP_STGTAB_SQLPROF Procedure
  • REMAP_STGTAB_SQLSET Procedure
  • REMOVE_SQLSET_REFERENCE Procedure
  • REPORT_TUNING_TASK Function
  • RESET_TUNING_TASK Procedure
  • RESUME_TUNING_TASK Procedure
  • SCRIPT_TUNING_TASK Function
  • SELECT_CURSOR_CACHE Function
  • SELECT_SQLSET Function
  • SELECT_WORKLOAD_REPOSITORY Functions
  • SQLTEXT_TO_SIGNATURE Function
  • UNPACK_STGTAB_SQLPROF Procedure
  • UNPACK_STGTAB_SQLSET Procedure
  • UPDATE_SQLSET Procedures

102 DBMS_STAT_FUNCS

• Summary of DBMS_STAT_FUNCS Subprograms
  • EXPONENTIAL_DIST_FIT Procedure
  • NORMAL_DIST_FIT Procedure
  • POISSON_DIST_FIT Procedure
  • SUMMARY Procedure
  • UNIFORM_DIST_FIT Procedure
  • WEIBULL_DIST_FIT Procedure

103 DBMS_STATS

• Using DBMS_STATS
  • Overview
  • Types
  • Constants
  • Operational Notes
  • Deprecated Subprograms
  • Examples
• Summary of DBMS_STATS Subprograms
  • ALTER_DATABASE_TAB_MONITORING Procedure
  • ALTER_SCHEMA_TAB_MONITORING Procedure
  • ALTER_STATS_HISTORY_RETENTION Procedure
  • CONVERT_RAW_VALUE Procedures
  • CONVERT_RAW_VALUE_NVARCHAR Procedure
  • CONVERT_RAW_VALUE_ROWID Procedure
  • CREATE_STAT_TABLE Procedure
  • DELETE_COLUMN_STATS Procedure
  • DELETE_DATABASE_STATS Procedure
  • DELETE_DICTIONARY_STATS Procedure
  • DELETE_FIXED_OBJECTS_STATS Procedure
  • DELETE_INDEX_STATS Procedure
  • DELETE_SCHEMA_STATS Procedure
  • DELETE_SYSTEM_STATS Procedure
  • DELETE_TABLE_STATS Procedure
  • DROP_STAT_TABLE Procedure
  • EXPORT_COLUMN_STATS Procedure
  • EXPORT_DATABASE_STATS Procedure
  • EXPORT_DICTIONARY_STATS Procedure
  • EXPORT_FIXED_OBJECTS_STATS Procedure
  • EXPORT_INDEX_STATS Procedure
  • EXPORT_SCHEMA_STATS Procedure
  • EXPORT_SYSTEM_STATS Procedure
  • EXPORT_TABLE_STATS Procedure
  • FLUSH_DATABASE_MONITORING_INFO Procedure
  • GATHER_DATABASE_STATS Procedures
  • GATHER_DICTIONARY_STATS Procedure
  • GATHER_FIXED_OBJECTS_STATS Procedure
  • GATHER_INDEX_STATS Procedure
  • GATHER_SCHEMA_STATS Procedures
  • GATHER_SYSTEM_STATS Procedure
  • GATHER_TABLE_STATS Procedure
  • GENERATE_STATS Procedure
  • GET_COLUMN_STATS Procedures
  • GET_INDEX_STATS Procedures
  • GET_PARAM Function
  • GET_STATS_HISTORY_AVAILABILITY Function
  • GET_STATS_HISTORY_RETENTION Function
  • GET_SYSTEM_STATS Procedure
  • GET_TABLE_STATS Procedure
  • IMPORT_COLUMN_STATS Procedure
  • IMPORT_DATABASE_STATS Procedure
  • IMPORT_DICTIONARY_STATS Procedure
  • IMPORT_FIXED_OBJECTS_STATS Procedure
  • IMPORT_INDEX_STATS Procedure
  • IMPORT_SCHEMA_STATS Procedure
  • IMPORT_SYSTEM_STATS Procedure
  • IMPORT_TABLE_STATS Procedure
  • LOCK_SCHEMA_STATS Procedure
  • LOCK_TABLE_STATS Procedure
  • PREPARE_COLUMN_VALUES Procedures
  • PREPARE_COLUMN_VALUES_NVARCHAR2 Procedure
  • PREPARE_COLUMN_VALUES_ROWID Procedure
  • PURGE_STATS Procedure
  • RESET_PARAM_DEFAULTS Procedure
  • RESTORE_DATABASE_STATS Procedure
  • RESTORE_DICTIONARY_STATS Procedure
  • RESTORE_FIXED_OBJECTS_STATS Procedure
  • RESTORE_SCHEMA_STATS Procedure
  • RESTORE_SYSTEM_STATS Procedure
  • RESTORE_TABLE_STATS Procedure
  • SET_COLUMN_STATS Procedures
  • SET_INDEX_STATS Procedures
  • SET_PARAM Procedure
  • SET_SYSTEM_STATS Procedure
  • SET_TABLE_STATS Procedure
  • UNLOCK_SCHEMA_STATS Procedure
  • UNLOCK_TABLE_STATS Procedure
  • UPGRADE_STAT_TABLE Procedure

104 DBMS_STORAGE_MAP

• Using DBMS_STORAGE_MAP
  • Overview
  • Operational Notes
• Summary of DBMS_STORAGE_MAP Subprograms
  • DROP_ALL Function
  • DROP_ELEMENT Function
  • DROP_FILE Function
    • Parameters
  • LOCK_MAP Procedure
  • MAP_ALL Function
  • MAP_ELEMENT Function
  • MAP_FILE Function
  • MAP_OBJECT Function
  • RESTORE Function
  • SAVE Function
  • UNLOCK_MAP Procedure

105 DBMS_STREAMS

• Using DBMS_STREAMS
  • Security Model
• Summary of DBMS_STREAMS Subprograms
  • COMPATIBLE_10_2 Function
  • COMPATIBLE_10_1 Function
  • COMPATIBLE_9_2 Function
  • CONVERT_ANYDATA_TO_LCR_DDL Function
  • CONVERT_ANYDATA_TO_LCR_ROW Function
  • CONVERT_LCR_TO_XML Function
  • CONVERT_XML_TO_LCR Function
  • GET_INFORMATION Function
  • GET_STREAMS_NAME Function
  • GET_STREAMS_TYPE Function
  • GET_TAG Function
  • SET_TAG Procedure

106 DBMS_STREAMS_ADM

• Using DBMS_STREAMS_ADM
  • Overview
  • Deprecated Subprograms
  • Security Model
    • Capture User
    • Propagation User
    • Apply User
    • Messaging Client User
  • Operational Notes
    • Procedures That Create Rules and Streams Clients
    • Procedures That Configure a Streams Replication Environment
• Summary of DBMS_STREAMS_ADM Subprograms
  • ADD_COLUMN Procedure
  • ADD_GLOBAL_PROPAGATION_RULES Procedure
  • ADD_GLOBAL_RULES Procedure
  • ADD_MESSAGE_PROPAGATION_RULE Procedure
  • ADD_MESSAGE_RULE Procedure
  • ADD_SCHEMA_PROPAGATION_RULES Procedure
  • ADD_SCHEMA_RULES Procedure
  • ADD_SUBSET_PROPAGATION_RULES Procedure
  • ADD_SUBSET_RULES Procedure
  • ADD_TABLE_PROPAGATION_RULES Procedure
  • ADD_TABLE_RULES Procedure
  • CLEANUP_INSTANTIATION_SETUP Procedure
  • DELETE_COLUMN Procedure
  • GET_SCN_MAPPING Procedure
  • MAINTAIN_GLOBAL Procedure
  • MAINTAIN_SCHEMAS Procedure
  • MAINTAIN_SIMPLE_TABLESPACE Procedure
  • MAINTAIN_SIMPLE_TTS Procedure
  • MAINTAIN_TABLES Procedure
  • MAINTAIN_TABLESPACES Procedure
  • MAINTAIN_TTS Procedure
  • POST_INSTANTIATION_SETUP Procedure
  • PRE_INSTANTIATION_SETUP Procedure
  • PURGE_SOURCE_CATALOG Procedure
  • RECOVER_OPERATION Procedure
  • REMOVE_QUEUE Procedure
  • REMOVE_RULE Procedure
  • REMOVE_STREAMS_CONFIGURATION Procedure
  • RENAME_COLUMN Procedure
  • RENAME_SCHEMA Procedure
  • RENAME_TABLE Procedure
  • SET_MESSAGE_NOTIFICATION Procedure
  • SET_RULE_TRANSFORM_FUNCTION Procedure
  • SET_UP_QUEUE Procedure

107 DBMS_STREAMS_AUTH

• Summary of DBMS_STREAMS_AUTH Subprograms
  • GRANT_ADMIN_PRIVILEGE Procedure
  • GRANT_REMOTE_ADMIN_ACCESS Procedure
  • REVOKE_ADMIN_PRIVILEGE Procedure
  • REVOKE_REMOTE_ADMIN_ACCESS Procedure

108 DBMS_STREAMS_MESSAGING

• Summary of DBMS_STREAMS_MESSAGING Subprograms
  • DEQUEUE Procedure
  • ENQUEUE Procedure

109 DBMS_STREAMS_TABLESPACE_ADM

• Using DBMS_STREAMS_TABLESPACE_ADM
  • Overview
  • Types
    • DIRECTORY_OBJECT_SET Type
    • FILE Type
    • FILE_SET Type
    • TABLESPACE_SET Type
• Summary of DBMS_STREAMS_TABLESPACE_ADM Subprograms
  • ATTACH_SIMPLE_TABLESPACE Procedure
  • ATTACH_TABLESPACES Procedure
  • CLONE_SIMPLE_TABLESPACE Procedure
  • CLONE_TABLESPACES Procedure
  • DETACH_SIMPLE_TABLESPACE Procedure
  • DETACH_TABLESPACES Procedure
  • PULL_SIMPLE_TABLESPACE Procedure
  • PULL_TABLESPACES Procedure

110 DBMS_TRACE

• Using DBMS_TRACE
  • Overview
  • Security Model
  • Constants
  • Restrictions
  • Operational Notes
    • Controlling Data Volume
    • Creating Database Tables to Collect DBMS_TRACE Output
    • Collecting Trace Data
    • Collected Data
    • Trace Control
• Summary of DBMS_TRACE Subprograms
  • CLEAR_PLSQL_TRACE Procedure
  • PLSQL_TRACE_VERSION Procedure
  • SET_PLSQL_TRACE Procedure

111 DBMS_TRANSACTION

• Using DBMS_TRANSACTION
  • Security Model
• Summary of DBMS_TRANSACTION Subprograms
  • ADVISE_COMMIT Procedure
  • ADVISE_NOTHING Procedure
  • ADVISE_ROLLBACK Procedure
  • BEGIN_DISCRETE_TRANSACTION Procedure
  • COMMIT Procedure
  • COMMIT_COMMENT Procedure
  • COMMIT_FORCE Procedure
  • LOCAL_TRANSACTION_ID Function
  • PURGE_LOST_DB_ENTRY Procedure
  • PURGE_MIXED Procedure
  • READ_ONLY Procedure
  • READ_WRITE Procedure
  • ROLLBACK Procedure
  • ROLLBACK_FORCE Procedure
  • ROLLBACK_SAVEPOINT Procedure
  • SAVEPOINT Procedure
  • STEP_ID Function
  • USE_ROLLBACK_SEGMENT Procedure

112 DBMS_TRANSFORM

• Summary of DBMS_TRANSFORM Subprograms
  • CREATE_TRANSFORMATION Procedure
  • DROP_TRANSFORMATION Procedure
  • MODIFY_TRANSFORMATION Procedure

113 DBMS_TDB

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

114 DBMS_TTS

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

115 DBMS_TYPES

• Using DBMS_TYPES
  • Constants
  • Exceptions

116 DBMS_UTILITY

• Using DBMS_UTILITY
  • Security Model
  • Constants
  • Types
    • dblink_array
    • index_table_type
    • instance_record
    • lname_array
    • name_array
    • number_array
    • uncl_array
  • Deprecated Subprograms
  • Exceptions
• Summary of DBMS_UTILITY Subprograms
  • ACTIVE_INSTANCES Procedure
  • ANALYZE_DATABASE Procedure
  • ANALYZE_PART_OBJECT Procedure
  • ANALYZE_SCHEMA Procedure
  • CANONICALIZE Procedure
  • COMMA_TO_TABLE Procedures
  • COMPILE_SCHEMA Procedure
  • CREATE_ALTER_TYPE_ERROR_TABLE Procedure
  • CURRENT_INSTANCE Function
  • DATA_BLOCK_ADDRESS_BLOCK Function
  • DATA_BLOCK_ADDRESS_FILE Function
  • DB_VERSION Procedure
  • EXEC_DDL_STATEMENT Procedure
  • FORMAT_CALL_STACK Function
  • FORMAT_ERROR_BACKTRACE Function
  • FORMAT_ERROR_STACK Function
  • GET_CPU_TIME Function
  • GET_DEPENDENCY Procedure
  • GET_HASH_VALUE Function
  • GET_PARAMETER_VALUE Function
  • GET_TIME Function
  • INVALIDATE Procedure
  • IS_CLUSTER_DATABASE Function
  • MAKE_DATA_BLOCK_ADDRESS Function
  • NAME_RESOLVE Procedure
  • NAME_TOKENIZE Procedure
  • PORT_STRING Function
  • TABLE_TO_COMMA Procedures
  • VALIDATE Procedure

117 DBMS_WARNING

• Using DBMS_WARNING
  • Security Model
• Summary of DBMS_WARNING Subprograms
  • ADD_WARNING_SETTING_CAT Procedure
  • ADD_WARNING_SETTING_NUM Procedure
  • GET_CATEGORY Function
  • GET_WARNING_SETTING_CAT Function
  • GET_WARNING_SETTING_NUM Function
  • GET_WARNING_SETTING_STRING Function
  • SET_WARNING_SETTING_STRING Procedure

118 DBMS_WORKLOAD_CAPTURE

• Using DBMS_WORKLOAD_CAPTURE
  • Overview
  • Security Model
• Summary of DBMS_WORKLOAD_CAPTURE Subprograms
  • ADD_FILTER Procedures
  • DELETE_CAPTURE_INFO Procedure
  • DELETE_FILTER Procedure
  • EXPORT_AWR Procedure
  • FINISH_CAPTURE Procedure
  • GET_CAPTURE_INFO Function
  • IMPORT_AWR Function
  • REPORT Function
  • START_CAPTURE Procedure

119 DBMS_WORKLOAD_REPOSITORY

• Using DBMS_WORKLOAD_REPOSITORY
  • Examples
• Summary of DBMS_WORKLOAD_REPOSITORY Subprograms
  • ASH_REPORT_HTML Function
  • ASH_REPORT_TEXT Function
  • AWR_DIFF_REPORT_HTML Function
  • AWR_DIFF_REPORT_TEXT Function
  • AWR_REPORT_HTML Function
  • AWR_REPORT_TEXT Function
  • AWR_SQL_REPORT_HTML Function
  • AWR_SQL_REPORT_TEXT Function
  • CREATE_BASELINE Function and Procedure
  • CREATE_SNAPSHOT Function and Procedure
  • DROP_BASELINE Procedure
  • DROP_SNAPSHOT_RANGE Procedure
  • MODIFY_SNAPSHOT_SETTINGS Procedures

120 DBMS_WM

• Documentation of DBMS_WM

121 DBMS_XDB

• Using DBMS_XDB
  • Overview
  • Constants
• Summary of DBMS_XDB Subprograms
  • ACLCHECKPRIVILEGES Function
  • APPENDRESOURCEMETADATA Procedure
  • CFG_GET Function
  • CFG_REFRESH Procedure
  • CFG_UPDATE Procedure
  • CHANGEPRIVILEGES Function
  • CHECKPRIVILEGES Function
  • CREATEFOLDER Function
  • CREATEOIDPATH Function
  • CREATERESOURCE Functions
  • DELETERESOURCE Procedure
  • DELETERESOURCEMETADATA Procedures
  • EXISTSRESOURCE Function
  • GETACLDOCUMENT Function
  • GETFTPPORT Function
  • GETHTTPPORT Function
  • GETLOCKTOKEN Procedure
  • GETPRIVILEGES Function
  • GETRESOID Function
  • GETXDB_TABLESPACE Function
  • LINK Procedure
  • LOCKRESOURCE Function
  • MOVEXDB_TABLESPACE Procedure
  • PURGERESOURCEMETADATA Procedure
  • REBUILDHIERARCHICALINDEX Procedure
  • RENAMERESOURCE Procedure
  • SETACL Procedure
  • SETFTPPORT Procedure
  • SETHTTPPORT Procedure
  • UPDATERESOURCEMETADATA Procedures
  • UNLOCKRESOURCE Function

122 DBMS_XDB_VERSION

• Summary of DBMS_XDB_VERSION Subprograms
  • CHECKIN Function
  • CHECKOUT Procedure
  • GETCONTENTSBLOBBYRESID Function
  • GETCONTENTSCLOBBYRESID Function
  • GETCONTENTSXMLBYRESID Function
  • GETPREDECESSORS Function
  • GETPREDSBYRESID Function
  • GETRESOURCEBYRESID Function
  • GETSUCCESSORS Function
  • GETSUCCSBYRESID Function
  • MAKEVERSIONED Function
  • UNCHECKOUT Function

123 DBMS_XDBT

• Using DBMS_XDBT
  • Overview
  • Operational Notes
• Summary of DBMS_XDBT Subprograms
  • CONFIGUREAUTOSYNC Procedure
  • CREATEDATASTOREPREF Procedure
  • CREATEFILTERPREF Procedure
  • CREATEINDEX Procedure
  • CREATELEXERPREF Procedure
  • CREATEPREFERENCES Procedure
  • CREATESECTIONGROUPPREF Procedure
  • CREATESTOPLISTPREF Procedure
  • CREATESTORAGEPREF Procedure
  • CREATEWORLDLISTPREF Procedure
  • DROPPREFERENCES Procedure

124 DBMS_XDBZ

• Using DBMS_XDBZ
  • Constants
• Summary of DBMS_XDBZ Subprograms
  • DISABLE_HIERARCHY Procedure
  • ENABLE_HIERARCHY Procedure
  • GET_ACLOID Function
  • GET_USERID Function
  • IS_HIERARCHY_ENABLED Function
  • PURGELDAPCACHE Function

125 DBMS_XMLDOM

• Using DBMS_XMLDOM
  • Overview
  • Constants
  • Types
  • Exceptions
• Subprogram Groups
  • DOMNode Subprograms
  • DOMAttr Subprograms
  • DOMCDataSection Subprograms
  • DOMCharacterData Subprograms
  • DOMComment Subprograms
  • DOMDocument Subprograms
  • DOMDocumentFragment Subprograms
  • DOMDocumentType Subprograms
  • DOMElement Subprograms
  • DOMEntity Subprograms
  • DOMEntityReference Subprograms
  • DOMImplementation Subprograms
  • DOMNamedNodeMap Subprograms
  • DOMNodeList Subprograms
  • DOMNotation Subprograms
  • DOMProcessingInstruction Subprograms
  • DOMText Subprograms
• Summary of DBMS_XMLDOM Subprograms
  • ADOPTNODE Function
  • APPENDCHILD Function
  • APPENDDATA Procedure
  • CLONENODE Function
  • CREATEATTRIBUTE Functions
  • CREATECDATASECTION Function
  • CREATECOMMENT Function
  • CREATEDOCUMENT Function
  • CREATEDOCUMENTFRAGMENT Function
  • CREATEELEMENT Functions
  • CREATEENTITYREFERENCE Function
  • CREATEPROCESSINGINSTRUCTION Function
  • CREATETEXTNODE Function
  • DELETEDATA Procedure
  • FINDENTITY Function
  • FINDNOTATION Function
  • FREEDOCFRAG Procedure
  • FREEDOCUMENT Procedure
  • FREENODE Procedure
  • GETATTRIBUTE Functions
  • GETATTRIBUTENODE Functions
  • GETATTRIBUTES Function
  • GETCHILDNODES Function
  • GETCHILDRENBYTAGNAME Functions
  • GETDATA Functions
  • GETDOCTYPE Function
  • GETDOCUMENTELEMENT Function
  • GETELEMENTSBYTAGNAME Functions
  • GETENTITIES Function
  • GETEXPANDEDNAME Procedure and Functions
  • GETFIRSTCHILD Function
  • GETIMPLEMENTATION Function
  • GETLASTCHILD Function
  • GETLENGTH Functions
  • GETLOCALNAME Procedure and Functions
  • GETNAME Functions
  • GETNAMEDITEM Function
  • GETNAMESPACE Procedure and Functions
  • GETNEXTSIBLING Function
  • GETNODENAME Function
  • GETNODETYPE Function
  • GETNODEVALUE Function
  • GETNOTATIONNAME Function
  • GETNOTATIONS Function
  • GETTARGET Function
  • GETOWNERDOCUMENT Function
  • GETOWNERELEMENT Function
  • GETPARENTNODE Function
  • GETPREFIX Function
  • GETPREVIOUSSIBLING Function
  • GETPUBLICID Functions
  • GETQUALIFIEDNAME Functions
  • GETSCHEMANODE Function
  • GETSPECIFIED Function
  • GETSTANDALONE Function
  • GETSYSTEMID Functions
  • GETTAGNAME Function
  • GETVALUE Function
  • GETVERSION Function
  • GETXMLTYPE Function
  • HASATTRIBUTE Functions
  • HASATTRIBUTES Function
  • HASCHILDNODES Function
  • HASFEATURE Function
  • IMPORTNODE Function
  • INSERTBEFORE Function
  • INSERTDATA Procedure
  • ISNULL Functions
  • ITEM Functions
  • MAKEATTR Function
  • MAKECDATASECTION Function
  • MAKECHARACTERDATA Function
  • MAKECOMMENT Function
  • MAKEDOCUMENT Function
  • MAKEDOCUMENTFRAGMENT Function
  • MAKEDOCUMENTTYPE Function
  • MAKEELEMENT Function
  • MAKEENTITY Function
  • MAKEENTITYREFERENCE Function
  • MAKENODE Functions
  • MAKENOTATION Function
  • MAKEPROCESSINGINSTRUCTION Function
  • MAKETEXT Function
  • NEWDOMDOCUMENT Functions
  • NORMALIZE Procedure
  • REMOVEATTRIBUTE Procedures
  • REMOVEATTRIBUTENODE Function
  • REMOVECHILD Function
  • REMOVENAMEDITEM Function
  • REPLACECHILD Function
  • REPLACEDATA Procedure
  • RESOLVENAMESPACEPREFIX Function
  • SETATTRIBUTE Procedures
  • SETATTRIBUTENODE Functions
  • SETDATA Procedures
  • SETDOCTYPE Procedure
  • SETNAMEDITEM Function
  • SETNODEVALUE Procedure
  • SETPREFIX Procedure
  • SETSTANDALONE Procedure
  • SETVALUE Procedure
  • SETVERSION Procedure
  • SPLITTEXT Function
  • SUBSTRINGDATA Function
  • WRITETOBUFFER Procedures
  • WRITETOCLOB Procedures
  • WRITETOFILE Procedures

126 DBMS_XMLGEN

• Summary of DBMS_XMLGEN Subprograms
  • CLOSECONTEXT Procedure
  • CONVERT Functions
  • GETNUMROWSPROCESSED Function
  • GETXML Functions
  • GETXMLTYPE Functions
  • NEWCONTEXT Functions
  • RESTARTQUERY Procedure
  • SETCONVERTSPECIALCHARS Procedure
  • SETMAXROWS Procedure
  • SETNULLHANDLING Procedure
  • SETROWSETTAG Procedure
  • SETROWTAG Procedure
  • SETSKIPROWS Procedure
  • USEITEMTAGSFORCOLL Procedure
  • USENULLATTRIBUTEINDICATOR Procedure

127 DBMS_XMLPARSER

• Summary of DBMS_XMLPARSER Subprograms
  • FREEPARSER
  • GETDOCTYPE
  • GETDOCUMENT
  • GETRELEASEVERSION
  • GETVALIDATIONMODE
  • NEWPARSER
  • PARSE
  • PARSEBUFFER
  • PARSECLOB
  • PARSEDTD
  • PARSEDTDBUFFER
  • PARSEDTDCLOB
  • SETBASEDIR
  • SETDOCTYPE
  • SETERRORLOG
  • SETPRESERVEWHITESPACE
  • SETVALIDATIONMODE
  • SHOWWARNINGS

128 DBMS_XMLQUERY

• Using DBMS_XMLQUERY
  • Constants
  • Types
• Summary of DBMS_XMLQUERY Subprograms
  • CLOSECONTEXT
  • GETDTD
  • GETEXCEPTIONCONTENT
  • GETNUMROWSPROCESSED
  • GETVERSION
  • GETXML
  • NEWCONTEXT
  • PROPAGATEORIGINALEXCEPTION
  • REMOVEXSLTPARAM
  • SETBINDVALUE
  • SETCOLLIDATTRNAME
  • SETDATAHEADER
  • SETDATEFORMAT
  • SETENCODINGTAG
  • SETERRORTAG
  • SETMAXROWS
  • SETMETAHEADER
  • SETRAISEEXCEPTION
  • SETRAISENOROWSEXCEPTION
  • SETROWIDATTRNAME
  • SETROWIDATTRVALUE
  • SETROWSETTAG
  • SETROWTAG
  • SETSKIPROWS
  • SETSQLTOXMLNAMEESCAPING
  • SETSTYLESHEETHEADER
  • SETTAGCASE
  • SETXSLT
  • SETXSLTPARAM
  • USENULLATTRIBUTEINDICATOR
  • USETYPEFORCOLLELEMTAG

129 DBMS_XMLSAVE

• Using DBMS_XMLSAVE
  • Constants
  • Types
• Summary of DBMS_XMLSAVE Subprograms
  • CLEARKEYCOLUMNLIST
  • CLEARUPDATECOLUMNLIST
  • CLOSECONTEXT
  • DELETEXML
  • GETEXCEPTIONCONTENT
  • INSERTXML
  • NEWCONTEXT
  • PROPAGATEORIGINALEXCEPTION
  • REMOVEXSLTPARAM
  • SETBATCHSIZE
  • SETCOMMITBATCH
  • SETDATEFORMAT
  • SETIGNORECASE
  • SETKEYCOLUMN
  • SETPRESERVEWHITESPACE
  • SETROWTAG
  • SETSQLTOXMLNAMEESCAPING
  • SETUPDATECOLUMN
  • SETXSLT
  • SETXSLTPARAM
  • UPDATEXML

130 DBMS_XMLSCHEMA

• Using DBMS_XMLSCHEMA
  • Overview
  • Constants
  • Views
• Summary of DBMS_XMLSCHEMA Subprograms
  • COMPILESCHEMA Procedure
  • COPYEVOLVE Procedure
  • DELETESCHEMA Procedure
  • GENERATEBEAN Procedure
  • GENERATESCHEMA Function
  • GENERATESCHEMAS Function
  • REGISTERSCHEMA Procedures
  • REGISTERURI Procedure

131 DBMS_XMLSTORE

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

132 DBMS_XPLAN

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

133 DBMS_XSLPROCESSOR

• Using DBMS_XSLPROCESSOR
  • Overview
• Summary of DBMS_XSLPROCESSOR Subprograms
  • CLOB2FILE Procedure
  • FREEPROCESSOR Procedure
  • FREESTYLESHEET Procedure
  • NEWPROCESSOR Function
  • NEWSTYLESHEET Functions
  • PROCESSXSL Functions and Procedures
  • READ2CLOB Function
  • REMOVEPARAM Procedure
  • RESETPARAMS Procedure
  • SELECTNODES Function
  • SELECTSINGLENODE Function
  • SETERRORLOG Procedure
  • SETPARAM Procedure
  • SHOWWARNINGS Procedure
  • TRANSFORMNODE Function
  • VALUEOF Function and Procedure

134 DEBUG_EXTPROC

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

135 HTF

• Using HTF
  • Operational Notes
  • Rules and Limits
  • Examples
• Summary of Tags
• Summary of HTF Subprograms
  • ADDRESS Function
  • ANCHOR Function
  • ANCHOR2 Function
  • APPLETCLOSE Function
  • APPLETOPEN Function
  • AREA Function
  • BASE Function
  • BASEFONT Function
  • BGSOUND Function
  • BIG Function
  • BLOCKQUOTECLOSE Function
  • BLOCKQUOTEOPEN Function
  • BODYCLOSE Function
  • BODYOPEN Function
  • BOLD Function
  • BR Function
  • CENTER Function
  • CENTERCLOSE Function
  • CENTEROPEN Function
  • CITE Function
  • CODE Function
  • COMMENT Function
  • DFN Function
  • DIRLISTCLOSE Function
  • DIRLISTOPEN Function
  • DIV Function
  • DLISTCLOSE Function
  • DLISTDEF Function
  • DLISTOPEN Function
  • DLISTTERM Function
  • EM Function
  • EMPHASIS Function
  • ESCAPE_SC Function
  • ESCAPE_URL Function
  • FONTCLOSE Function
  • FONTOPEN Function
  • FORMAT_CELL Function
  • FORMCHECKBOX Function
  • FORMCLOSE Function
  • FORMFILE Function
  • FORMHIDDEN Function
  • FORMIMAGE Function
  • FORMOPEN Function
  • FORMPASSWORD Function
  • FORMRADIO Function
  • FORMRESET Function
  • FORMSELECTCLOSE Function
  • FORMSELECTOPEN Function
  • FORMSELECTOPTION Function
  • FORMSUBMIT Function
  • FORMTEXT Function
  • FORMTEXTAREA Function
  • FORMTEXTAREA2 Function
  • FORMTEXTAREACLOSE Function
  • FORMTEXTAREAOPEN Function
  • FORMTEXTAREAOPEN2 Function
  • FRAME Function
  • FRAMESETCLOSE Function
  • FRAMESETOPEN Function
  • HEADCLOSE Function
  • HEADER Function
  • HEADOPEN Function
  • HR Function
  • HTMLCLOSE Function
  • HTMLOPEN Function
  • IMG Function
  • IMG2 Function
  • ISINDEX Function
  • ITALIC Function
  • KBD Function
  • KEYBOARD Function
  • LINE Function
  • LINKREL Function
  • LINKREV Function
  • LISTHEADER Function
  • LISTINGCLOSE Function
  • LISTINGOPEN Function
  • LISTITEM Function
  • MAILTO Function
  • MAPCLOSE Function
  • MAPOPEN Function
  • MENULISTCLOSE Function
  • MENULISTOPEN Function
  • META Function
  • NL Function
  • NOBR Function
  • NOFRAMESCLOSE Function
  • NOFRAMESOPEN Function
  • OLISTCLOSE Function
  • OLISTOPEN Function
  • PARA Function
  • PARAGRAPH Function
  • PARAM Function
  • PLAINTEXT Function
  • PRECLOSE Function
  • PREOPEN Function
  • PRINT Functions
  • PRN Functions
  • S Function
  • SAMPLE Function
  • SCRIPT Function
  • SMALL Function
  • STRIKE Function
  • STRONG Function
  • STYLE Function
  • SUB Function
  • SUP Function
  • TABLECAPTION Function
  • TABLECLOSE Function
  • TABLEDATA Function
  • TABLEHEADER Function
  • TABLEOPEN Function
  • TABLEROWCLOSE Function
  • TABLEROWOPEN Function
  • TELETYPE Function
  • TITLE Function
  • ULISTCLOSE Function
  • ULISTOPEN Function
  • UNDERLINE Function
  • VARIABLE Function
  • WBR Function

136 HTMLDB_CUSTOM_AUTH

• Documentation of HTMLDB_CUSTOM_AUTH

137 HTMLDB_APPLICATION

• Documentation of HTMLDB_APPLICATION

138 HTMLDB_ITEM

• Documentation of HTMLDB_ITEM

139 HTMLDB_UTIL

• Documentation of HTMLDB_UTIL

140 HTP

• Using HTP
  • Operational Notes
  • Rules and Limits
  • Examples
• Summary of Tags
• Summary of HTP Subprograms
  • ADDRESS Procedure
  • ANCHOR Procedure
  • ANCHOR2 Procedure
  • APPLETCLOSE Procedure
  • APPLETOPEN Procedure
  • AREA Procedure
  • BASE Procedure
  • BASEFONT Procedure
  • BGSOUND Procedure
  • BIG Procedure
  • BLOCKQUOTECLOSE Procedure
  • BLOCKQUOTEOPEN Procedure
  • BODYCLOSE Procedure
  • BODYOPEN Procedure
  • BOLD Procedure
  • BR Procedure
  • CENTER Procedure
  • CENTERCLOSE Procedure
  • CENTEROPEN Procedure
  • CITE Procedure
  • CODE Procedure
  • COMMENT Procedure
  • DFN Procedure
  • DIRLISTCLOSE Procedure
  • DIRLISTOPEN Procedure
  • DIV Procedure
  • DLISTCLOSE Procedure
  • DLISTDEF Procedure
  • DLISTOPEN Procedure
  • DLISTTERM Procedure
  • EM Procedure
  • EMPHASIS Procedure
  • ESCAPE_SC Procedure
  • FONTCLOSE Procedure
  • FONTOPEN Procedure
  • FORMCHECKBOX Procedure
  • FORMCLOSE Procedure
  • FORMOPEN Procedure
  • FORMFILE Procedure
  • FORMHIDDEN Procedure
  • FORMIMAGE Procedure
  • FORMPASSWORD Procedure
  • FORMRADIO Procedure
  • FORMRESET Procedure
  • FORMSELECTCLOSE Procedure
  • FORMSELECTOPEN Procedure
  • FORMSELECTOPTION Procedure
  • FORMSUBMIT Procedure
  • FORMTEXT Procedure
  • FORMTEXTAREA Procedure
  • FORMTEXTAREA2 Procedure
  • FORMTEXTAREACLOSE Procedure
  • FORMTEXTAREAOPEN Procedure
  • FORMTEXTAREAOPEN2 Procedure
  • FRAME Procedure
  • FRAMESETCLOSE Procedure
  • FRAMESETOPEN Procedure
  • HEADCLOSE Procedure
  • HEADER Procedure
  • HEADOPEN Procedure
  • HR Procedure
  • HTMLCLOSE Procedure
  • HTMLOPEN Procedure
  • IMG Procedure
  • IMG2 Procedure
  • ISINDEX Procedure
  • ITALIC Procedure
  • KBD Procedure
  • KEYBOARD Procedure
  • LINE Procedure
  • LINKREL Procedure
  • LINKREV Procedure
  • LISTHEADER Procedure
  • LISTINGCLOSE Procedure
  • LISTINGOPEN Procedure
  • LISTITEM Procedure
  • MAILTO Procedure
  • MAPCLOSE Procedure
  • MAPOPEN Procedure
  • MENULISTCLOSE Procedure
  • MENULISTOPEN Procedure
  • META Procedure
  • NL Procedure
  • NOBR Procedure
  • NOFRAMESCLOSE Procedure
  • NOFRAMESOPEN Procedure
  • OLISTCLOSE Procedure
  • OLISTOPEN Procedure
  • PARA Procedure
  • PARAGRAPH Procedure
  • PARAM Procedure
  • PLAINTEXT Procedure
  • PRECLOSE Procedure
  • PREOPEN Procedure
  • PRINT Procedures
  • PRINTS Procedure
  • PRN Procedures
  • PS Procedure
  • S Procedure
  • SAMPLE Procedure
  • SCRIPT Procedure
  • SMALL Procedure
  • STRIKE Procedure
  • STRONG Procedure
  • STYLE Procedure
  • SUB Procedure
  • SUP Procedure
  • TABLECAPTION Procedure
  • TABLECLOSE Procedure
  • TABLEDATA Procedure
  • TABLEHEADER Procedure
  • TABLEOPEN Procedure
  • TABLEROWCLOSE Procedure
  • TABLEROWOPEN Procedure
  • TELETYPE Procedure
  • TITLE Procedure
  • ULISTCLOSE Procedure
  • ULISTOPEN Procedure
  • UNDERLINE Procedure
  • VARIABLE Procedure
  • WBR Procedure

141 OWA_CACHE

• Using OWA_CACHE
  • Constants
• Summary of OWA_CACHE Subprograms
  • DISABLE Procedure
  • GET_ETAG Function
  • GET_LEVEL Function
  • SET_CACHE Procedure
  • SET_EXPIRES Procedure
  • SET_NOT_MODIFIED Procedure
  • SET_SURROGATE_CONTROL Procedure

142 OWA_COOKIE

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

143 OWA_CUSTOM

• Using OWA_CUSTOM
  • Constants
• Summary of OWA_CUSTOM Subprograms
  • AUTHORIZE Function

144 OWA_IMAGE

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

145 OWA_OPT_LOCK

• Using OWA_OPT_LOCK
  • Overview
  • Types
• Summary of OWA_OPT_LOCK Subprograms
  • CHECKSUM Functions
  • GET_ROWID Function
  • STORE_VALUES Procedure
  • VERIFY_VALUES Function

146 OWA_PATTERN

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

147 OWA_SEC

• Using OWA_SEC
  • Operational Notes
• Summary of OWA_SEC Subprograms
  • GET_CLIENT_HOSTNAME Function
  • GET_CLIENT_IP Function
  • GET_PASSWORD Function
  • GET_USER_ID Function
  • SET_AUTHORIZATION Procedure
  • SET_PROTECTION_REALM Procedure

148 OWA_TEXT

• Using OWA_TEXT
  • Types
    • MULTI_LINE DATA TYPE
    • ROW_LIST DATA TYPE
    • VC_ARR DATA TYPE
• Summary of OWA_TEXT Subprograms
  • ADD2MULTI Procedure
  • NEW_ROW_LIST Function and Procedure
  • PRINT_MULTI Procedure
  • PRINT_ROW_LIST Procedure
  • STREAM2MULTI Procedure

149 OWA_UTIL

• Using OWA_UTIL
  • Overview
  • Types
    • DATETYPE Data Type
    • IDENT_ARR Data Type
    • IP_ADDRESS Data Type
• Summary of OWA_UTIL Subprograms
  • BIND_VARIABLES Function
  • CALENDARPRINT Procedures
  • CELLSPRINT Procedures
  • CHOOSE_DATE Procedure
  • GET_CGI_ENV Function
  • GET_OWA_SERVICE_PATH Function
  • GET_PROCEDURE Function
  • HTTP_HEADER_CLOSE Procedure
  • LISTPRINT Procedure
  • MIME_HEADER Procedure
  • PRINT_CGI_ENV Procedure
  • REDIRECT_URL Procedure
  • SHOWPAGE Procedure
  • SHOWSOURCE Procedure
  • SIGNATURE procedure
  • STATUS_LINE Procedure
  • TABLEPRINT Function
  • TODATE Function
  • WHO_CALLED_ME Procedure

150 SDO_CS

• Documentation of SDO_CS

151 SDO_GCDR

• Documentation of SDO_GCDR

152 SDO_GEOM

• Documentation of SDO_GEOM

153 SDO_GEOR

• Documentation of SDO_GEOR

154 SDO_GEOR_UTL

• Documentation of SDO_GEOR_UTL

155 SDO_LRS

• Documentation of SDO_LRS

156 SDO_MIGRATE

• Documentation of SDO_MIGRATE

157 SDO_NET

• Documentation of SDO_NET

158 SDO_NET_MEM

• Documentation of SDO_NET_MEM

159 SDO_SAM

• Documentation of SDO_SAM

160 SDO_TOPO

• Documentation of SDO_TOPO

161 SDO_TOPO_MAP

• Documentation of SDO_TOPO_MAP

162 SDO_TUNE

• Documentation of SDO_TUNE

163 SDO_UTIL

• Documentation of SDO_UTIL

164 UTL_COLL

• Summary of UTL_COLL Subprograms
  • IS_LOCATOR Function
    • Examples

165 UTL_COMPRESS

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

166 UTL_DBWS

• Using UTL_DBWS
  • Supported Keys and Default Settings for Standard Call Properties
• Summary of UTL_DBWS Subprograms
  • CREATE_CALL Function
  • CREATE_SERVICE Function
  • GET_IN_PARAMETER_TYPES Function
  • GET_OUT_PARAMETER_TYPES Function
  • GET_OUTPUT_VALUES Function
  • GET_PORTS Function
  • GET_PROPERTY Function
  • GET_RETURN_TYPE Function
  • GET_SERVICES Function
  • INVOKE Function
  • RELEASE_ALL_SERVICES Procedure
  • RELEASE_CALL Procedure
  • RELEASE_SERVICE Procedure
  • REMOVE_PROPERTY Procedure
  • SET_PROPERTY Procedure

167 UTL_ENCODE

• Summary of UTL_ENCODE Subprograms
  • BASE64_DECODE Function
  • BASE64_ENCODE Function
  • MIMEHEADER_DECODE Function
  • MIMEHEADER_ENCODE Function
  • QUOTED_PRINTABLE_DECODE Function
  • QUOTED_PRINTABLE_ENCODE Function
  • TEXT_DECODE Function
  • TEXT_ENCODE Function
  • UUDECODE Function
  • UUENCODE Function

168 UTL_FILE

• Using UTL_FILE
  • Security Model
  • Types
  • Operational Notes
  • Rules and Limits
  • Exceptions
  • Examples
• Summary of UTL_FILE Subprograms
  • FCLOSE Procedure
  • FCLOSE_ALL Procedure
  • FCOPY Procedure
  • FFLUSH Procedure
  • FGETATTR Procedure
  • FGETPOS Function
  • FOPEN Function
  • FOPEN_NCHAR Function
  • FREMOVE Procedure
  • FRENAME Procedure
  • FSEEK Procedure
  • GET_LINE Procedure
  • GET_LINE_NCHAR Procedure
  • GET_RAW Function
  • IS_OPEN Function
  • NEW_LINE Procedure
  • PUT Procedure
  • PUT_LINE Procedure
  • PUT_LINE_NCHAR Procedure
  • PUT_NCHAR Procedure
  • PUTF Procedure
  • PUTF_NCHAR Procedure
  • PUT_RAW Function

169 UTL_HTTP

• Using UTL_HTTP
  • Overview
  • Constants
  • Datatypes
    • REQ Type
    • RESP Type
    • COOKIE and COOKIE_TABLE Types
    • CONNECTION Type
  • Operational Notes
    • Operational Flow
    • Simple HTTP Fetches
    • Session Settings
    • HTTP Requests
    • HTTP Responses
    • HTTP Cookies
    • HTTP Persistent Connections
    • Error Conditions
  • Exceptions
  • Examples
    • General Usage
    • Handling HTTP Authentication
    • Retrieving and Restoring Cookies
• Subprogram Groups
  • Simple HTTP Fetches in a Single Call Subprograms
  • Session Settings Subprograms
  • HTTP Requests Subprograms
  • HTTP Responses Subprograms
  • HTTP Cookies Subprograms
  • HTTP Persistent Connections Subprograms
  • Error Conditions Subprograms
• Summary of UTL_HTTP Subprograms
  • ADD_COOKIES Procedure
  • BEGIN_REQUEST Function
  • CLEAR_COOKIES Procedure
  • CLOSE_PERSISTENT_CONN Procedure
  • CLOSE_PERSISTENT_CONNS Procedure
  • END_REQUEST Procedure
  • END_RESPONSE Procedure
  • GET_AUTHENTICATION Procedure
  • GET_BODY_CHARSET Procedure
  • GET_COOKIE_COUNT Function
  • GET_COOKIE_SUPPORT Procedure
  • GET_COOKIES Function
  • GET_DETAILED_EXCP_SUPPORT Procedure
  • GET_DETAILED_SQLCODE Function
  • GET_DETAILED_SQLERRM Function
  • GET_FOLLOW_REDIRECT Procedure
  • GET_HEADER Procedure
  • GET_HEADER_BY_NAME Procedure
  • GET_HEADER_COUNT Function
  • GET_PERSISTENT_CONN_COUNT Function
  • GET_PERSISTENT_CONN_SUPPORT Procedure
  • GET_PERSISTENT_CONNS Procedure
  • GET_PROXY Procedure
  • GET_RESPONSE Function
  • GET_RESPONSE_ERROR_CHECK Procedure
  • GET_TRANSFER_TIMEOUT Procedure
  • READ_LINE Procedure
  • READ_RAW Procedure
  • READ_TEXT Procedure
  • REQUEST Function
  • REQUEST_PIECES Function
  • SET_AUTHENTICATION Procedure
  • SET_BODY_CHARSET Procedures
  • SET_COOKIE_SUPPORT Procedures
  • SET_DETAILED_EXCP_SUPPORT Procedure
  • SET_FOLLOW_REDIRECT Procedures
  • SET_HEADER Procedure
  • SET_PERSISTENT_CONN_SUPPORT Procedure
  • SET_PROXY Procedure
  • SET_RESPONSE_ERROR_CHECK Procedure
  • SET_TRANSFER_TIMEOUT Procedure
  • SET_WALLET Procedure
  • WRITE_LINE Procedure
  • WRITE_RAW Procedure
  • WRITE_TEXT Procedure

170 UTL_I18N

• Using UTL_I18N
  • Overview
  • Constants
• Summary of UTL_I18N Subprograms
  • ESCAPE_REFERENCE Function
  • GET_COMMON_TIME_ZONES Function
  • GET_DEFAULT_CHARSET Function
  • GET_DEFAULT_ISO_CURRENCY Function
  • GET_DEFAULT_LINGUISTIC_SORT Function
  • GET_LOCAL_LANGUAGES Function
  • GET_LOCAL_LINGUISTIC_SORTS Function
  • GET_LOCAL_TERRITORIES Function
  • GET_LOCAL_TIME_ZONES Function
  • GET_TRANSLATION Function
  • MAP_CHARSET Function
  • MAP_FROM_SHORT_LANGUAGE Function
  • MAP_LANGUAGE_FROM_ISO Function
  • MAP_LOCALE_TO_ISO Function
  • MAP_TERRITORY_FROM_ISO Function
  • MAP_TO_SHORT_LANGUAGE Function
  • RAW_TO_CHAR Functions
  • RAW_TO_NCHAR Functions
  • STRING_TO_RAW Function
  • TRANSLITERATE Function
  • UNESCAPE_REFERENCE Function

171 UTL_INADDR

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

172 UTL_LMS

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

173 UTL_MAIL

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

174 UTL_NLA

• Using UTL_NLA
  • Overview
  • Rules and Limits
• Subprogram Groups
  • BLAS Level 1 (Vector-Vector Operations) Subprograms
  • BLAS Level 2 (Matrix-Vector Operations) Subprograms
  • BLAS Level 3 (Matrix-Matrix Operations) Subprograms
  • LAPACK Driver Routines (Linear Equations) Subprograms
  • LAPACK Driver Routines (LLS and Eigenvalue Problems) Subprograms
• Summary of UTL_NLA Subprograms
  • BLAS_ASUM Functions
  • BLAS_AXPY Procedures
  • BLAS_COPY Procedures
  • BLAS_DOT Functions
  • BLAS_GBMV Procedures
  • BLAS_GEMM Procedures
  • BLAS_GEMV Procedures
  • BLAS_GER Procedures
  • BLAS_IAMAX Functions
  • BLAS_NRM2 Functions
  • BLAS_ROT Procedures
  • BLAS_ROTG Procedures
  • BLAS_SCAL Procedures
  • BLAS_SPMV Procedures
  • BLAS_SPR Procedures
  • BLAS_SPR2 Procedures
  • BLAS_SBMV Procedures
  • BLAS_SWAP Procedures
  • BLAS_SYMM Procedures
  • BLAS_SYMV Procedures
  • BLAS_SYR Procedures
  • BLAS_SYR2 Procedures
  • BLAS_SYR2K Procedures
  • BLAS_SYRK Procedures
  • BLAS_TBMV Procedures
  • BLAS_TBSV Procedures
  • BLAS_TPMV Procedures
  • BLAS_TPSV Procedures
  • BLAS_TRMM Procedures
  • BLAS_TRMV Procedures
  • BLAS_TRSM Procedures
  • BLAS_TRSV Procedures
  • LAPACK_GBSV Procedures
  • LAPACK_GEES Procedures
  • LAPACK_GELS Procedures
  • LAPACK_GESDD Procedures
  • LAPACK_GESV Procedures
  • LAPACK_GESVD Procedures
  • LAPACK_GEEV Procedures
  • LAPACK_GTSV Procedures
  • LAPACK_PBSV Procedures
  • LAPACK_POSV Procedures
  • LAPACK_PPSV Procedures
  • LAPACK_PTSV Procedures
  • LAPACK_SBEV Procedures
  • LAPACK_SBEVD Procedures
  • LAPACK_SPEV Procedures
  • LAPACK_SPEVD Procedures
  • LAPACK_SPSV Procedures
  • LAPACK_STEV Procedures
  • LAPACK_STEVD Procedures
  • LAPACK_SYEV Procedures
  • LAPACK_SYEVD Procedures
  • LAPACK_SYSV Procedures

175 UTL_RAW

• Using UTL_RAW
  • Overview
  • Operational Notes
• Summary of UTL_RAW Subprograms
  • BIT_AND Function
  • BIT_COMPLEMENT Function
  • BIT_OR Function
  • BIT_XOR Function
  • CAST_FROM_BINARY_DOUBLE Function
  • CAST_FROM_BINARY_FLOAT Function
  • CAST_FROM_BINARY_INTEGER Function
  • CAST_FROM_NUMBER Function
  • CAST_TO_BINARY_DOUBLE Function
  • CAST_TO_BINARY_FLOAT Function
  • CAST_TO_BINARY_INTEGER Function
  • CAST_TO_NUMBER Function
  • CAST_TO_RAW Function
  • CAST_TO_VARCHAR2 Function
  • CAST_TO_NVARCHAR2 Function
  • COMPARE Function
  • CONCAT Function
  • CONVERT Function
  • COPIES Function
  • LENGTH Function
  • OVERLAY Function
  • REVERSE Function
  • SUBSTR Function
  • TRANSLATE Function
  • TRANSLITERATE Function
  • XRANGE Function

176 UTL_RECOMP

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

177 UTL_REF

• Using UTL_REF
  • Overview
  • Security Model
  • Types
  • Exceptions
• Summary of UTL_REF Subprograms
  • DELETE_OBJECT Procedure
  • LOCK_OBJECT Procedure
  • SELECT_OBJECT Procedure
  • UPDATE_OBJECT Procedure

178 UTL_SMTP

• Using UTL_SMTP
  • Overview
  • Types
    • CONNECTION Record Type
    • REPLY, REPLIES Record Types
  • Reply Codes
  • Exceptions
  • Rules and Limits
  • Examples
• Summary of UTL_SMTP Subprograms
  • CLOSE_DATA Function and Procedure
  • COMMAND Function and Procedure
  • COMMAND_REPLIES Function
  • DATA Function and Procedure
  • EHLO Function and Procedure
  • HELO Function and Procedure
  • HELP Function
  • MAIL Function and Procedure
  • NOOP Function and Procedure
  • OPEN_CONNECTION Functions
  • OPEN_DATA Function and Procedure
  • QUIT Function and Procedure
  • RCPT Function
  • RSET Function and Procedure
  • VRFY Function
  • WRITE_DATA Procedure
  • WRITE_RAW_DATA Procedure

179 UTL_TCP

• Using UTL_TCP
  • Overview
  • Types
    • CONNECTION Type
    • CRLF
  • Exceptions
  • Rules and Limits
  • Examples
• Summary of UTL_TCP Subprograms
  • AVAILABLE Function
  • CLOSE_ALL_CONNECTIONS Procedure
  • CLOSE_CONNECTION Procedure
  • FLUSH Procedure
  • GET_LINE Function
  • GET_RAW Function
  • GET_TEXT Function
  • OPEN_CONNECTION Function
  • READ_LINE Function
  • READ_RAW Function
  • READ_TEXT Function
  • WRITE_LINE Function
  • WRITE_RAW Function
  • WRITE_TEXT Function

180 UTL_URL

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

181 WPG_DOCLOAD

• Using WPG_DOCLOAD
  • Constants
    • NAME_COL_LEN
    • MIMET_COL_LEN
    • MAX_DOCTABLE_NAME_LEN
• Summary of WPG_DOCLOAD Subprograms
  • DOWNLOAD_FILE Procedures

182 ANYDATA TYPE

• Using ANYDATA TYPE
  • Restrictions
  • Operational Notes
    • Construction
    • Access
• Summary of ANYDATA Subprograms
  • BEGINCREATE Static Procedure
  • ENDCREATE Member Procedure
  • GET* Member Functions
  • GETTYPE Member Function
  • GETTYPENAME Member Function
  • PIECEWISE Member Procedure
  • SET* Member Procedures

183 ANYDATASET TYPE

• Construction
• Summary of ANYDATASET TYPE Subprograms
  • ADDINSTANCE Member Procedure
  • BEGINCREATE Static Procedure
  • ENDCREATE Member Procedure
  • GET* Member Functions
  • GETCOUNT Member Function
  • GETINSTANCE Member Function
  • GETTYPE Member Function
  • GETTYPENAME Member Function
  • PIECEWISE Member Procedure
  • SET* Member Procedures

184 ANYTYPE TYPE

• Summary of ANYTYPE Subprograms
  • BEGINCREATE Static Procedure
  • SETINFO Member Procedure
  • ADDATTR Member Procedure
  • ENDCREATE Member Procedure
  • GETPERSISTENT Static Function
  • GETINFO Member Function
  • GETATTRELEMINFO Member Function

185 Oracle Streams AQ TYPEs

• Summary of Types
  • AQ$_AGENT Type
  • AQ$_AGENT_LIST_T Type
  • AQ$_DESCRIPTOR Type
  • AQ$_NTFN_DESCRIPTOR Type
  • AQ$_POST_INFO Type
  • AQ$_POST_INFO_LIST Type
  • AQ$_PURGE_OPTIONS_T Type
  • AQ$_RECIPIENT_LIST_T Type
  • AQ$_REG_INFO Type
  • AQ$_REG_INFO_LIST Type
  • AQ$_SUBSCRIBER_LIST_T Type
  • DEQUEUE_OPTIONS_T Type
  • ENQUEUE_OPTIONS_T Type
  • SYS.MSG_PROP_T Type
  • MESSAGE_PROPERTIES_T Type
  • MESSAGE_PROPERTIES_ARRAY_T Type
  • MSGID_ARRAY_T Type

186 Database URI TYPEs

• Summary of URITYPE Supertype Subprograms
  • GETBLOB
  • GETCLOB
  • GETCONTENTTYPE
  • GETEXTERNALURL
  • GETURL
  • GETXML
• Summary of HTTPURITYPE Subtype Subprograms
  • CREATEURI
  • GETBLOB
  • GETCLOB
  • GETCONTENTTYPE
  • GETEXTERNALURL
  • GETURL
  • GETXML
  • HTTPURITYPE
• Summary of DBURITYPE Subtype Subprogams
  • CREATEURI
  • DBURITYPE
  • GETBLOB
  • GETCLOB
  • GETCONTENTTYPE
  • GETEXTERNALURL
  • GETURL
  • GETXML
• Summary of XDBURITYPE Subtype Subprograms
  • CREATEURI
  • GETBLOB
  • GETCLOB
  • GETCONTENTTYPE
  • GETEXTERNALURL
  • GETURL
  • GETXML
  • XDBURITYPE
• Summary of URIFACTORY Package Subprograms
  • GETURI
  • ESCAPEURI
  • UNESCAPEURI
  • REGISTERURLHANDLER
  • UNREGISTERURLHANDLER

187 Expression Filter Types

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

188 JMS Types

• Using JMS Types
  • Overview
  • Java Versus PL/SQL Data Types
    • New JMS Support in Oracle Database 10g
  • More on Bytes, Stream and Map Messages
    • Using Java Stored Procedures to Encode and Decode Oracle Streams AQ Messages
    • Initialize the Jserv Static Variable
    • Get the Payload Data Back to PL/SQL
    • Garbage Collect the Static Variable
    • Use a Message Store: A Static Variable Collection
    • Typical Calling Sequences
    • Read-Only and Write-Only Modes Enforced for Stream and Bytes Messages
    • Differences Between Bytes and Stream Messages
    • Getting and Setting Bytes, Map, and Stream Messages as RAW Bytes
  • Upcasting and Downcasting Between General and Specific Messages
  • JMS Types Error Reporting
  • Oracle JMS Type Constants
  • CONVERT_JMS_SELECTOR
    • Convert with Minimal Specification
    • Convert with Destination Payload Type Specified
    • Convert with Destination Payload Type and Compliant Mode Specified
• Summary of JMS Types
  • SYS.AQ$_JMS_MESSAGE Type
    • CONSTRUCT Static Functions
    • Cast Methods
    • JMS Header Methods
    • System Properties Methods
    • User Properties Methods
    • Payload Methods
  • SYS.AQ$_JMS_TEXT_MESSAGE Type
    • CONSTRUCT Function
    • JMS Header Methods
    • System Properties Methods
    • User Properties Methods
    • Payload Methods
  • SYS.AQ$_JMS_BYTES_MESSAGE Type
    • CONSTRUCT Function
    • JMS Header Methods
    • System Properties Methods
    • User Properties Methods
    • Payload Methods
  • SYS.AQ$_JMS_MAP_MESSAGE Type
    • CONSTRUCT Function
    • JMS Header Methods
    • System Properties Methods
    • User Properties Methods
    • Payload Methods
  • SYS.AQ$_JMS_STREAM_MESSAGE Type
    • CONSTRUCT Function
    • JMS Header Methods
    • System Properties Methods
    • User Properties Methods
    • Payload Methods
  • SYS.AQ$_JMS_OBJECT_MESSAGE Type
  • SYS.AQ$_JMS_NAMESARRAY Type
  • SYS.AQ$_JMS_VALUE Type
  • SYS.AQ$_JMS_EXCEPTION Type

189 Logical Change Record TYPEs

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

190 interMedia ORDAudio TYPE

• Documentation of ORDAudio

191 interMedia ORDDoc TYPE

• Documentation of ORDDoc

192 interMedia ORDImage TYPE

• Documentation of ORDImage

193 interMedia ORDImageSignature TYPE

• Documentation of ORDImageSignature

194 interMedia SQL/MM Still Image TYPE

• Documentation of SQL/MM Still Image

195 interMedia ORDVideo TYPE

• Documentation of ORDVideo

196 Rules Manager Types

• Summary of Rule Manager Types
  • RLM$EVENTIDS Object Type

197 Rule TYPEs

• Summary of Rule Types
  • RE$ATTRIBUTE_VALUE Type
  • RE$ATTRIBUTE_VALUE_LIST Type
  • RE$COLUMN_VALUE Type
  • RE$COLUMN_VALUE_LIST Type
  • RE$NAME_ARRAY Type
  • RE$NV_ARRAY Type
    • Syntax
  • RE$NV_LIST Type
  • RE$NV_NODE Type
  • RE$RULE_HIT Type
  • RE$RULE_HIT_LIST Type
  • RE$TABLE_ALIAS Type
  • RE$TABLE_ALIAS_LIST Type
  • RE$TABLE_VALUE Type
  • RE$TABLE_VALUE_LIST Type
  • RE$VARIABLE_TYPE Type
  • RE$VARIABLE_TYPE_LIST Type
  • RE$VARIABLE_VALUE Type
  • RE$VARIABLE_VALUE_LIST Type

198 XMLTYPE

• Summary of XMLType Subprograms
  • CREATENONSCHEMABASEDXML
  • CREATESCHEMABASEDXML
  • CREATEXML
  • EXISTSNODE
  • EXTRACT
  • GETBLOBVAL
  • GETCLOBVAL
  • GETNAMESPACE
  • GETNUMBERVAL
  • GETROOTELEMENT
  • GETSCHEMAURL
  • GETSTRINGVAL
  • ISFRAGMENT
  • ISSCHEMABASED
  • ISSCHEMAVALID
  • ISSCHEMAVALIDATED
  • SCHEMAVALIDATE
  • SETSCHEMAVALIDATED
  • TOOBJECT
  • TRANSFORM
  • XMLTYPE

Index