oracle dbms包和其他包的使用大全

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

 

 

161SDO_TOPO_MAP

• Documentation of SDO_TOPO_MAP

162SDO_TUNE

• Documentation of SDO_TUNE

163SDO_UTIL

• Documentation of SDO_UTIL

164UTL_COLL

• Summary of UTL_COLL Subprograms
  • IS_LOCATOR Function
    • Examples

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

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

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

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

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