The DBMS_LOCK package enables user-defined locks to be released and allocated at will and even held over transaction boundaries.