Andrey, You can't make a PL/SQL variable value visible to all sessions.
You'll have to put the value in a row in a table and commit it. Jack -------------------------------- Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -----Original Message----- Sent: Tuesday, February 26, 2002 2:44 PM To: Multiple recipients of list ORACLE-L Dear list ! How can i make a package variable visible to all sessions , please ? I.e. i have a package PPP that has a package variable VVV. There is a stored proc in the package , PPP.SP1 In this procedure i set the package variable VVV to some value. Now , i want all the sessions connected to the instance to be able to see this value of PPP.VVV . Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
