I would like my functions and procedures to have private datasessions. Three reasons:

- function/procedure calls will not change the state of tables
- makes it explict which tables a function/procedure uses
- automatically closes all temporary cursors

Can anyone point to towards some resources on how to do this? Any the cons to this idea?