GETCOOKI: Retrieving a Browser Cookie Value

How to:

Security credentials for WebFOCUS can come from many sources and be provided in several different formats. Some security credentials from third-party single sign-on products are passed to WebFOCUS in the form of a browser cookie. The WebFOCUS Reporting Server can use the GETCOOKI function to retrieve the value of a browser cookie passed to it by the WebFOCUS Client.


Top of page

x
Syntax: How to Retrieve a Cookie Value
GETCOOKI('cookie_name', output)

where:

cookie_name

Alphanumeric

Is the name of the browser cookie whose value is being retrieved. The maximum length of the cookie name is 80 bytes. If the cookie is not set or its name exceeds 80 characters, the function will return Invalid Cookie Name.

length

Alphanumeric (An)

Is the length of the cookie. It can be the name of the field that contains the result, or the format of the output value enclosed in single quotation marks. If the length n specified is greater than the actual length of the retrieved cookie, the result will be padded with blanks. It is always recommended to use the function TRUNCATE(arg1) on return from GETCOOKI to remove extra trailing blanks.



Example: Retrieving the Value of a Browser Cookie

The following function call retrieves the value of the ObSSOCookie created by Oracle Access manager (formerly Oblix):

GETCOOKI('ObSSOCookie', 'A400')

WebFOCUS