I have a report running on 10g application server. A value for the report parameter is passed to reports from forms. It is stored in the package variable by the code written in before report param trigger. This PL/SQL package variable is used in where conditions of the report parameter's list item's select queries. The value of PL/SQL variable is set by first user is being reset by another user who runs the report. The changes done by another user to the PL/SQL package variable is seen by the first user. The PL/SQL variable is declare in the package specification defined in the database.

How to maintain the values of this PL/SQL variable unique by the forms server sessions?

can any one help please

Regards
John