-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|