| General Information |
| Purpose |
Wrapper for calls to put or get an HTTP_COOKIE |
| Source |
{ORACLE_HOME}/rdbms/admin/pubcook.sql |
| First Availability |
8.1.7 |
| 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 |
WWV_FLOW_LOGIN |
| OWA_CUSTOM |
WWV_FLOW_ASFCOOKIE |
WWV_FLOW_SECURITY |
| OWA_CX |
WWV_FLOW_CUSTOM_AUTH_STD |
WWV_FLOW_UTILITIES |
| OWA_UTIL |
|
|
|
| Security Model |
Owned by SYS with no privileges granted |
| |
| 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); |
BEGIN
owa_util.mime_header('text/html', FALSE);
owa_cookie.send('UWCOOKIE','Oracle', SYSDATE+30);
END;
/ |
