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
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
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
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
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
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
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
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