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?
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.”
|
Download Printable PDF. VALID exam to help you PASS. |
 |