Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

error while executing DBMS_SESSION.SET_CONTEXT

User_8P4FCJun 12 2011 — edited Jun 12 2011
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
This post has been answered by 868168 on Jun 12 2011
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 10 2011
Added on Jun 12 2011
4 comments
24,216 views