Re: share PL/SQL package variable across sessions?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 29 Mar 2002 19:40:49 +0100
Message-ID: <s6d9au8cp3t2m4fd4eisifraime9km7u68@4ax.com>

On Fri, 29 Mar 2002 10:14:16 -0800, "Kenny Yu" <kyu_at_biodiscovery.com> wrote:

>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
>

This is not possible. Global variables are visible to a session only. If you want to share your variables they need to be stored in a table, a real one.
Did you verify the keyword 'static' just doesn't exist in pl/sql I guess not.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Mar 29 2002 - 12:40:49 CST