The APEX_WEB_SERVICE API enables you to integrate other systems with APEX by enabling you to interact with Web Services anywhere you can use PL/SQL in your application.

The API contains procedures and functions to call both SOAP and RESTful style Web Services. Functions parse the responses from Web Services and encode/decode into SOAP-friendly base64 encoding.

This API also contains package globals for managing cookies and HTTP headers when calling Web Services whether from the API or by using standard processes of type Web Service. Cookies and HTTP headers can be set before invoking a call to a Web Service by populating the globals and the cookies and HTTP headers returned from the Web Service response can be read from other globals.

• About the APEX_WEB_SERVICE API
  
• About Web Credentials and APEX_WEB_SERVICE
  
• Data Types
  
• Global Variables
  
• APPEND_TO_MULTIPART Procedure Signature 1
  
• APPEND_TO_MULTIPART Procedure Signature 2
  
• BLOB2CLOBBASE64 Function
  
• CLEAR_REQUEST_COOKIES Procedure
  
• CLEAR_REQUEST_HEADERS Procedure
  
• CLOBBASE642BLOB Function
  
• GENERATE_REQUEST_BODY Function
  
• GET_REQUEST_HEADER Function
  
• MAKE_REQUEST Function Signature 1
  
• MAKE_REQUEST Function Signature 2
  
• MAKE_REQUEST Procedure Signature 1
  
• MAKE_REQUEST Procedure Signature 2
  
• MAKE_REST_REQUEST Function
  
• MAKE_REST_REQUEST_B Function
  
• OAUTH_AUTHENTICATE Procedure Signature 1
  
• OAUTH_AUTHENTICATE Procedure Signature 2 (Deprecated)
  
• OAUTH_AUTHENTICATE_CREDENTIAL Procedure
  
• OAUTH_GET_LAST_TOKEN Function
  
• OAUTH_SET_TOKEN Procedure
  
• PARSE_RESPONSE Function
  
• PARSE_RESPONSE_CLOB Function
  
• PARSE_XML Function
  
• PARSE_XML_CLOB Function
  
• REMOVE_REQUEST_HEADER Procedure
  
• SET_REQUEST_ECID_CONTEXT Procedure
  
• SET_REQUEST_HEADERS Procedure