PL/SQL and lock

From: Marco Sarti <marco.sarti_at_plangroup.it>
Date: Tue, 12 Jun 2001 18:18:31 +0200
Message-ID: <9g5fcf$tls4$1@news01.it.net>

Oracle 8.0.6

I need to write a PL/SQL procedure that should be executed simultaneously by more than one users.
This procedure needs to take a unique progressive number from a numerator table. It makes a select for update and an update on this row table. This means that the resource is looked until the transaction is commited; in other words, an execution instance locks any other until it is finished. I only need that the number selected is unique, I do not need to avoid "holes".
When I wrote the procedure in a client application (PowerBuilder) I uses a separate transaction taking this numerator and I committed it each time. I don't know if it is possible in a PL/SQL procedure (or if an alternate solution exists...).
PS: I cannot use sequences. Received on Tue Jun 12 2001 - 11:18:31 CDT