Re: Package "global" variable

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 10 Jul 2001 09:50:46 -0700
Message-ID: <9ifbp60134s@drn.newsguy.com>

In article <9if7lp$bg5$1_at_bcarh8ab.ca.nortel.com>, "Tom" says...
>
>Hi,
>
>Can someone tell me weather a "global" variable is shared by all users, or,
>every user has his own copy of the variable?
>
>Thanks for any help
>Tom
>
>

PLSQL is executed in much the same way an operating system runs code.

the TEXT (executable code) is shared by all the DATA (package global variables) are private to a session

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Tue Jul 10 2001 - 11:50:46 CDT