I need to use 'alter session' for two dozen functions stored in a package. Is there a way to alter the session for the entire package, or do I need to repeat these lines in every function?
This raises also the entire question of 'alter session' scope. If a function uses 'alter session', and if I use that function in a query, how would that affect things? The name suggests that this is a global setting, but perhaps there is a way to alter some settings locally (only for a package in my case). I would prefer that my functions do not have side effects.
I couldn't find any good explanation in the documentation, perhaps I just missed the right paragraph...
Markus -- (°v°)