Databases Reference
In-Depth Information
If you reexamine the query you'll notice that the predicate,
where e.deptno = :p1 deptno
,
references P1_DEPTNO. In order for the report to reflect the new value you'll need to create a Dynamic
Action to set P1_DEPTNO's session value before the report is refreshed. To set the value in session state:
1.
Edit the Change DeptNo Dynamic Action.
2.
Add a true action by clicking the Add True Action button.
3.
Set the values as shown in Figure 7-34. The sequence number is set to
1
so that
it will be triggered before the report is refreshed. The action type is Execute
PL/SQL Code since it's the easiest way to set a value in session state. Click the
Create button to create the true action.
Figure 7-34.
Set P1_DEPTNO in session state
If you refresh the page and change the department the report should be updated. Figure 7-35 shows
the page when Accounting is selected as the department.
