Re: any procedure locking or pooling simultaneous calling?

> here is a question puzzled me.
>
> say if i got one procedure who will take 5 minutes to run and finish.
>
> if user1 one call the procedure and run it, after 1 minute then another user
> (say user2) call and run the same procedure.
> is there any procedure locking or pooling handled by ORACLE internally?
> or it works fine? which means while user1 is running the procedure, user2
> can also invoke the procedure and run it, it doens't affect anything, or
> perharps the things it affects is the internal source of the procedure (if
> got update or insert or select statement) that will cause data inconsitenscy
> problem. (which is similar to cases whereby different user login as
> different session and issue same update statement, some locking mechanism
> will occur in ORACLE).
>
> do i guess correctly?
>
> pls help me to solve this doubt. your help would be greatly appreciated.
> thanks alot.

There is no locking unless it is coded into the procedure by the person that wrote the code. Something I can't recall have ever seen.

Daniel A. Morgan Received on Mon Feb 19 2001 - 22:44:53 CST