commit inside a cursor oper

From: Saad Ahmad <sahmad_at_mfa.com>
Date: 1995/08/22
Message-ID: <41de3b$qa7_at_homer.alpha.net>#1/1


Hi

What kind of problems can arise if a code segment is doing a commit inside a cursor op. ie.

OPEN CURSOR c1;

for(;;)
{
  FETCH c1;

  some update;
  commit;

}

CLOSE c1;

I know this should not be done; but what problems can arise in such a case? eg. locks lost etc.

--
**************************************************************

* Saad Ahmad *
* McHugh Freeman & Associates, Inc. *
* Ph: (414) 798-8606 Ext. 457 *
* Fax: (414) 798-8619 *
* E-Mail: sahmad_at_mfa.com *
**************************************************************
Received on Tue Aug 22 1995 - 00:00:00 CEST

Original text of this message