Final Class Yiisoft\Mutex\Oracle\OracleMutex

                public function __construct(
    string $name,
    PDO $connection,
    string $lockMode = self::MODE_X,
    bool $releaseOnCommit = false
) {
    if (!in_array($lockMode, self::MODES, true)) {
        throw new InvalidArgumentException(sprintf(
            '"%s" is not valid lock mode for "%s". It must be one of the values of: "%s".',
            $lockMode,
            self::class,
            implode('", "', self::MODES),
        ));
    }
    $this->lockName = $name;
    $this->connection = $connection;
    $this->lockMode = $lockMode;
    $this->releaseOnCommit = $releaseOnCommit;
    /** @var string $driverName */
    $driverName = $connection->getAttribute(PDO::ATTR_DRIVER_NAME);
    if (!in_array($driverName, ['oci', 'obdb'], true)) {
        throw new InvalidArgumentException("Oracle connection instance should be passed. Got \"$driverName\".");
    }
    parent::__construct(self::class, $name);
}

            

                protected function acquireLock(int $timeout = 0): bool
{
    $lockStatus = 4;
    // clean vars before using
    $releaseOnCommit = $this->releaseOnCommit ? 'TRUE' : 'FALSE';
    // inside pl/sql scopes pdo binding not working correctly :(
    $statement = $this->connection->prepare(
        "DECLARE
            handle VARCHAR2(128);
        BEGIN
            DBMS_LOCK.ALLOCATE_UNIQUE(:name, handle);
            :lockStatus := DBMS_LOCK.REQUEST(
                handle,
                DBMS_LOCK.$this->lockMode,
                $timeout,
                $releaseOnCommit
            );
        END;"
    );
    $statement->bindValue(':name', $this->lockName);
    $statement->bindParam(':lockStatus', $lockStatus, PDO::PARAM_INT, 1);
    $statement->execute();
    return $lockStatus === 0 || $lockStatus === '0';
}

            

                protected function releaseLock(): bool
{
    $releaseStatus = 4;
    $statement = $this->connection->prepare(
        'DECLARE
            handle VARCHAR2(128);
        BEGIN
            DBMS_LOCK.ALLOCATE_UNIQUE(:name, handle);
            :releaseStatus := DBMS_LOCK.RELEASE(handle);
        END;'
    );
    $statement->bindValue(':name', $this->lockName);
    $statement->bindParam(':releaseStatus', $releaseStatus, PDO::PARAM_INT, 1);
    $statement->execute();
    return $releaseStatus === 0 || $releaseStatus === '0';
}