Stored procedure who work with session

[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

[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.

[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 ?

[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