Use of Oracle DBMS packages and other packages

Http://space.itpub.net/90618/viewspace-630651

 

 

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