Re: commit inside a cursor oper

Billy OConnor (billyoc_at_iii1.iii.net) wrote:
} Saad Ahmad (sahmad_at_mfa.com) wrote:
} : 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.
} Without MODE=ORACLE being set, your cursor is closed as soon as you commit.
} Even with MODE=ORACLE, you'll lose your position in the cursor if you do a
} commit. You can work around this using ROWID.

I don't know what version you are referring to (we currently use v6), but we don't have any problems whatsoever doing the above with deletes. Are deletes handled differently than updates?

Tom

--

Thomas M. Buccelli (tmb_at_idm.com)

#include <std_disclaimer.h>