Stored procedure who work with session

Stored procedure who work with session

Postby Olof » Fri 11 Dec 2015 13:17

Hi,

we have a some packages in the db who are using session variables. Can I use theses packages from .NET code without problems ? If different users use the same package at the same time, their variables will by mixed or not ?!?

Thank you
Olof
 
Posts: 7
Joined: Thu 09 Jun 2011 11:18

Re: Stored procedure who work with session

Postby Pinturiccio » Tue 15 Dec 2015 15:45

Session variables are created for the session, and are used only in this session. If other user will use this package, then he will have his own session and own session variable values. Using this package should cause no conflicts.
Pinturiccio
Devart Team
 
Posts: 1953
Joined: Wed 02 Nov 2011 09:44

Re: Stored procedure who work with session

Postby Olof » Wed 16 Dec 2015 07:21

By users, I mean Oracle user, not user of my application.
Devart share connections on Oracle database, right ? 10 users in my application, but only 2 "sessions" visible on Oracle DB... How it works ?
Olof
 
Posts: 7
Joined: Thu 09 Jun 2011 11:18

Re: Stored procedure who work with session

Postby Shalex » Fri 18 Dec 2015 18:22

Shalex
Devart Team
 
Posts: 7608
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle