DBMS_SESSION.SET_CONTEXT Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DBMS_SESSION.SET_CONTEXT Error

Threaded View

  1. #1
    Join Date
    Dec 2007
    Posts
    1

    DBMS_SESSION.SET_CONTEXT Error

    Hi All,

    my senario is i have created a context from schema 'Schema1' using "accessed globally" option and created on package to set the values for conext. It is working fine.

    When i deploy the same package on schema2 (remember the context is on schema1) and try to execute it on schema2 then it is giving me the following error. any help will be much appreciated.

    attached the test package for reference.

    Connected to:
    Oracle Database 10g Release 10.2.0.1.0 - Production

    SQL> exec krishna_pkg.MyProcedure
    BEGIN krishna_pkg.MyProcedure; END;

    *
    ERROR at line 1:
    ORA-01031: insufficient privileges
    ORA-06512: at "SYS.DBMS_SESSION", line 90
    ORA-06512: at "LGE2008DEV.KRISHNA_PKG", line 6
    ORA-06512: at line 1
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width