Oracle PL/SQL Tutorial/Function Procedure Packages/Procedure Return

Return from a procedure

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>