4 Replies Latest reply on Jun 12, 2011 3:00 PM by UserMB

    error while executing DBMS_SESSION.SET_CONTEXT

    UserMB
      hello
      under user SYS i created the following procedure:

      create or replace PROCEDURE SET_EMPNO_CTX_PROC(emp_value IN VARCHAR2) AS
      BEGIN
      DBMS_SESSION.SET_CONTEXT('empno_ctx', 'empno_attrib', emp_value);
      END SET_EMPNO_CTX_PROC;

      when i run the following in sqlplus: exec set_empno_ctx_proc('42738');

      i get the following error:

      ORA-01031: insufficient privileges
      ORA-06512: at "SYS.DBMS_SESSION", line 94
      ORA-06512: at "SYS.SET_EMPNO_CTX_PROC", line 3
      ORA-06512: at line 6

      anyone knows who to resolve that?
      id appreciate any tips
      thx
      rgds

      Edited by: UserMB on Jun 12, 2011 6:59 AM