37 APEX_WEB_SERVICE
The APEX_WEB_SERVICE API enables you to integrate other systems with Application Express by allowing 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. It contains functions to parse the responses from Web services and to 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
- Invoking a SOAP Style Web Service
- Invoking a RESTful Style Web Service
- Retrieving Cookies and HTTP Headers
- Setting Cookies and HTTP Headers
- BLOB2CLOBBASE64 Function
- CLOBBASE642BLOB Function
- MAKE_REQUEST Procedure
- MAKE_REQUEST Function
- MAKE_REST_REQUEST Function
- MAKE_REST_REQUEST_B Function
- OAUTH_AUTHENTICATE Procedure Signature 1
- OAUTH_AUTHENTICATE Procedure Signature 2
- OAUTH_GET_LAST_TOKEN Function
- OAUTH_SET_TOKEN Procedure
- PARSE_RESPONSE Function
- PARSE_RESPONSE_CLOB Function
- PARSE_XML Function
- PARSE_XML_CLOB Function