My application is throwing the below mentioned error,when i am trying to open a tab in the application. 'A' is the schema name and the schema has the required privileges and grants. Please find below the code snippet of the package and the procedure. Request you to help me on finding what could be the exact cause of the issue
CODE
System.Data.OracleClient.OracleException: ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 101
ORA-06512: at "A.Example", line 5
*ORA-06512: at "A.Test", line 18*Package Code
create or replace PACKAGE BODY Example IS
PROCEDURE set_parameter (p_name IN VARCHAR2,
p_value IN VARCHAR2) IS
BEGIN
DBMS_SESSION.set_context('parameter', p_name, p_value);
END set_parameter;
END Example;
Procedure COde
------------------------------
Procedure --- Test
create or replace PROCEDURE Test(USERNAME IN VARCHAR, USERTYPE IN VARCHAR, FILTER IN CLOB, SELECTEDCOLUMNS IN VARCHAR, OUTCURSOR OUT TYPES.CURSORTYPE, OUTINVIEWCOUNT OUT TYPES.CURSORTYPE) AS
SEARCHSTRING VARCHAR2(30);
QUERYSQL VARCHAR2(32767);
PARAMLIST VARCHAR2(32767);
COUNTSQL VARCHAR2(32767);
FILTERID VARCHAR(3);
WHERESQL VARCHAR(32767);
TOTALFILTERITEM NUMBER(10, 0);
MAINID NUMBER;
DETAILSID NUMBER;
BEGIN
IF FILTER IS NOT NULL THEN
GETFILTERDETAILS(XMLDOC => XMLTYPE(FILTER), ID => FILTERID, SEARCH => SEARCHSTRING);
END IF;
**Example.SET_PARAMETER('USERNAME', USERNAME);**
**Example.SET_PARAMETER('USERTYPE', USERTYPE);**
ORA-06512: at "SYS.DBMS_SESSION", line 101
ORA-06512: at "A.Example", line 5
*ORA-06512: at "A.Test", line 18*Package Code
create or replace PACKAGE BODY Example IS
PROCEDURE set_parameter (p_name IN VARCHAR2,
p_value IN VARCHAR2) IS
BEGIN
DBMS_SESSION.set_context('parameter', p_name, p_value);
END set_parameter;
END Example;
Procedure COde
------------------------------
Procedure --- Test
create or replace PROCEDURE Test(USERNAME IN VARCHAR, USERTYPE IN VARCHAR, FILTER IN CLOB, SELECTEDCOLUMNS IN VARCHAR, OUTCURSOR OUT TYPES.CURSORTYPE, OUTINVIEWCOUNT OUT TYPES.CURSORTYPE) AS
SEARCHSTRING VARCHAR2(30);
QUERYSQL VARCHAR2(32767);
PARAMLIST VARCHAR2(32767);
COUNTSQL VARCHAR2(32767);
FILTERID VARCHAR(3);
WHERESQL VARCHAR(32767);
TOTALFILTERITEM NUMBER(10, 0);
MAINID NUMBER;
DETAILSID NUMBER;
BEGIN
IF FILTER IS NOT NULL THEN
GETFILTERDETAILS(XMLDOC => XMLTYPE(FILTER), ID => FILTERID, SEARCH => SEARCHSTRING);
END IF;
**Example.SET_PARAMETER('USERNAME', USERNAME);**
**Example.SET_PARAMETER('USERTYPE', USERTYPE);**