Oracle | OWA

Oracle OWA_CACHE Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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;

           *

      ORA-06502: PL/SQL: numeric or value error

      

      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;

            
      *

      ORA-06502: PL/SQL: numeric or value error

GET_LEVEL

Returns the caching level (used in the Validation technique model only) owa_cache.get_level RETURN VARCHAR2;

SELECT owa_cache.get_level;

             *

      ORA-06502: PL/SQL: numeric or value error

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');

           *

      ORA-06502: PL/SQL: numeric or value error

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');

           *

      ORA-06502: PL/SQL: numeric or value error

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;

           *

      ORA-06502: PL/SQL: numeric or value error

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');

           *

      ORA-06502: PL/SQL: numeric or value error