Re: Sharing data between sessions

From: Tim Gorman <Tim_at_SageLogix.com>
Date: Mon, 03 Mar 2003 13:39:02 -0800
Message-ID: <F001.0055EF2E.20030303133902@fatcity.com>

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_at_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_at_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_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).
>

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

Received on Mon Mar 03 2003 - 15:39:02 CST