Oracle | OWA

Oracle OWA_COOKIE Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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

OWA_CUSTOM

OWA_UTIL

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;

      /