Oracle
1Z0-151 · Question #32
The Orders form has three blocks: Orders, Orders_Items, and inventories. It also has a button labeled Next Block with a When-Pressed trigger. IF :SYSTEM.cursor_block = 'orders' THEN…
The correct answer is D. Change the block names to uppercase in the condition (IF ...THEN) statements. See the full explanation below for the reasoning.
Question
The Orders form has three blocks: Orders, Orders_Items, and inventories. It also has a button labeled Next Block with a When-Pressed trigger. IF :SYSTEM.cursor_block = 'orders' THEN GO_BLOCK('order_items'); ELSIF :SYSTEM.cursor_block = 'order_items' THEN GO_BLOCK('inventories'); ELSIF :SYSTEM.cursor_block = 'inventories' THEN GO_BLOCK ('orders'); END IF; The button is not functioning correctly; it does not cause navigation to occur. What must you do to fix the issue?
Options
- AChange all occurrences of :SYSTEM.cursor_block to :SYSTEM.trigger_block.
- BUse system variables in the GO_BLOCK statements.
- CChange the block names to uppercase in the GO_BLOCK statements.
- DChange the block names to uppercase in the condition (IF ...THEN) statements.
- Einstead of naming the block to navigate to, replace the GO_BLOCK built-in with NEXT_BLOCK
- FMove the code to a PL/SQL program unit.
How the community answered
(53 responses)- A11% (6)
- B6% (3)
- C4% (2)
- D77% (41)
- E2% (1)
Community Discussion
No community discussion yet for this question.