Re: Can I initialize var like a .profile?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 11 Feb 2000 20:32:00 -0000
Message-ID: <950301298.14162.0.nnrp-04.9e984b29@news.demon.co.uk>

In Oracle 8.1 yes.

In fact this is almost what SYS_CONTEXT() and dbms_session.set_context are for.

You fire an ON-LOGON trigger (also new
in 8.1) to call a protected package that has been named as the only package
allowed to set that particular context.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Gonzalo wrote in message <881qkq$p5h$1_at_nnrp1.deja.com>...
>Hi,
>I want to set up some vars when a user connects to Oracle, and then use
>them in PL/SQL. Something like the UNIX .profile and scripts.
>
>Is this possible?
>
>Thanks, Gonzalo.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Feb 11 2000 - 14:32:00 CST