Oracle OWA_CACHE
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 Provides cache functions for caching PL/SQL generated output
AUTHID DEFINER
Constants
Name Data Type Value
General
system_level VARCHAR2(6) 'SYSTEM'
user_level VARCHAR2(4) 'USER'
Dependencies
HTP OWA_CX OWA_UTIL
Documented Yes
First Available Not known
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/pubcach.sql
Subprograms
 
DISABLE
Disables the cache owa_cache.disable;
exec owa_cache.disable;
BEGIN owa_cache.disable; END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 354
ORA-06512: at "SYS.HTP", line 1362
ORA-06512: at "SYS.HTP", line 1790
ORA-06512: at "SYS.OWA_CACHE", line 66
ORA-06512: at line 1


SELECT text FROM dba_source WHERE name = 'OWA_UTIL' AND line = 354;

TEXT
-------------------------------------------------------------------------
/* You would save the offset within the query in a hidden field to */
for i in 1..owa.num_cgi_vars
 
GET_ETAG
Returns the tag associated with the cached content (used in the Validation technique model only) owa_cache.get_etag RETURN VARCHAR2;
SELECT owa_cache.get_etag
FROM dual;
SELECT owa_cache.get_etag
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 354
ORA-06512: at "SYS.OWA_CACHE", line 227
 
GET_LEVEL
Returns the caching level (used in the Validation technique model only) owa_cache.get_level RETURN VARCHAR2;
SELECT owa_cache.get_level
FROM dual;
SELECT owa_cache.get_level
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 354
ORA-06512: at "SYS.OWA_CACHE", line 207
 
INIT
Cache Initialization: Should only be called before any data is written to the htbuf owa_cache.init(
p_htbuf   IN OUT NOCOPY sys.htp.htbuf_arr,
p_rows_in IN OUT        NUMBER);
DECLARE
 bufarray htp.htbuf_arr;
 n        NUMBER := 10;
BEGIN
  bufarray(1) := 'UWBUF';

  owa_cache.init(bufarray, n);
  dbms_output.put_line(bufarray(1));
  dbms_output.put_line(n);
END;
/
X-ORACLE-IGNORE: IGNORE

4

PL/SQL procedure successfully completed.
 
SET_CACHE
Sets up the cache headers for validation model cache type owa_cache.set_cache(
p_etag  IN VARCHAR2,
p_level IN VARCHAR2);
exec owa_cache.set_cache('UWTAG', 'SYSTEM');
BEGIN owa_cache.set_cache('UWTAG', 'SYSTEM'); END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 354
ORA-06512: at "SYS.HTP", line 1362
ORA-06512: at "SYS.HTP", line 1790
ORA-06512: at "SYS.OWA_CACHE", line 143
ORA-06512: at line 1
 
SET_EXPIRES
Sets the number of minutes a cached item is considered fresh owa_cache.set_expires(
p_expires IN NUMBER,
p_level   IN VARCHAR2);
exec owa_cache.set_expires(10, 'SYSTEM');
BEGIN owa_cache.set_expires(10, 'SYSTEM'); END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 354
ORA-06512: at "SYS.HTP", line 1362
ORA-06512: at "SYS.HTP", line 1790
ORA-06512: at "SYS.OWA_CACHE", line 108
ORA-06512: at line 1
 
SET_NOT_MODIFIED
sets up the headers for a not-modified cache hit. It is used in the Validation technique only. owa_cache.set_not_modified;
exec owa_cache.set_not_modified;
BEGIN owa_cache.set_not_modified; END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 354
ORA-06512: at "SYS.OWA_CACHE", line 227
ORA-06512: at "SYS.OWA_CACHE", line 161
ORA-06512: at line 1
 
SET_SURROGATE_CONTROL
Sets the headers for a surrogate-control header for Web cache owa_cache.set_surrogate_control(p_value IN VARCHAR2);
exec owa_cache.set_surrogate_control('Header LT 55 bytes');
BEGIN owa_cache.set_surrogate_control('Header < 55 bytes'); END;
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 354
ORA-06512: at "SYS.HTP", line 1362
ORA-06512: at "SYS.HTP", line 1790
ORA-06512: at "SYS.OWA_CACHE", line 189
ORA-06512: at line 1

Related Topics
Built-in Functions
Built-in Packages
Database Security
OWA_CACHE
OWA_COOKIE
OWA_CUSTOM
OWA_CX
OWA_OPT_LOCK
OWA_PATTERN
OWA_SEC
OWA_TEXT
OWA_UTIL
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx