So, no one is man enough to answer my Oracle question?

From: Yaron <yadler_at_hypernix.co.il>
Date: Mon, 26 Apr 1999 12:12:42 +0300
Message-ID: <7g1aki$seq$1@news.netvision.net.il>

Dear All,
I have posted the following quwestion twice already, and got no responce. I wonder if there isn't anyone from this Oracle community that knows Oracle good enough to answer?

So here it goes again:

While working with Oracle objects for OLE (version 2.3.2.2.0) I encounter this problem:
After declaring an OSession object and ODatabase object, I tried to run the following lines of code continuously. I discovered that the computer's (oracle client) memory increasing consistently (to enormous sizes).
These kind of memory leak occures only when using OTYPE_CURSORparameters !

Example code:

OParameterCollection params = m_pDatabase.GetParameters(); params.Add("LIST_CURSOR",NULL,OPARAMETER_OUTVAR,OTYPE_CURSOR); if (m_pDatabase.ExecuteSQL("begin SqlQuery(:LIST_CURSOR); end;") != OSUCCESS)
{
m_pDatabase.GetParameters().Remove("LIST_CURSOR"); return;
}
m_pDatabase.GetParameters().Remove("LIST_CURSOR");

It is obvious that the oracle client was supposed to free the memmory allocated in this operation, but it doesn't.

Did any of you encountered this problem before? How did you solve it?

Please help
Yaron Adler Received on Mon Apr 26 1999 - 04:12:42 CDT