HTTP_RESPONSE_HEADER( header-field-name )

LONG VARCHAR

This function returns the value of the named HTTP response header field, or NULL if a header for the given header-field-name does not exist or if it is not called from an HTTP service.

• NEXT_HTTP_RESPONSE_HEADER function [HTTP]
• sa_set_http_header system procedure
• Accessing client-supplied HTTP variables and headers
• Web services functions
• Web services system procedures

When used within a stored procedure that is called by an HTTP web service, the following example displays the name and values of the HTTP response headers in the database server messages window.

BEGIN
  declare header_name long varchar;
  declare header_value long varchar;
  set header_name  = NULL;
header_loop:
  LOOP
    SET header_name = NEXT_HTTP_RESPONSE_HEADER( header_name );
    IF header_name IS NULL THEN 
      LEAVE header_loop
    END IF;
    SET header_value = HTTP_RESPONSE_HEADER( header_name );
    MESSAGE 'RESPONSE HEADER: ', header_name, '=', header_value TO CONSOLE;
  END LOOP;