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

When used within a stored procedure that is called by an HTTP web service, the following example processes all the keys located in the SOAP request header. 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;