Re: Forms4.0: open cursor problem

In <nfjohnso.7.31714F53_at_postbox.acs.ohio-state.edu>, nfjohnso_at_postbox.acs.ohio-state.edu (Norman F. Johnson) writes:
>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

Increase the value of open_cursors in your init.ora file.

D. Scott Moyer, Jr.                        dmoyer_at_gpu.com (work)
GPU Service Corporation                dsmoyer_at_enter.net (home)