0 Replies Latest reply: Jun 4, 2013 5:50 AM by Henrie Cuijpers RSS

    mod_plsql adding expires header ???

    Henrie Cuijpers
      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
        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 ); 
      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 and oracle DB

      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