Oracle | OWA

Oracle OWA_CACHE Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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