Re: DBMS_LOCK.ALLOCATE_UNIQUE and savepoints (7.3.3)

From: Francis Small <fthes_at_sr.hp.com>
Date: 1997/11/24
Message-ID: <65cqpv$n6d@canyon.sr.hp.com>#1/1

It appears that I've found the source of the problem. DBMS_LOCK.ALLOCATE_UNIQUE performs a COMMIT. No doubt there is some really good reason for this, such as the need to make sure that the allocated number is committed to the database so that it is seen by other users, but

I REALLY WISH THIS HAD BEEN DOCUMENTED IN THE MANUAL!!!!!!!!!!!!!!! Now on to plan B, whatever that is... :-(

Francis

--
. . . . . . . . . | 1 . . . . . . . . . 2 . . . . . . . . . 3 . . . . . . . . 
Giants                                         Francis Small - M/S M3RA     
    Bums                                         Hewlett-Packard Company
              Rockies                              Microwave Instruments Div.
                            Padres                   1212 Valley House Dr.
                                                       Rohnert Park CA, 94928
                                                         707 794 3305
                                                           fthes_at_sr.hp.com
***************** Final 1997 National League West Standings *****************

Received on Mon Nov 24 1997 - 00:00:00 CST