Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Public variables

Re: Public variables

From: Ora600 <Ora600_at_users.forgesource.net>
Date: Sun, 25 Nov 2001 19:09:47 -0500
Message-ID: <3C01884B.7040305@users.forgesource.net>


Fabio GRANDE wrote:

> Hi all !
> I'm wondering if there's a way to declare public variables in an Oracle
> session.
> I would like to put a value in a variable during the execution of a LOGON
> trigger. This variable (and its value) should be visible to all the
> triggers/procs/functions that the user execute during its work.
> Is this possible ?
> Can someone explain me how I can do this ? (I'd appreciate also a link to
> get some explanation...)
> Thanx in advance
>
> --
> Fabio GRANDE
> f.grandeNOSPAM_at_poker.it
>
>

How about Packaged variables ? Please see the plsql developers documentation for more details.

HTH.
Ora600 Received on Sun Nov 25 2001 - 18:09:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US