NEXT_SOAP_HEADER( header-key )

LONG VARCHAR

If you specify NULL for the header-key, the function returns the header key for the first header entry found in the SOAP header.

This function returns NULL if called with the last header-key.

• SOAP_HEADER function [SOAP]
• Tutorial: Using SQL Anywhere to access a SOAP/DISH service
• Web services functions
• Web services system procedures

The following statement processes all the keys located in the SOAP request header when used within a stored procedure that is called by an HTTP web service. When it processes the Authentication key, it also obtains the key's value.

BEGIN
  DECLARE hd_key LONG VARCHAR;
  DECLARE hd_entry LONG VARCHAR;
header_loop:
  LOOP
    SET hd_key = NEXT_SOAP_HEADER( hd_key );
    IF hd_key IS NULL THEN
      -- no more header entries
      LEAVE header_loop;
    END IF;
    IF hd_key = 'Authentication' THEN
      SET hd_entry = SOAP_HEADER( hd_key );
    END IF;
  END LOOP header_loop;
END;