But sys_context gives you all the winning options,
as you can use a logon trigger to set the environment
from tables.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Adrian Billington wrote in message ...
>Alexander
>
>I was about to suggest using sys_context to set persistent session
>values but Jonathan beat me to it :)
>
>Tables are the easiest method from a maintenance and debug point of
>view, but if the values will NEVER change, then sys_context is a very
>elegant method.
>
>Regards
>
>Adrian
Received on Mon Mar 04 2002 - 13:57:14 CST
