Call a stored procedure in a PL/SQL block : Procedure Call « Stored Procedure Function « Oracle PL / SQL

1. Oracle PL / SQL
2. Stored Procedure Function
3. Procedure Call

Call a stored procedure in a PL/SQL block

   
SQL>
SQL>
SQL>  create or replace procedure my_proc as
  2    begin
  3      dbms_output.put_line ( 'Hello World' );
  4    end my_proc;
  5    /

Procedure created.

SQL>
SQL>
SQL>
SQL>  set serverout on
SQL>
SQL>  begin
  2      my_proc;
  3    end;
  4    /
Hello World

PL/SQL procedure successfully completed.

SQL>

   
    
  

Related examples in the same category