在Oracle中使用登录触发器初始化用户会话

CREATE OR REPLACE PACKAGE hr_context_pkg 

IS
   PROCEDURE initialize_hr_context;

END;

/



CREATE OR REPLACE PACKAGE BODY hr_context_pkg 

IS
   PROCEDURE initialize_hr_context
   IS
      v_dept NUMBER;
   BEGIN
      BEGIN
         SELECT department_id 
         INTO v_dept 
         FROM employees
         WHERE login_name = SYS_CONTEXT('USERENV',
                                 'SESSION_USER');
      EXCEPTION
         WHEN OTHERS THEN
            v_dept := NULL;
      END;
    DBMS_SESSION.SET_CONTEXT('hr_context', 'dept', v_dept);
   END;

END;

/