Title: RE: Sharing data between sessions
In Oracle all data is session specific ... even package data ... sessions share the package code.
1. Use a small table to share the data.
or
2. Use dbms_pipe to receive request and send out data ... this will act as a pseudo package header for all
Title: RE: Sharing data between sessions
From: Chuck Hamilton [mailto:[EMAIL PROTECTED]]
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
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