Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> share PL/SQL package variable across sessions?

share PL/SQL package variable across sessions?

From: Kenny Yu <kyu_at_biodiscovery.com>
Date: Fri, 29 Mar 2002 10:14:16 -0800
Message-ID: <ua9bmjg90egf22@corp.supernews.com>


Is it possible to share package level public items across sessions?

What I wish for is :

create package public_data_cache as

       [static-- visible to all] mirrored_data is table of my_type; end public_data_cache;

I borrowed the term 'static' from Java, which indicates one instance of a variable per system.

Kenny Received on Fri Mar 29 2002 - 12:14:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US