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