stored procedure question

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 Mon Jul 03 2000 - 00:00:00 CDT