Page 1 of 1
Stored procedure who work with session
Posted: Fri 11 Dec 2015 13:17
by Olof
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
Re: Stored procedure who work with session
Posted: Tue 15 Dec 2015 15:45
by Pinturiccio
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.
Re: Stored procedure who work with session
Posted: Wed 16 Dec 2015 07:21
by Olof
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 ?
Re: Stored procedure who work with session
Posted: Fri 18 Dec 2015 18:22
by Shalex
You are using connection pooling, aren't you? Please refer to
1. Pooling:
https://www.devart.com/dotconnect/oracl ... q.html#q54
2. Connection string parameters:
https://www.devart.com/dotconnect/oracl ... tring.html