[Home] [Help]
532: -----------------
533:
534: PROCEDURE unregister_propagator(username IN VARCHAR2,
535: timeout IN INTEGER
536: DEFAULT dbms_lock.maxwait);
537: -- Unregister the given user as the given propagator for the local database.
538: -- It also revokes all privileges that were granted by register_propagator()
539: -- from the given user, including those identical privileges that were
540: -- granted independently of register_propagator().
546: -- username
547: -- Name of the user
548: -- timeout
549: -- Timeout in seconds. If the propagator is in use, it will wait until
550: -- the given timeout. The default value is dbms_lock.maxwait.
551: -- Exceptions:
552: -- missingpropagator
553: -- The given user is not the propagator.
554: -- propagator_inuse
564: -- Timeout in seconds. If the lock cannot be acquired within this
565: -- time period (either because of an error or because a push is
566: -- currently under way) then the call returns a value of 1 (see
567: -- below).
568: -- A timeout value of dbms_lock.maxwait waits forever.
569: -- Return value (lock held?):
570: -- (as for dbms_lock.acquire(.))
571: -- 0 - success (Y)
572: -- 1 - timeout (N)
566: -- currently under way) then the call returns a value of 1 (see
567: -- below).
568: -- A timeout value of dbms_lock.maxwait waits forever.
569: -- Return value (lock held?):
570: -- (as for dbms_lock.acquire(.))
571: -- 0 - success (Y)
572: -- 1 - timeout (N)
573: -- 2 - deadlock (N)
574: -- 4 - already own the lock (Y)