RTFM
The answer is listed in http://tinyurl.com/ij25 and http://tinyurl.com/ij2a and http://tinyurl.com/ij2d
have fun.
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
From: A Joshi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 30, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
Subject: ** scope for package variables
Hi,
I have a variable in a package and I am using it as a flag in another procedure and trigger. Depending on the flag some action will be done or skipped. Is it correct to assume that each user process (could be around 20 at a time) will have it's own value of the variable starting with the initialized value??? Or will one session affect the value of other sessions. What is the best way to initialize? Else what is a way to have a process wide flag which can be used to determine if certain actions can take place. I really have no other criteria to distinguish. Thank You all...
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
