Oracle
1Z0-141 · Question #133
View the Exhibit and examine the PL/SQL code. The code uses the valmess package, which should print out the employee's salary if it exceeds 2345. To resolve compiler or run-time errors and ensure…
The correct answer is D. Pass the Forms variable to the package function with the format :block_name.item_name. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the PL/SQL code. The code uses the valmess package, which should print out the employee's salary if it exceeds 2345. To resolve compiler or run-time errors and ensure that the code works as intended, what changes should you make to the trigger code?
Exhibit
Options
- ANo changes are required.
- BDelete the BEGIN and END keywords.
- CDefine an EXCEPTION section to handle exceptions.
- DPass the Forms variable to the package function with the format :block_name.item_name.
- EDefine a DECLARE section to declare PL/SQL variables.
How the community answered
(34 responses)- A12% (4)
- B3% (1)
- D79% (27)
- E6% (2)
Community Discussion
No community discussion yet for this question.