Oracle APEX 커스텀 인증

Employees 테이블 패스워 설정

• SQL Workshop SQL Commands

update employees set EMP_PW = 'WELCOME123456!';

Oracle Function: APEX 인증

• SQL Workshop SQL Commands

create or replace function authenticate_user (
p_username in varchar2,
p_password in varchar2
) return boolean 
as 
  v_pw_check varchar2(1);
begin 
  APEX_UTIL.SET_SESSION_STATE('LOGIN_MESSAGE', '시작');

  select 'x'
  into v_pw_check
  from employees 
  where upper(employee_id) = upper(p_username) and upper(emp_pw) = upper(p_password); 

  apex_util.set_authentication_result(0);
  APEX_UTIL.SET_SESSION_STATE('LOGIN_MESSAGE', 'Success');

  return true;

exception when NO_DATA_FOUND then 
  apex_util.set_authentication_result(4);
  APEX_UTIL.SET_SESSION_STATE('LOGIN_MESSAGE', '오류!! 아이디와 비밀번호가 불일치합니다.');

  return false;

end authenticate_user;

Application Item 등록

• LOGIN_MESSAGE