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