The OWA_CACHE
package provides an interface that enables the PL/SQL
Gateway
cache to improve the performance of PL/SQL web applications.
See Also:
For more information about implementation of this package:The chapter contains the following topics:
system_level
CONSTANT
VARCHAR(6)
:=
'SYSTEM';
user_level
CONSTANT
VARCHAR(4)
:=
'USER';
Table 141-1 OWA_CACHE Package Subprograms
Subprogram | Description |
---|---|
Disables the cache for this particular request |
|
Returns the tag associated with the cached content (used in the Validation technique model only) |
|
Returns the caching level (used in the Validation technique model only) |
|
Sets up the cache headers for validation model cache type |
|
Sets up the cache headers for expires model cache type |
|
Sets up the headers for a not modified cache hit (used in the Validation technique model only) |
|
Sets up the headers for a surrogate-control header for web cache |
This procedure disables the cache for this particular request.
OWA_CACHE.DISABLE;
This function returns the tag associated with the cached content. It is used in the Validation technique only.
OWA_CACHE.GET_ETAG RETURN VARCHAR2;
The tag for cache hit, otherwise NULL
.
This returns the caching level. It is used in the Validation technique model only.
OWA_CACHE.GET_LEVEL RETURN VARCHAR2;
The caching level string ('USER
' or 'SYSTEM
') for cache hit, otherwise NULL
.
This sets up the cache headers for validation model cache type.
OWA_CACHE.SET_CACHE( p_etag IN VARCHAR2, p_level IN VARCHAR2);
Table 141-2 SET_CACHE Procedure Parameters
Parameter | Description |
---|---|
|
The |
|
The caching level (' |
VALUE_ERROR
is thrown if
p_etag
is greater than 55
p_level
is not 'USER
' or 'SYSTEM
'
This procedure sets up the cache headers for expires model cache type.
OWA_CACHE.SET_EXPIRES( p_expires IN NUMBER, p_level IN VARCHAR2);
Table 141-3 SET_EXPIRES Procedure Parameters
Parameter | Description |
---|---|
|
The number of minutes this content is valid. |
|
The caching level (' |
VALUE_ERROR
is thrown if
p_expires
is negative or zero
p_level
is not 'USER
' or 'SYSTEM
'
p_expires
is > 525600 (1 year)
This procedure sets up the headers for a not-modified cache hit. It is used in the Validation technique only.
OWA_CACHE.SET_NOT_MODIFIED;
VALUE_ERROR
is thrown if If the etag
was not passed in
This procedure sets the headers for a surrogate-control header for web cache
OWA_CACHE.SET_SURROGATE_CONTROL( p_value IN VARCHAR2);
Table 141-4 SET_SURROGATE_CONTROL Procedure Parameters
Parameter | Description |
---|---|
|
The value to be passed as the Surrogate-Control header. |
VALUE_ERROR
is thrown if If p_value is greater than 55 in length.