Re: PLSQL: Preventing Cache? (HTTP headers?)

Robert Finlayson wrote:

> Hi All,
>
> Old age problem: Preventing caching in PLSQL generated pages.
>
> I need to add these three headers to my PLSQL generated pages, so to stop
> the pages being access through the cache.
>
> CacheControl = "no-cache"
> Pragma = "no-cache"
> Expires = -1
>
> The only problem is I cannot find a procedure/funtion in the htp package
> which can add custom HTTP headers (like the ones above - "meta" and "header"
> in the package does not relate to the HTTP Header.).
>
> Simply adding these headers to the html inside the "META HTTP-EQUIV" tags
> does not solve the problem, as meta tags are not evaluated until after
> downloaded files have already been stored in the cache (MS KB199805). The
> headers need to be placed within the HTTP Headers.
>
> My preferred solution would be to find a method to add custom http headers
> via PLSQL (how is everyone else controling cache?). However, is this only
> possible by altering settings on the webserver? (we have OASv4).
>
> Any help/suggestions accepted :)
>
> Many thanks,
>
> Robert.
>
> Tech Details:
> - OASv4 on Unix
> - DBv8.0.4.0

See the owa_util.mime_header procedure

--
   Boychouk Alexander
   Programmer
   INT Ltd., http://www.int.kiev.ua
   13 Sichnevogo Povstannia str.
   Kiev, Ukraine
   ph. (38044) 290-7431, 294-8310, fax 290-8934
   e-mail: mailto:agb_at_int.kiev.ua