thanks a lot to all who replied !
DBAndrey
* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: 26 February 2002 23:24
To: Multiple recipients of list ORACLE-L
Andrey,
You can't make a PL/SQL variable value visible to all sessions.
You'll have to put the
Quick answer: You cannot.
Somewhat longer details: The implications of doing so are most likely not
really what you want. Ever noticed the Oracle latches You would need to
get into exactly the same trouble; who's allowed to write to that value?
Oracle doesn't expose an API to latching
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
[E
