Re: Can I initialize var like a .profile?

From: <markp7832_at_my-deja.com>
Date: Fri, 11 Feb 2000 21:18:19 GMT
Message-ID: <881ual$rtu$1@nnrp1.deja.com>

In article <881qkq$p5h$1_at_nnrp1.deja.com>, Gonzalo <GSegarra_at_iname.com> wrote:
> 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.
>

In the Oracle home sqlplus admin directory, $ORACLE_HOME/sqlplus/admin on UNIX there is a glogin.sql file that I use to set the sql prompt to the instance id when people log in, but using variables in pl/sql will probably require setting up a package specification and then referencing its variables from your routines. Thomas Kyte has posted several times on using global variables from a specification. If he does not see your post and reply to it you may be able to find his stuff in the archives.

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 11 2000 - 15:18:19 CST