PL/SQL Packages UTL_HTTP

Access data on the Internet over HTTP (Hypertext Transfer Protocol) callouts, it also supports HTTP over the Secured Socket Layer protocol (SSL), also known as HTTPS.

Subprocedures:

 REQUEST Function
 REQUEST_PIECES Function
 
Session Settings
 SET_PROXY Procedure
 GET_PROXY Procedure
 SET_COOKIE_SUPPORT Procedure
 GET_COOKIE_SUPPORT Procedure
 SET_FOLLOW_REDIRECT Procedure
 GET_FOLLOW_REDIRECT Procedure
 SET_BODY_CHARSET Procedure
 GET_BODY_CHARSET Procedure
 SET_PERSISTENT_CONN_SUPPORT Procedure
 GET_PERSISTENT_CONN_SUPPORT Procedure
 SET_RESPONSE_ERROR_CHECK Procedure
 GET_RESPONSE_ERROR_CHECK Procedure
 SET_DETAILED_EXCP_SUPPORT Procedure
 GET_DETAILED_EXCP_SUPPORT Procedure
 SET_WALLET Procedure
 SET_TRANSFER_TIMEOUT Procedure
 GET_TRANSFER_TIMEOUT Procedure
 
HTTP Requests
 BEGIN_REQUEST Function
 SET_HEADER Procedure
 SET_AUTHENTICATION Procedure
 SET_COOKIE_SUPPPORT Procedure
 SET_FOLLOW_REDIRECT Procedure
 SET_BODY_CHARSET Procedure
 SET_PERSISTENT_CONN_SUPPORT Procedure
 WRITE_TEXT Procedure
 WRITE_LINE Procedure
 WRITE_RAW Procedure
 END_REQUEST Procedure
 
HTTP Responses
 GET_RESPONSE Function
 GET_HEADER_COUNT Function
 GET_HEADER Procedure
 GET_HEADER_BY_NAME Procedure
 GET_AUTHENTICATION Procedure
 SET_BODY_CHARSET Procedure
 READ_TEXT Procedure
 READ_LINE Procedure
 READ_RAW Procedure
 END_RESPONSE Procedure
 
HTTP Cookies
 GET_COOKIE_COUNT Function
 GET_COOKIES Function
 ADD_COOKIES Procedure
 CLEAR_COOKIES Procedure
 
HTTP Persistent Connections
 GET_PERSISTENT_CONN_COUNT Function
 GET_PERSISTENT_CONNS Procedure
 CLOSE_PERSISTENT_CONN Procedure
 CLOSE_PERSISTENT_CONNS Procedure
 
Error Conditions
 GET_DETAILED_SQLCODE Function
 GET_DETAILED_SQLERRM Function
  

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al


 
Copyright © 1999-2024 SS64.com
Some rights reserved