Re: How to ensure only one session runs PL/SQL proc at a time?

Why do you need allocate unique ?

If you want to allow just one copy of the procedure to run at a time, shouldn't you have a constant associated with the procedure ?

--
Jonathan Lewis

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

For latest news of public appearances
See http://www.jlcomp.demon.co.uk

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.




Ian Ledzion wrote in message <9m4si1$fop$1_at_rex.ip-plus.net>...


>Tested dbms_lock, and it works fine.  Only problem I've had is that I can't

>use it from a trigger as the allocate_unique procedure issues a commit.

>