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

Thread: DBMS_SESSION.SET_CONTEXT Error

Hybrid 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

  2. #2
    Join Date
    Jan 2008
    Posts
    7
    Schema2 does not have all the necessary privileges in order to access the package you created in schema1. Does schema2 have execute privilege on the said package - and the necessary priviliege(s) to access all objects referenced within the package?
    You need to check that.

    DSupp2008.

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