//function;
create or replace FUNCTION FND_CHECK_USER_AUT_SENTRY_FUN RETURN BOOLEAN IS
P_result boolean := false;
P_user varchar2(100);
l_session NUMBER;
P_TOKEN varchar2(100) ;
BEGIN
if apex_authentication.is_authenticated then
-- already logged in P_result := TRUE;
elsif P_TOKEN is not null THEN
P_TOKEN := apex_application.g_x01;
P_user := —function(P_TOKEN) ;فانکشنی که توکن رو بگیره نام کاربری برگردونه
IF P_user is not null THEN
P_result := TRUE;
----------------------------------------
l_session := APEX_CUSTOM_AUTH.GET_SESSION_ID_FROM_COOKIE;
IF l_session IS NOT NULL THEN -- test if the session is still valid and get a new session id, if not valid IF NOT APEX_CUSTOM_AUTH.IS_SESSION_VALID THEN l_session := APEX_CUSTOM_AUTH.GET_NEXT_SESSION_ID; END IF; ELSE -- no session in cookie found, get a new session id l_session := APEX_CUSTOM_AUTH.GET_NEXT_SESSION_ID; END IF; /* APEX_CUSTOM_AUTH.DEFINE_USER_SESSION ( P_user, l_session); */ -------------------------------- apex_authentication.post_login (p_username => P_user ); ELSE P_result := FALSE; END IF;
END IF;
RETURN P_result;
END;
/