globally visible variables in plsql package stored procedures

[Quoted] [Quoted] 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 [Quoted] 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 [Quoted] 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 Received on Wed Mar 05 2003 - 16:45:48 CET