Second Session Created When Set Role Command Run in VB Application

Yesterday our deveopers were getting a message from Oracle that the number of Oracle processes had been exceeded. The dba team checked and sure enough, there were 150 processes running(our max). Further investigation revealed that a vb application had 2 Oracle sessions running for every user running the application. After debugging with the developer, we discovered that the second session got started when the set role command was run. Why did it connect to a new session instead of using the one it had before? I checked another vb app that also sets roles within the code and discovered the same thing. I'm pretty sure it is not Oracle that is causing this because I can go into SqlPlus and then issue a set role command but I don't have another session created for me. Is there a problem with the code or this an inherent property of vb or maybe the odbc driver that is being used? Any help would be appreciated.

Thanks
Ivan H. Gaitan
Equiva Services (Houston, TX)

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 29 1999 - 09:53:22 CST