Re: hanging open cursors problem

Check the forms option "cursor mode". If it is set to 'close', change it to 'open'. It seems that the 'close' mode is supposed to inform the server to release memory and the reallocate it when the form opens up again. Apparently, the server doesn't get the message or otherwise fails to free up the cursor space. You run out of memory in the PGA.

Jan Kopinec <kopinec_at_ips-ag.ch> wrote in article <343B6437.7A904A79_at_ips-ag.ch>...
> Hi All,
>
> we have the following problem with our
> application written in Developer 1.3.2: it
> needs too much open cursors because all cursors
> even explicit one used in one form are
> just hanging on the server until disconnect no
Received on Wed Oct 08 1997 - 00:00:00 CEST