Question 21:
Morgan has a report and form on the EMP table. He updated the form by adding a display-only item P5_LOC, and a change event dynamic action on P5_DEPTNO to populate the item using Set Value with this SQL: select loc from dept where deptno = :P5_DEPTNO; When Morgan runs the page, he gets this error: apex_error_code: WWV_FLOW_DML.COLUMN_NOT_FOUND - original message: Column LOC not found in table EMP What should Morgan do to prevent this error?
Answer options:
A. Update P5_LOC and set Source Type to "Null". B. Update P5_LOC and set Source Database Column to DEPTNO. C. Update P5_LOC and set Source Type to Item and select Item P5_DEPTNO. D. Update P5_LOC and set Save Session State to "No." E. Update P5_DEPTNO and set Type to "Display Only."