Re: stored procedure question
Date: 2000/07/04
Message-ID: <8js1mt$o46$1_at_perki.connect.com.au>#1/1
It Depends on the application.
each station is in fact an active session they have their own memory etc
what oracle does, caches the procedures and SQL codes.
You can lock the records as you wish and release the lock when you finish
with record.
Tom
Sunny <sunnyb_at_vendtek.bc.ca> wrote in message
news:8jr3df$sr0$1_at_newsfeed.smartt.com...
> Hi everyone
>
> I have a question. what happens when suppose you have a stored procedure
> that you call from your application and it passes you a value(say the
> primary key) and once you get it in your application you dont want anyone
> else to see it. ok now there are say 5 stations calls this stored
procedure
> at the exact same time and execute the stored procedure. ok now the
question
> is what happens to that value who gets it and how oracle executes the
stored
> procedure for say 5 different stations. does it opens only the one
instance
> of the stored procedure... how does it do it.
>
> thanks everyone
>
>
Received on Tue Jul 04 2000 - 00:00:00 CEST