Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql cartridge and global varibales
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
![]() |
![]() |