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_at_news.xtra.co.nz>#1/1
Date: 2000/05/23
Message-ID: <HjlW4.16163$usz4.10420568_at_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 CEST