16.7.5 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