Contents

Title and Copyright Information

Preface

• Audience
• Related Documents
• Conventions
• Documentation Accessibility

What's New

• New features in Release 11.2.2.5.0
• New features in Release 11.2.2.1.0

1 Introduction to TimesTen-Supplied PL/SQL Packages and Types

• Package overview
  • Package components
  • Using TimesTen-supplied packages
  • Referencing package contents
  • Running package examples
• Summary of TimesTen-supplied PL/SQL packages

2 DBMS_LOB

• Using DBMS_LOB
  • Overview
  • Security model
  • Constants
  • Data types
  • Rules and limits
    • General rules and limits
    • Maximum LOB size
    • Maximum buffer size
  • Operational notes
    • Persistent LOBs
    • Temporary LOBs
  • Exceptions
• Summary of DBMS_LOB subprograms
  • APPEND procedures
  • CLOSE procedures
  • COMPARE functions
  • CONVERTTOBLOB procedure
  • CONVERTTOCLOB procedure
  • COPY procedures
  • CREATETEMPORARY procedures
  • ERASE procedures
  • FREETEMPORARY procedures
  • GETCHUNKSIZE functions
  • GETLENGTH functions
  • GET_STORAGE_LIMIT functions
  • INSTR functions
  • ISOPEN functions
  • ISTEMPORARY functions
  • OPEN procedures
  • READ procedures
  • SUBSTR functions
  • TRIM procedures
  • WRITE procedures
  • WRITEAPPEND procedures

3 DBMS_LOCK

• Using DBMS_LOCK
• Summary of DBMS_LOCK subprograms
  • SLEEP procedure

4 DBMS_OUTPUT

• Using DBMS_OUTPUT
  • Overview
  • Operational notes
  • Rules and limits
  • Exceptions
  • Examples
• Data structures
  • CHARARR table type
  • DBMSOUTPUT_LINESARRAY table type
• Summary of DBMS_OUTPUT subprograms
  • DISABLE procedure
  • ENABLE procedure
  • GET_LINE procedure
  • GET_LINES procedure
  • NEW_LINE procedure
  • PUT procedure
  • PUT_LINE procedure

5 DBMS_PREPROCESSOR

• Using DBMS_PREPROCESSOR
  • Overview
  • Operational notes
• Data structures
  • SOURCE_LINES_T table type
• Summary of DBMS_PREPROCESSOR subprograms
  • GET_POST_PROCESSED_SOURCE function
  • PRINT_POST_PROCESSED_SOURCE procedure

6 DBMS_RANDOM

• Using DBMS_RANDOM
  • Operational notes
• Summary of DBMS_RANDOM subprograms
  • INITIALIZE procedure
  • NORMAL function
  • RANDOM function
  • SEED procedure
  • STRING function
  • TERMINATE procedure
  • VALUE function

7 DBMS_SQL

• Using DBMS_SQL
  • Overview
  • Security model
  • Constants
  • Operational notes
    • Execution flow
    • Processing queries
    • Processing updates, inserts, and deletes
    • Locating errors
  • Exceptions
  • Examples
• Data structures
  • DESC_REC record type
  • DESC_REC2 record type
  • DESC_REC3 record type
  • BINARY_DOUBLE_TABLE table type
  • BINARY_FLOAT_TABLE table type
  • BLOB_TABLE table type
  • CLOB_TABLE table type
  • DATE_TABLE table type
  • DESC_TAB table type
  • DESC_TAB2 table type
  • DESC_TAB3 table type
  • INTERVAL_DAY_TO_SECOND_TABLE table type
  • INTERVAL_YEAR_TO_MONTH_TABLE table type
  • NUMBER_TABLE table type
  • TIME_TABLE table type
  • TIMESTAMP_TABLE table type
  • VARCHAR2_TABLE table type
  • VARCHAR2A table type
  • VARCHAR2S table type
• Summary of DBMS_SQL subprograms
  • BIND_ARRAY procedure
  • BIND_VARIABLE procedure
  • CLOSE_CURSOR procedure
  • COLUMN_VALUE procedure
  • DEFINE_ARRAY procedure
  • DEFINE_COLUMN procedure
  • DESCRIBE_COLUMNS procedure
  • DESCRIBE_COLUMNS2 procedure
  • DESCRIBE_COLUMNS3 procedure
  • EXECUTE function
  • EXECUTE_AND_FETCH function
  • FETCH_ROWS function
  • IS_OPEN function
  • LAST_ERROR_POSITION function
  • LAST_ROW_COUNT function
  • LAST_ROW_ID function
  • LAST_SQL_FUNCTION_CODE function
  • OPEN_CURSOR function
  • PARSE procedures
  • TO_CURSOR_NUMBER function
  • TO_REFCURSOR function
  • VARIABLE_VALUE procedure

8 DBMS_UTILITY

• Using DBMS_UTILITY
  • Security model
  • Constants
  • Data types
    • dblink_array
    • index_table_type
    • instance_record
    • lname_array
    • name_array
    • number_array
    • uncl_array
  • Exceptions
• Summary of DBMS_UTILITY subprograms
  • CANONICALIZE procedure
  • COMMA_TO_TABLE procedure
  • COMPILE_SCHEMA procedure
  • DB_VERSION procedure
  • FORMAT_CALL_STACK function
  • FORMAT_ERROR_BACKTRACE function
  • FORMAT_ERROR_STACK function
  • GET_CPU_TIME function
  • GET_DEPENDENCY procedure
  • GET_ENDIANNESS function
  • GET_HASH_VALUE function
  • GET_SQL_HASH function
  • GET_TIME function
  • INVALIDATE procedure
  • IS_BIT_SET function
  • NAME_RESOLVE procedure
  • NAME_TOKENIZE procedure
  • TABLE_TO_COMMA procedure
  • VALIDATE procedure

9 TT_DB_VERSION

• Using TT_DB_VERSION
  • Overview
  • Constants
  • Examples

10 TT_STATS

• Using TT_STATS
  • Overview
  • Security model
  • Operational notes
• Summary of TT_STATS subprograms
  • CAPTURE_SNAPSHOT procedure and function
  • DROP_SNAPSHOTS_RANGE procedures
  • GENERATE_REPORT_HTML procedure
  • GENERATE_REPORT_TEXT procedure
  • GET_CONFIG procedures
  • SET_CONFIG procedure
  • SHOW_SNAPSHOTS procedures

11 UTL_FILE

• Using UTL_FILE
  • Security model
  • Operational notes
  • Rules and limits
  • Exceptions
  • Examples
• Data structures
  • FILE_TYPE record type
• 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 procedure
  • IS_OPEN function
  • NEW_LINE procedure
  • PUT procedure
  • PUT_LINE procedure
  • PUT_LINE_NCHAR procedure
  • PUT_NCHAR procedure
  • PUT_RAW procedure
  • PUTF procedure
  • PUTF_NCHAR procedure

12 UTL_IDENT

• Using UTL_IDENT
  • Overview
  • Security model
  • Constants
  • Examples

13 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_NVARCHAR2 function
  • CAST_TO_RAW function
  • CAST_TO_VARCHAR2 function
  • COMPARE function
  • CONCAT function
  • CONVERT function
  • COPIES function
  • LENGTH function
  • OVERLAY function
  • REVERSE function
  • SUBSTR function
  • TRANSLATE function
  • TRANSLITERATE function
  • XRANGE function

14 UTL_RECOMP

• Using UTL_RECOMP
  • Overview
  • Operational notes
  • Examples
• Summary of UTL_RECOMP subprograms
  • RECOMP_PARALLEL procedure
  • RECOMP_SERIAL procedure

Index