Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> DBMS_LOCK.ALLOCATE_UNIQUE and lockhandle
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