CREATE OR REPLACE PROCEDURE User1.HTTPHeaderExample()
RESULT ( html_string LONG VARCHAR )
BEGIN
    DECLARE myname VARCHAR(255);
    DECLARE myvalue LONG VARCHAR;
    DECLARE err_notfound
        EXCEPTION FOR SQLSTATE '02000';
    DECLARE curs CURSOR FOR 
        SELECT Name, Value FROM sa_http_header_info();
    MESSAGE '=== HTTP Headers ===' TO CONSOLE;
    OPEN curs;
    FetchLoop: LOOP
        FETCH next curs INTO myname, myvalue;
        IF SQLSTATE = err_notfound THEN
            LEAVE FetchLoop;
        END IF;
        MESSAGE myname, '=', myvalue TO CONSOLE;
    END LOOP FetchLoop;
    CLOSE curs;
END;

=== HTTP Headers ===
@HttpQueryString=param1=value1&param2=value2&param3=value3
User-Agent=Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0
Authorization=Basic VXNlcjE6dXNlcg==
Cache-Control=max-age=0
Connection=keep-alive
Host=schueler-t3500.sybase.com:8082
@HttpURI=/ShowHTTPHeaders?param1=value1&param2=value2&param3=value3
@HttpMethod=GET
Accept=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
@HttpVersion=HTTP/1.1
Accept-Language=en-US,en;q=0.5
Accept-Encoding=gzip, deflate