Message-ID: <F001.0055EF2E.20030303133902@fatcity.com>
Date: Mon, 03 Mar 2003 13:39:02 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Tim Gorman" <Tim@SageLogix.com>
Subject: Re: Sharing data between sessions
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Chuck,

Depending on the intensity with which they'd be using this form of
inter-process communication, using a table may be the easiest and fastest
implementation method.

Other possibilities include (depending on desired functionality):
   * DBMS_PIPE package (i.e. semantics involve simple FIFO pipes for
transmittal to one or more consumers)
   * DBMS_AQ (advanced queuing) package (i.e. handles much more complex
business rules, multiple consumers, etc)
   * DBMS_APPLICATION_INFO packaged procedures READ_CLIENT_INFO and
SET_CLIENT_INFO

This last idea involves the DBMS_APPLICATION_INFO package and its ability to
set the value of the column CLIENT_INFO in the V$SESSION view.  This column
is VARCHAR2(64), so a session could place information there and then other
sessions could read it by querying from V$SESSION...

Don't discount the easiest solution (i.e. a table) so quickly...

Hope this helps...

-Tim

----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L@fatcity.com>
Sent: Monday, March 03, 2003 1:43 PM


> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> 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?
> - --
> Chuck
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP 8.0 - not licensed for commercial use: www.pgp.com
>
> iQA/AwUBPmO+jlVYIIV9CtSHEQKU1gCg01qayq76M7fZt07ffVQuPJXucIIAoKzn
> hO4Qrd/tk2mrJd6TYufjwejv
> =G56o
> -----END PGP SIGNATURE-----
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Chuck Hamilton
>   INET: chuckh@softhome.net
>
> 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@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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: Tim@SageLogix.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@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).