RE: Sharing data between sessions

> From: Chuck Hamilton [mailto:chuckh_at_softhome.net]
>
> One of my developers wants to share data between sessions
> inside a package. Specifically he wants to set some sort of
> global variable in a package that session 1 executes, and
> when sessions 2,3...n fire a trigger he wants them to be able
> to read that variable. Is there an easy way to do this other
> than by using a table? I was thinking that java might have
> this ability but I don't know java at all. I know you can
> link a C program to a trigger and since this is on unix you
> could theoretically create a shared memory segment that the
> trigger would read but this sounds like to a lot of hoops to
> jump through.
>
> Any suggestions?

First, define "session".

A variable inside a package header is the usual solution to this.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremy Pulcifer
  INET: Jeremy.Pulcifer_at_kadiri.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).