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

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

SQL>
SQL>
SQL> create or replace procedure p_print (i_string  in VARCHAR2,i_replace in VARCHAR2 := 'new') is
  2  begin
  3     if i_string is null then
  4         return;
  5     end if;
  6     DBMS_OUTPUT.put_line(replace(i_string,'<in>', i_replace));
  7  end;
  8  /

Procedure created.

SQL>
SQL>
SQL> declare
  2      v VARCHAR2(50):= 'I just printed my <in> line!';
  3  begin
  4      p_print (v,'first');
  5      p_print (v,'second');
  6      p_print (v);
  7  end;
  8  /
I just printed my first line!
I just printed my second line!
I just printed my new line!

PL/SQL procedure successfully completed.

SQL>
SQL>