In testing a new application, I've run into a problem with too many open
cursors. It is basically three forms with numerous LOV's and associated
record groups. The error can be significantly delayed from appearing if I
avoid calling the LOVs to insert values. I've searched through all the
triggers I've written and have explicitly closed each cursor contained in them.
So, are my LOV's or record groups opening these cursors without closing them?
If so, any ideas on what to do? Both are defined in the form design, not at
runtime? What else in the form could be causing this problem?
Appreciate any hints.
Norm Johnson
Johnson.2_at_osu.edu