Re: Closing cursors in Forms 3

IAN -- It's good practice the close the cursor. It will be

       automatically closed by PL/SQL when it goes out of scope
       anyway, but don't count on that since some situations in PL/SQL
       2.0 allow cursors to retain state across a session (e.g. if
       they are declared in a stored package) so not closing the
       cursor in this case would be meaningful. PL/SQL 1.0 in Forms
       3.0 will close the cursor (either automatically or by your
       programmatic request) but it will not "dispose" of the cursor.
       It keeps a cache around so that it doesn't need to reparse the
       statement again -- just rebind, and re-execut -- the next time
       that same program unit is run.


   

--

Steve Muench         Email: smuench_at_oracle.com
Forms Development      CIS: 73404,676
Product Manager
Oracle Corporation