set_dept_ctx_1.sql

来自「OReilly Oracle PL SQL Programming第4版源代码」· SQL 代码 · 共 12 行

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;
/