Skip to Main Content
  • Questions

  • Does a Pragma serially_reusable clause is helpful for the .net front end that calls the package.

Breadcrumb

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

Question and Answer

Connor McDonald

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.

We're not taking comments currently, so please try again later if you want to add a comment.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library