Oracle9iAS Portal Developer Kit

get_login_time function

Contained in package wwctx_api.

Call this function to get the time that the current user logged in to Oracle Portal.

function get_login_time
return date;

Version: Oracle Portal 3.0.6.6.5 or later

Returns:

This function returns the system date for the time that the current user logged in to Oracle Portal.

Exceptions:

If no session is found, a NO_SESSION_EXCEPTION is raised.

Example:

This example returns TRUE if the current Oracle Portal user logged in more than one day ago. It returns FALSE otherwise.

begin

if sysdate - wwctx_api.get_login_time > 1 then

return TRUE;

else

return FALSE;

end if;

end;

Related topics

The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio