Server processes not exiting out
Hi,
Environment:
Oracle 9.1.2 on Windows XP
Shared Server Mode
Web application developed in VB.NET
Uses OracleClient from Microsoft (ADO.NET)
Stored Proc in Oracle returns REF CURSOR.
Problem:
Whenever the VB code executes the stored procedure GetData (to return rows) a new server process is initiated. However this process does not exit even after closing the connection. As a result, the number of processes keep on growing and soon exceed the MAX_PROCESSES limit.
Please advise on the action needed.
Thanks a lot.
VC