Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Function Procedure Packages

 

Use mixed notation to avoid the second parameter, but keep the first and third

SQL> SQL> create or replace procedure p_print(i_str1 VARCHAR2 :='hello',   2                                      i_str2 VARCHAR2 :='world',   3                                      i_end VARCHAR2  :='!' )   4  is   5  begin   6       DBMS_OUTPUT.put_line(i_str1||','||i_str2||i_end);   7  end;   8  / Procedure created. SQL> SQL> declare   2  begin   3     p_print('Hi',i_end=>'...'); -- mixed   4     p_print(i_str1=>'Hi',i_end=>'...'); -- pure named   5  end;   6  / Hi,world... PL/SQL procedure successfully completed. SQL>