Re: pl/sql cartridge and global varibales

From: <bonanos_at_yahoo.com>
Date: Thu, 01 Jul 1999 06:11:02 GMT
Message-ID: <7lf0ph$4t6$1@nnrp1.deja.com>

> The obvious answer is to put them into tables.
> If they are used frequently there should be
> virtually no disk i/o overhead.
>
> If you want a completely off-the-wall idea though,
> you could write a PL/SQL package that sets the
> global variables you want, then goes into a loop
> waiting on a pipe with a published name.
>
> Any other process that wants to handle a global
> variable could then send messages down the
> public pipe (passing a private pipe name for
> the reply).

Two other options are: cookies, and passing the values as parameters from one proc to the next. (Although these options are only global per user. (as such))

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 01 1999 - 01:11:02 CDT