The variables in use for a stored procedure are taken care of in the user's Program Global Area (PGA). When multiple users simultaneously execute the same stored procedure, the PGA keeps track of the state of that user's execution of the stored proc. You do not have to worry about concurrency issues for these variables. Oracle handles it for you.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.