Call a Sub Procedure in Oracle

Q

How To Call a Sub Procedure in Oracle?

✍: FYIcenter.com

A

To call a sub procedure, just use the sub procedure name as a statement. Here is another example of calling a sub procedure:

SQL> CREATE OR REPLACE PROCEDURE WELCOME AS       
  2    PROCEDURE WELCOME_PRINT(S CHAR) AS      
  3    BEGIN         
  4      DBMS_OUTPUT.PUT_LINE('Welcome to ' || S);  
  5    END;          
  6  BEGIN           
  7    WELCOME_PRINT('FYICenter');            
  8  END;            
  9  /

SQL> EXECUTE WELCOME;
Welcome to FYICenter

 

Creating Oracle PL/SQL Procedures and Functions

⇒⇒Oracle Database Tutorials

2016-10-17, 171👍, 0💬