forms session cursors do not close.

From: Zekun Zou <z.zou_at_paradise.net.nz>
Date: 2000/05/23
Message-ID: <HjlW4.16163$usz4.10420568@news.xtra.co.nz>#1/1

Hi Oracle forms experts,

Can you help me?

My problem is that:
One of my oracle form4.5 applications opens too many cursors and do not close them.
The error message is:
ORA-01000 maximum open cursors exceeded.

In the forms, for all query statment, I use CLOSE cursorName explicity, but it do not work.
The cursor can not be closed. ( I use V$OPEN_CURSOR to minitor the form session's
cursors state).

At this stage I do not want to increase the parameter OPEN_CURSOR value.

BTW, what is the reasonable value of parameter OPEN_CURSOR for Oracle7.3 on SUN solaries2.6?
Memory=512M. 2 CPU. (The default is OPEN_CURSOR=50.)

Can Oracle forms experts there help me?

Thanks
Quinn Received on Tue May 23 2000 - 00:00:00 CDT