dbms_session.set_context : dbms_session « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. dbms_session
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>
SQL>








31.24.dbms_session
31.24.1.dbms_session.set_context
31.24.2.DBMS_SESSION.IS_ROLE_ENABLED
31.24.3.DBMS_SESSION.SET_SQL_TRACE
31.24.4.Use dbms_session.AppCtxTabTyp and dbms_session.list_context to display context