Use mixed notation to avoid the second parameter, but keep the first and third : Parameters « Function Procedure Packages « Oracle PL/SQL Tutorial

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

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...
Hi,world...

PL/SQL procedure successfully completed.

SQL>
SQL>