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