Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEAPI\apex_util074.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>SET_CUSTOM_AUTH_STATUS Procedure</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T17:32:16Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="SET_CUSTOM_AUTH_STATUS Procedure" /> <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_util074.htm" title="SET_CUSTOM_AU..." type="text/html" /> <link rel="prev" href="apex_util073.htm" title="Previous" type="text/html" /> <link rel="next" href="apex_util075.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> > SET_CUSTOM_AU...</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_util073.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util075.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDHHJGJ" name="CHDHHJGJ"></a></p> <hr /> <div class="refsect1"> <h1><a name="AEAPI176" id="AEAPI176"></a>SET_CUSTOM_AUTH_STATUS <a id="sthref389" name="sthref389"></a>Procedure</h1> <p>This procedure can be called from an application's custom authentication function (that is, credentials verification function). The status passed to this procedure is logged in the Login Access Log.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="../AEADM/aadm_activity.htm">"Monitoring Activity within a Workspace"</a> in <a href="../AEADM/preface.htm"><span class="italic">Oracle Application Express Administration Guide</span></a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="sthref390" name="sthref390"></a> <p class="subhead2">Syntax</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_UTIL.SET_CUSTOM_AUTH_STATUS( p_status IN VARCHAR2); </pre> <a id="sthref391" name="sthref391"></a> <p class="subhead2">Parameters</p> <p><a href="#CHDEDBJB">Table: SET_CUSTOM_AUTH_STATUS Parameters</a> describes the parameters available in the <code>SET_CUSTOM_AUTH_STATUS</code> procedure.</p> <div class="tblformal"><a id="sthref392" name="sthref392"></a><a id="CHDEDBJB" name="CHDEDBJB"></a> <p class="titleintable">SET_CUSTOM_AUTH_STATUS Parameters</p> <table class="Formal" title="SET_CUSTOM_AUTH_STATUS Parameters" summary="This table describes the parameters available in the SET_CUSTOM_AUTH_STATUS 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-t111">Parameter</th> <th align="left" valign="bottom" id="r1c2-t111">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t111" headers="r1c1-t111"> <p><code>p_status</code></p> </td> <td align="left" headers="r2c1-t111 r1c2-t111"> <p>Any text the developer chooses to denote the result of the authentication attempt (up to 4000 characters).</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <a id="sthref393" name="sthref393"></a> <p class="subhead2">Example</p> <p>One way to use the <code>SET_CUSTOM_AUTH_STATUS</code> procedure is to include it in the application authentication scheme. This example demonstrates how text and numeric status values can be registered for logging. Note that no credentials verification is performed. The status set using this procedure is visible in the <code>apex_user_access_log</code> view and in the reports on this view available to workspace and site administrators.</p> <pre xml:space="preserve" class="oac_no_warn"> CREATE OR REPLACE FUNCTION MY_AUTH( p_username IN VARCHAR2, p_password IN VARCHAR2) RETURN BOOLEAN IS BEGIN APEX_UTIL.SET_CUSTOM_AUTH_STATUS(p_status=>'User:'||p_username||' is back.'); IF UPPER(p_username) = 'GOOD' THEN APEX_UTIL.SET_AUTHENTICATION_RESULT(24567); RETURN TRUE; ELSE APEX_UTIL.SET_AUTHENTICATION_RESULT(-666); RETURN FALSE; END IF; END; </pre> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="apex_util073.htm#CHDCAECI">"SET_AUTHENTICATION_RESULT Procedure"</a> and <a href="apex_util032.htm#CHDICEAJ">"GET_AUTHENTICATION_RESULT Function"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </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_util073.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util075.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