Thanks for the question, Geetika .
Asked: November 18, 2016 - 11:20 am UTC
Last updated: November 19, 2016 - 4:07 am UTC
Version: 12c
Viewed 1000+ times
You Asked
Does a Pragma serially_reusable clause is helpful for the .net front end that calls the package.
I have a package
create or replace pkg_test
as
Pragma serially_reusable
l_var number := 0
//some code here
end;
this package is called by the .net frontend.
Does having Pragma serially_reusable have any benefit for the .net front end.
and Connor said...
Unlikely.
What you are saying is that I dont need to keep any state the moment the call completes. So you dont need the content of l_var once the call completes. IF that is the case, I'd then be asking - why do you have l_var as a global.
Is this answer out of date? If it is, please let us know via a Comment