Oracle Apex | Authentication Schemes and Application Access Control
PL/SQL Code:
function chk_authentic( p_username varchar2, p_password varchar2)
return boolean
as
ucount number:=0;
begin
select 1 into ucount from USER_INFO where upper(USER_NAME)=upper(p_username)
and upper(PASSWORD)=upper(p_password)
and BR_CODE=:P9999_BRCODE;//:P9999_BRCODE is a field name
return true;
exception
when no_data_found then
return false;
end;