0 Replies Latest reply: Jul 15, 2013 4:46 AM by user13430807 RSS

    context variable DRIXMD (namespace DR$APPCTX) shows up in v$context

    user13430807

      We have recently upgraded our database to Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production.

       

      Now we occasionally get the error in one of our APEX applications

      ORA-01031: insufficiënt privileges

       

      The apex application is using a user connection pool.

      When an Apex page is submitted we clear the context variables so the user won’t use each other’s settings.

      The context variables to be cleared are selected from V$CONTEXT.

       

      For some reason the context variable DRIXMD (namespace DR$APPCTX) is now (since the upgrade to 11.2) also shown in v$context.

      The package used in our code is not allowed to set variables in namespace DR$APPCTX and is raising the error.

       

      My question is:

      Is it a normal feature to see these context variables in V$CONTEX and if not is there a fix available?

      And if yes, can anyone clarify this?

       

       

      Thanks in advance.