By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.