set_dept_ctx_1.sql

OReilly Oracle PL SQL Programming第4版源代码

create or replace procedure set_dept_ctx
(
    p_attr in varchar2,
    p_val  in varchar2
)
is
begin
    dbms_session.set_context
       ('DEPT_CTX', p_attr, p_val);
end;
/