Oracle 12cR2 OWA

Oracle OWA_COOKIE Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.

Purpose Wrapper for calls to put or get an HTTP_COOKIE

AUTHID DEFINER

Data Types TYPE vc_arr IS TABLE OF VARCHAR2(4096) INDEX BY BINARY_INTEGER; TYPE cookie IS RECORD ( name VARCHAR2(4096), vals vc_arr, num_vals INTEGER);

Dependencies

HTP	WWV_FLOW_ASFCOOKIE	WWV_FLOW_DEBUG
OWA_CUSTOM	WWV_FLOW_AUTHENTICATION	WWV_FLOW_F4000_PLUGINS
OWA_UTIL	WWV_FLOW_AUTHENTICATION_API	WWV_FLOW_LANG

Documented No

First Available 8.1.7

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/pubcook.sql

Subprograms

GET	INIT	SEND
GET_ALL	REMOVE

GET

Returns the value for the specified cookie owa_cookie.get(name IN VARCHAR2) RETURN cookie;

DECLARE

       ourcookie owa_cookie.cookie;

      BEGIN

        ourCookie := owa_cookie.get('UWCOOKIE');

      END;

      /

GET_ALL

Returns an array of name-value pairs of all HTTP Cookies sent from the browser owa_cookie.get_all( names OUT vc_arr, vals OUT vc_arr, num_vals OUT INTEGER);

set serveroutput on

      

      DECLARE

       name_arr owa_cookie.vc_arr;

       vals_arr owa_cookie.vc_arr;

       vals_ret INTEGER;

      BEGIN

        owa_cookie.get_all(name_arr, vals_arr, vals_ret);

        dbms_output.put_line(vals_ret);

      END;

      /

INIT

Initializes package variables owa_cookie.init;

exec owa_cookie.init;

REMOVE

Forces the expiration of an existing cookie owa_cookie.remove( name IN VARCHAR2, val IN VARCHAR2, path IN VARCHAR2 DEFAULT NULL);

exec owa_cookie.remove('UWCOOKIE', '1');

SEND

Generates an HTTP header line in the form:
Set-Cookie: <name>=<value> expires=<expires> path=<path>
domain=<domain> [secure] owa_cookie.send( name IN VARCHAR2, value IN VARCHAR2, expires IN DATE DEFAULT NULL, path IN VARCHAR2 DEFAULT NULL, domain IN VARCHAR2 DEFAULT NULL, secure IN VARCHAR2 DEFAULT NULL, httponly IN VARCHAR2 DEFAULT NULL);

BEGIN

        owa_util.mime_header('text/html', FALSE);

        owa_cookie.send('UWCOOKIE','Oracle', SYSDATE+30);

      END;

      /