SQL>SQL> create or replace procedure set_dept_ctx(p_attr in varchar2,p_val in varchar2) is 2 begin 3 dbms_session.set_context('DEPT_CTX', p_attr, p_val); 4 end; 5 /Procedure created.SQL>