Hi all,
i'm developing mod_plsql applications since a long time.. I use the document-procedure to fetch a document in a complex way, but at the end it is a sort of
procedure myDocumentProc is
...
begin
sPathInfo := owa_util.get_cgi_env('PATH_INFO');
..
do some nice stuff to get a nDocnr and check autorisation...
when everything is ok:
..
select blob_content,mime_type into bLob,sMime from myBlobTable where doc=nDocnr;
owa_util.mime_header( sMime );
.... point X
wpg_docload.download_file( bLob );
end;
What i'm experiencing is that if PATH_INFO contains .png or .jpg (maybe there are more extensions) there is automagicly added a Expires: header to the response....
Can someone confirm this, and better: how can i TURN THIS OFF??? please!!
I would like to turn this of because at point X in the code i would like to calculate and add an Expires header myself. I know exactly how long I would like a certain file to be cached. What happens at this moment that when i add an Expires header, most of the request return fine, but when mod_plsql (is it mod_plsql???) does its little magic i end up with an Expires header with two dates in it. Which is wrong....
Example Wrong header:
Expires: Tue, 11 Jun 2013 10:26:53 GMT, Tue, 04 Jun 2013 18:26:53 GMT
The first date is the one i calculated and added as a header, the second date is the date added by some magic.... somewhere...
BTW this is on a webtier 11.1.1.6 and oracle DB 11.2.0.3.0
i'm running the webtier only:
./opmnctl status
Processes in Instance: instance1
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
ohs1 | OHS | 31505 | Alive
and the PlsqlCacheEnable is set to Off
Edited by: hcHoep on Jun 4, 2013 12:50 PM