Re: COMMIT's within cursor for loops

From: <Reginald.W.Bailey_at_jpmorgan.com>
Date: Thu, 26 Jun 2003 10:59:36 -0700
Message-ID: <F001.005BA8D0.20030626104508@fatcity.com>

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

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.
If you are using OPEN CURSOR...FETCH INTO statements to get the data the same rule applies.

Thanks,

--
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).

Received on Thu Jun 26 2003 - 12:59:36 CDT