1. Create a button named, Submit.
2. Create a Page Process
(1)Category PL/SQL
(2)Give your Page Process a Name
(3)Sequence Determines when the process is fired
(4)Point On Submit - After Computations and Vailidations
(5)Type PL/SQL anonymous block
(8)When Button Pressed Select the button you created
(9)Create Process
2. Create a Page Process
(1)Category PL/SQL
(2)Give your Page Process a Name
(3)Sequence Determines when the process is fired
(4)Point On Submit - After Computations and Vailidations
(5)Type PL/SQL anonymous block
(6)Enter PL/SQL Page Process Paste your PL/SQL code here. For example,
DECLARE
BEGIN
INSERT INTO JOBS (JOBID,COMMENT) VALUES (:P2_JOBID,'OK');
IF :P2_TESTID is not null THEN
INSERT INTO TESTJOBS (TESTID,COMMENT) VALUES (:P2_TESTID,'GOOD');
END IF;
COMMIT;
END;
(7)Success Message Enter a message to display if needed
(8)When Button Pressed Select the button you created
(9)Create Process