Execute a procedure : Procedure « Function Procedure Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Function Procedure Packages
3. Procedure

SQL> set serveroutput on
SQL> CREATE or replace PROCEDURE my_first_proc IS
  2          greetings VARCHAR2(20);
  3  BEGIN
  4          greetings := 'Hello World';
  5          dbms_output.put_line(greetings);
  6  END my_first_proc;
  7  /


SQL>
SQL> EXECUTE my_first_proc;
Hello World

PL/SQL procedure successfully completed.

SQL>
SQL> BEGIN
  2          my_first_proc;
  3  END;
  4  /
Hello World

PL/SQL procedure successfully completed.

SQL>
SQL>