Oracle apex Login authentication
For more info
Email:[email protected]
Fb: / forkanraju88
----------------------------------
PL/SQL CODE
------------------------------------
FUNCTION cek_otentikasi (p_username IN VARCHAR2, p_password IN VARCHAR2)
RETURN BOOLEAN
AS
hasil NUMBER := 0;
BEGIN
SELECT 1 INTO hasil FROM user_info
WHERE UPPER(user_id) = UPPER(p_username)
AND password = p_password
AND USER_STATUS_ID=1
AND USER_TYPE_ID IN (1,2);
RETURN TRUE;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN FALSE;
end;