Server processes not exiting out

[vchitnis]

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

[davey23uk]

sort out your application to actually close the connection

[abhaysk]

Ur application code has bugs or not properly coded to close the connection.

As far as with VB is conserned...
We do define ojbect to adodb conn type.

Object.open
app logic
object.close

Abhay.