Consultant

Nuno

<div>
After some research on application context I found that GET_APPCONTEXT("session","userSSO") &nbsp;is equivalent to SYS_CONTEXT('session','userSSO') and SET_APPCONTEXT("session","userSSO",value1) is equivalent to DBMS_SESSION.SET_CONTEXT('session','userSSO',value1).<br><br>As you said "userSSO" is a parameter in "session" context.<br><br>Just one question, do we have to create the context "session" &nbsp;for every procedure that uses the created context ?<br>In my case I have to DBMS_SESSION.SET_CONTEXT('session','userSSO',xxx) in many procedures.&nbsp;
</div>


<div>
&gt;&gt;do we have to create the context &quot;session&quot; &nbsp;for every procedure that uses the created context ?<br />
<br />
<br />
The &quot;session&quot; starts when a user connects to the database and exists as long as that user remains connected. &nbsp;Any session variable should be around that entire time, from the time it is set to the time it us unset or the user disconnects.
</div>


<div>
So do you think it's not necessary to create the context "session" with<br><a href="http://psoug.org/definition/CREATE.htm" rel="ugc">CREATE</a> OR <a href="http://psoug.org/definition/REPLACE.htm" rel="ugc">REPLACE</a> CONTEXT "session" using My_pkg<br>ACCESSED GLOBALLY; ?
</div>


<div>
I don't know. &nbsp;I'm not sure what functionality you are trying to replace is used for so not sure what the best way might be.
</div>


<div>
<div class="content wysiwyg-content fr-view">
Hi,<br>GET_APPCONTEXT("session","userSSO") in T-SQL is equivalent to SYS_CONTEXT('userenv','session_user') in PL/SQL ?<br><br>What are the equivalents of RM_APPCONTEXT("session","userSSO") and SET_APPCONTEXT in Oracle ?<br><br>Thanks
</div>
</div>



Hi,
GET_APPCONTEXT("session","userSSO") in T-SQL is equivalent to SYS_CONTEXT('userenv','session_user') in PL/SQL ?
What are the equivalents of RM_APPCONTEXT("session","userSSO") and SET_APPCONTEXT in Oracle ?
Thanks

GET_APPCONTEXT and SYS_CONTEXT

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Sybase Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.