Previous Next JavaScript must be enabled to correctly display this content

## 16.7.7 About Referencing Session State Within a List of Values

Reference session state in a list of values by using bind variables.

While referencing session state makes a list of values a bit less reusable, Oracle still recommends this approach as a best practice. In the following example, the list of values only works if the item called `my_deptno` contains a valid department number.

    SELECT ename, empno FROM emp WHERE deptno = :P1_DEPTNO

Parent topic: Creating Lists of Values at the Application-Level