Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql cartridge and global varibales

Re: pl/sql cartridge and global varibales

From: Marc Mazerolle <informaze_at_sympatico.ca>
Date: Wed, 30 Jun 1999 17:11:58 GMT
Message-ID: <377A5169.3F954ECB@sympatico.ca>


Answer inline....

AleX wrote:

> OK, this is really a follow-up to my previous posting...
>
> So I read that pl/sql catridges behaves as expected and treats all
> requests as individual
> sessions. This means that if I use one package to run multiple
> procedures, I cannot really
> user global variables in them, since the package will be
> discarded/re-created for each request.

Not exactly. Packages are discarded for each session (not request). Global variable inside a package will initialized until the end of the session.

>
>
> Is there a smart way to pass global values between the requests in this
> case?
> Any suggestions are super-welcome!
>
> Thanx,
>
> Alex.
Received on Wed Jun 30 1999 - 12:11:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US