How To Define a Sub Procedure?
A sub procedure is a named procedure defined and used inside another procedure or function. You need to define a sub procedure in the declaration part of the enclosing procedure or function. Sub procedure definition starts with the PROCEDURE key word. Here is a sample script showing you how to define and use a sub procedure:SQL> CREATE OR REPLACE PROCEDURE HR.DBA_WEEK AS2 PROCEDURE DBA_TASK (day VARCHAR2) AS3 BEGIN4 IF day = ‘MONDAY’ THEN5 DBMS_OUTPUT.PUT_LINE(’Checking log files.’);6 ELSIF day = ‘FRIDAY’ THEN7 DBMS_OUTPUT.PUT_LINE(’Rebuild indexes.’);8 ELSE9 DBMS_OUTPUT.PUT_LINE(’Reading some papers.’);10 END IF;11 END;12 BEGIN13 DBA_TASK(’MONDAY’);14 DBA_TASK(’TUESDAY’);15 END;16 /SQL> EXECUTE DBA_WEEK;Checking log files.Reading some papers.
