Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEAPI\apex_util073.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_AUTHENTICATION_RESULT 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_AUTHENTICATION_RESULT 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_util073.htm" title="SET_AUTHENTICATION" type="text/html" /> <link rel="prev" href="apex_util072.htm" title="Previous" type="text/html" /> <link rel="next" href="apex_util074.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_AUTHENTICATION�</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_util072.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util074.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDCAECI" name="CHDCAECI"></a></p> <hr /> <div class="refsect1"> <h1><a name="AEAPI175" id="AEAPI175"></a>SET_AUTHENTICATION_RESULT <a id="sthref383" name="sthref383"></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="sthref384" name="sthref384"></a> <p class="subhead2">Syntax</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_UTIL.SET_AUTHENTICATION_RESULT( p_code IN NUMBER); </pre> <a id="sthref385" name="sthref385"></a> <p class="subhead2">Parameters</p> <p><a href="apex_util022.htm#CHDGEIFG">Table: EXPIRE_WORKSPACE_ACCOUNT Parameters</a> describes the parameters available in the <code>SET_AUTHENTICATION_RESULT</code> procedure.</p> <div class="tblformal"><a id="sthref386" name="sthref386"></a><a id="sthref387" name="sthref387"></a> <p class="titleintable">SET_AUTHENTICATION_RESULT Parameters</p> <table class="Formal" title="SET_AUTHENTICATION_RESULT Parameters" summary="This table describes the parameters available in the SET_AUTHENTICATION_RESULT 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-t108">Parameter</th> <th align="left" valign="bottom" id="r1c2-t108">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t108" headers="r1c1-t108"> <p><code>p_code</code></p> </td> <td align="left" headers="r2c1-t108 r1c2-t108"> <p>Any numeric value the developer chooses. After this value is set in the session using this procedure, it can be retrieved using the <code>APEX_UTIL.GET_AUTHENTICATION_RESULT</code> function.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <a id="sthref388" name="sthref388"></a> <p class="subhead2">Example</p> <p>One way to use this procedure is to include it in the application authentication scheme. This example demonstrates how text and numeric status values can be registered for logging. In this example, no credentials verification is performed, it just demonstrates how text and numeric status values can be registered for logging.Note that 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_util032.htm#CHDICEAJ">"GET_AUTHENTICATION_RESULT Function"</a> and <a href="apex_util074.htm#CHDHHJGJ">"SET_CUSTOM_AUTH_STATUS Procedure"</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_util072.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util074.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