Hi,
I had asked about how to implement a static parameter for a VPD function earlier:
VPD: Best way to pass a static parameter to VPD Function?
and I had settled on using SYS_CONTEXT and "ACCESSED GLOBALLY".
I had shutdown the database last night and then just started up again this morning to do more testing, and noticed that the global variable was gone, so I had to run the exec to set it again.
Is there a way to avoid that and have the global variable always persist/be set automatically when the database is running? Or maybe I am creating or setting the context incorrectly?
I am currently following the example for access globally at: http://www.adp-gmbh.ch/ora/sql/create_context.html
Thanks!
Jim