DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: procedure execution

  1. #1
    Join Date
    Sep 2003
    Posts
    49

    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

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  3. #3
    Join Date
    Sep 2003
    Posts
    49
    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
  •  


Click Here to Expand Forum to Full Width