Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: globally visible variables in plsql package stored procedures
"Miquel Salvā" <msalva_at_3digits.es> wrote in message
news:1046879200.830312_at_srv0...
> Hi,
>
> I would like to know how to declare a variable in a plsql package so it's
> visible to all other procedures in that package, in order to assign a
value
> in one procedure and be able to use it in other procedures.
>
> If I declare the variable in the package body (not inside a procedure)
it's
> visible to all the procedures of the package. But trying to read from some
> procedure the value I have assigned to a variable in another procedure
> always returns null.
>
> Any ideas?
>
> Thank you.
>
>
> Miquel Salvā
> msalva_at_3digits.es
>
>
Declare it in the package header; then it's global, and persistent for the
life of the session, but of course not to other sessions. Is that what
you're looking for?
Regards,
Paul
Received on Wed Mar 05 2003 - 15:34:47 CST