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?
Select an option, then click Submit answer.
-
○
Change all occurrences of :SYSTEM.cursor_block to :SYSTEM.trigger_block.
-
○
Use system variables in the GO_BLOCK statements.
-
○
Change the block names to uppercase in the GO_BLOCK statements.
-
○
Change the block names to uppercase in the condition (IF ...THEN) statements.
-
○
instead of naming the block to navigate to, replace the GO_BLOCK built-in with NEXT_BLOCK
-
○
Move the code to a PL/SQL program unit.
