Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Shared Package data between sessions
Geoff Dewhurst wrote:
> Hi,
>
> Does anyone know a way to share data ( ie variables ) in PL/SQL
> packages
> between sessions ( different clients ). I am heading towards the
> DBMS_PIPE
> package and but was just wondering if this is the best way to
> proceed...
>
> Thanks in advance.
>
> Geoff
> Geoff_at_Bass-Soft.com.au
Hi - I've used dbms_pipe to send messages to different clients. It works well - just know that reads are destructive and if your building some shared memory app you'll need to build a server process to support it. DBMS_ALERTS also is a good way to distribute data among clients, though it is transaction based, which uses a table and hits the redos, so if you plan to use it often stay away from alerts. I wrote a transactionless version of alerts you can view on my web page http://ourworld.compuserve.com/homepages/Innovative_Computing/ if you're interested. feel free to use as you wish. Received on Fri Sep 05 1997 - 00:00:00 CDT