procedure execution

Is there any methods in oracle, by which, concurrent procedure execution can be controlled? (i.e) only 100 users can execute the particular procedure or package

Hi.

The only thing I can think of is if you create a table to hold a counter. At the start of the procedure, check there aren't too many. If there aren't, add one onto the counter and proceed. At the end of the procedure remove one from the counter.

It's not nice, and I'm sure you will run into problems with it, but it would solve your problem.

Cheers

Tim...

Thanks TIM
even i guess the samething