Oracle Application Express 5: Developing Web Applications — Question 54

Susan created Page 10 as an interactive report, called Departments, on the DEPT table. She also created Page 11 as an interactive report on the EMP table, called Employees.
Susan would like to add a link in the Departments report (Page 10) that redirects to the Employees report (Page 11) and displays only employees for the selected department.
How would Susan set items in the link builder on Page 10 to correctly call the report on Page 11?

Answer options

• A. Set item name IR_DEPTNO and value to #DEPTNO#
• B. Set item name to :P11_DEPTNO and value to :P10_DEPTNO
• C. Set item name to :P11_DEPTNO and value to #DEPTNO#
• D. Set item name to :P10_DEPTNO and value to #DEPTNO#

Correct answer: C

Explanation

The correct answer is C because setting the item name to :P11_DEPTNO allows Page 11 to receive the department number as a parameter, while the value #DEPTNO# correctly retrieves the selected department number from Page 10. Option A is incorrect as IR_DEPTNO is not the correct item name for Page 11, while options B and D use the wrong item name or reference values from the wrong pages.