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

Return from a procedure

   <source lang="sql">

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></source>