savepoints and open cursors in Forms

Hi Oracle fans,

I'm having a nice problem here.

I have written a large GUI-interface in Forms 4.0 After a while he starts doing odd things with in the end the inevitalbe crash. Somethings he gives an error : Unable to issue savepoint command, sometimes he gives an Oracle error : unable to perform query. The user had to leave the application and come back in again. With after a while the same problem... The user learned to live with the handicap and I couldn't find it (I even couldn't reproduce it), so I left it that way.

I thougt the problem was going to be solved in Developer 2000 but this was not the case.

The last week I incidentally stumbled on the datadictiannory table v$sesstat en v$open_cursor and what was the case : this program was using more than 500 open cursors... I began to monitor the damned thing and I saw that he didn't reused the opened cursors that he already had opened. Even the cursors which issues the savepoint command was repeated which gave probably the savepoint error.

I began to ask the Belgian Oracle Support Desk for bulletins on how Forms was using cursors and savepoints but they did not give me a lot of information.

I do not create manually savepoints, nor do I open manually cursors (without closing them). Everything is generated by Forms.

So my question after this long explanation : has anyone information about these issues. Can anyone tell me when Forms reuses the already opened cursors and when not or why he does not release the savepoints he sat with the previous commits.
Or maybe is there somebody out there that had already this problem and solved it ????

I hope someone can help me out.

I prefer your answers at nedee_at_club.innet.be

Thx.

Peter Van den Broeck
Belgium Received on Fri Oct 25 1996 - 00:00:00 CEST