why not store the value in a database table?
--
Niall Litchfield
Oracle DBA
Audit Commission Uk
"Fabio GRANDE" <fabiog_at_fileita.it> wrote in message
news:9sb97s$mhq$1_at_fe1.cs.interbusiness.it...
> 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
>
Received on Wed Nov 07 2001 - 06:50:30 CST
