Connection Pooling and Database Session Level variables
I have deployed an ADF application in weblogic server 11g(10.3.5) and using pool of connections for database. I am using Oracle database 10gR2. Database packages make use of many session level variables (declared as global variables in package spec). Connection pool is creating problem as the session variables state of one application user is transferred to other user when the new user get a connection from pool which someone else was using earlier. My questions are,
1- Is it recommended to use database session variables in connection pooling?
2- If answer to first question is yes then how database session variables are handled in connection pooling?