Oracle | OWA

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	INIT	SET_NOT_MODIFIED
GET_ETAG	SET_CACHE	SET_SURROGATE_CONTROL
GET_LEVEL	SET_EXPIRES

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