Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DBMS_LOCK.ALLOCATE_UNIQUE and lockhandle

DBMS_LOCK.ALLOCATE_UNIQUE and lockhandle

From: Francis Small <fthes_at_sr.hp.com>
Date: 1997/11/14
Message-ID: <64ilml$aso@canyon.sr.hp.com>#1/1

Oracle7 Server Release 7.3.3.0.0:

When making a call to:

  DBMS_LOCK.ALLOCATE_UNIQUE(lockname_in, lockhandle_out, expiration_in)

It appears that the first 10 characters of lockhandle_out always equal the lockid in the DBMS_LOCK_ALLOCATED table for the corresponding user lock. Is this true and can I depend upon this behavior, or should I play it safe and simply read the lockid from the table for the corresponding lockhandle? I want to use the lockid as an index into a PL/SQL table with the assurance that I will not use the same index for two different user allocated locks.

   Francis Small

--
. . . . . . . . . | 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 Fri Nov 14 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US