PL/SQL (MOSC)

MOSC Banner

Feature request: Preempt a package from being reinitialized

The MODIFY_PACKAGE_STATE and RESET_PACKAGE in DBMS_SESSION are great, and of course extremely useful for starting every (web) request with a "clean slate", since sessions are re-used.

But, some packages could really - really - benefit from not having to initialize all their state again and again, since their state is always the same. And perhaps they also cache some values, internally in PL/SQL, that could be reused globally - disregarding any particular request "session" state.

It would be really nice if you could somehow "preempt" a package from the global "throw away all state"-algorithm. Perhaps with a compile time directive/pragma?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center