Web client function and procedure requirements and recommendations

Web service client procedures and functions require the definition of a URL clause to identify the web service endpoint. A web service client procedure or function has specialized clauses for configuration but is used like any other stored procedure or function in every other respect.

You can use the CREATE PROCEDURE and CREATE FUNCTION statements to create web client functions and procedures to send SOAP or HTTP requests to a web server.

The following list outlines the requirements and recommendations for creating or altering web client functions and procedures. You can specify the following information when creating or altering a web client function or procedure:

  • The URL clause, which requires an absolute URL specifying the web service endpoint. (Required)

  • The TYPE clause to specify whether the request is HTTP or SOAP over HTTP. (Recommended)

  • Ports that are accessible to the client application. (Optional)

  • The HEADER clause to specify HTTP request headers. (Optional)

  • The SOAPHEADER clause to specify SOAP header criteria within the SOAP request envelope. (Optional. For SOAP requests only)

  • The namespace URI. (For SOAP requests only)


Web client URL clause
Web service request types
Web client ports
HTTP request header management
SOAP request header management
SOAP namespace URI requirement
Web client SQL statements