commit after or before close cursor - best practise

From: Grzegorz Goryszewski <grzegorzof_at_interia.pl>
Date: Sat, 19 Nov 2005 11:57:49 +0100
Message-ID: <dln0go$ofk$1@nemesis.news.tpi.pl>

Hello,

  which is better from 'best practise' perspective:

declare

   cursor ...

begin
  open ...
loop

	 fetch ...
	exit when %NOTFOUND
	insert ...

end loop;
commit;
close ...

OR

declare

   cursor ...

begin
  open ...
loop

	 fetch ...
	exit when %NOTFOUND
	insert ...

end loop;
close ...
commit;

Regards.
Grzegorz Received on Sat Nov 19 2005 - 04:57:49 CST