I prefer to create an inner block using BEGIN and END inside the loop. This
isolates the DML statements. The COMMIT is issued inside the BEGIN and END
block.
RWB
============================================================================================================
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL PROTECTED]
============================================================================================================
[EMAIL PROTECTED]
ic.com To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: COMMIT's within cursor for
loops
ity.com
06/25/2003
12:40 PM
Please respond
to ORACLE-L
Hi All,
Can somebody please clear up some issues about issuing commits during
CURSOR
FOR LOOPS
I have done some research within Metalink and the ORACLE-L FAQ but am still
a tad bit confused.
Are the following statements regarding cursors TRUE
1. If you issue a commit within a for cursor loop you release all locks
regardless of whether you're cursor statement has a FOR UPDATE statement in
it or there is a WHERE CURRENT statement within the loop.
2. If you are using OPEN CURSOR...FETCH INTO statements to get the data the
same rule applies.
Thanks,
N.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nuala Cullen
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
