Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEAPI\apex_util002.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>CACHE_GET_DATE_OF_REGION_CACHE Function</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T17:32:15Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content=" CACHE_GET_DATE_OF_REGION_CACHE Function" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12510-01" /> <link rel="copyright" href="../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="../dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface" title="Home" type="text/html" /> <link rel="up" href="apex_util.htm" title="APEX_UTIL" type="text/html" /> <link rel="up" href="apex_util002.htm" title="CACHE_GET_DAT..." type="text/html" /> <link rel="prev" href="apex_util001.htm" title="Previous" type="text/html" /> <link rel="next" href="apex_util003.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > <a href="apex_util.htm" title="APEX_UTIL">APEX_UTIL</a> > CACHE_GET_DAT...</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="apex_util001.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util003.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDFCGDF" name="CHDFCGDF"></a></p> <hr /> <div class="refsect1"> <h1><a name="AEAPI104" id="AEAPI104"></a> CACHE_GET_DATE_OF_REGION_CACHE <a id="sthref15" name="sthref15"></a>Function</h1> <p>This function returns the date and time a specified region was cached either for the user issuing the call, or for all users if the page was not set to be cached by user.</p> <a id="sthref16" name="sthref16"></a> <p class="subhead2">Syntax</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_UTIL.CACHE_GET_DATE_OF_REGION_CACHE ( p_application IN NUMBER, p_page IN NUMBER, p_region_name IN VARCHAR2) RETURN DATE; </pre> <a id="sthref17" name="sthref17"></a> <p class="subhead2">Parameters</p> <p><a href="#CHDJHJFG">Table: CACHE_GET_DATE_OF_REGION_CACHE Parameters</a> describes the parameters available in the <code>CACHE_GET_DATE_OF_REGION_CACHE</code> function.</p> <div class="tblformal"><a id="sthref18" name="sthref18"></a><a id="CHDJHJFG" name="CHDJHJFG"></a> <p class="titleintable">CACHE_GET_DATE_OF_REGION_CACHE Parameters</p> <table class="Formal" title="CACHE_GET_DATE_OF_REGION_CACHE Parameters" summary="This table describes the parameters available in the CACHE_GET_DATE_OF_REGION_CACHE procedure." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="31%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t3">Parameter</th> <th align="left" valign="bottom" id="r1c2-t3">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t3" headers="r1c1-t3"> <p><code>p_application</code></p> </td> <td align="left" headers="r2c1-t3 r1c2-t3"> <p>The identification number (ID) of the application</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t3" headers="r1c1-t3"> <p><code>p_page</code></p> </td> <td align="left" headers="r3c1-t3 r1c2-t3"> <p>The page number (ID)</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t3" headers="r1c1-t3"> <p><code>p_region_name</code></p> </td> <td align="left" headers="r4c1-t3 r1c2-t3"> <p>The region name</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <a id="sthref19" name="sthref19"></a> <p class="subhead2">Example</p> <p>The following example demonstrates how to use the <code>CACHE_GET_DATE_OF_REGION_CACHE</code> function to retrieve the cache date and time for the region named Cached Region on page 13 of the currently executing application. If the region has been cached, the cache date and time is output using the HTP package. The region could have been cached either by the user issuing the call, or for all users if the page was not to be cached by user.</p> <pre xml:space="preserve" class="oac_no_warn"> DECLARE l_cache_date DATE DEFAULT NULL; BEGIN l_cache_date := APEX_UTIL.CACHE_GET_DATE_OF_REGION_CACHE( p_application => :APP_ID, p_page => 13, p_region_name => 'Cached Region'); IF l_cache_date IS NOT NULL THEN HTP.P('Cached on ' || TO_CHAR(l_cache_date, 'DD-MON-YY HH24:MI:SS')); END IF; END; </pre></div> <!-- class="refsect1" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="../dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="apex_util001.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util003.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de